Tom Kyte’s following routine is a utility that can be used to to collect statistics of a session at the start, middle and at the end.
http://asktom.oracle.com/pls/asktom/ASKTOM.download_file?p_file=6551378329289980701

• trace
• Tuning