SQL trace

set autotrace on statistics
set autotrace traceonly statistics
set lines 340
COLUMN plan_plus_exp format a300
COLUMN parent_id_plus_exp format 9990
COLUMN id_plus_exp format 9990
set autotrace traceonly explain
alter system set timed_statistics=true;
SQL> exec dbms_system.set_sql_trace_in_session(sid,serial#,TRUE)
SQL> exec dbms_system.set_sql_trace_in_session(sid,serial#,FALSE)