oracle sql trace

on line trace:
set autotrace on;
select * from app;
set autotrace off;

sql trace:
[sqlplus]
alter session set sql_trace = true;
select * from app;
alter session set sql_trace = false;
[command]
cd c:\oracle\admin\stanley\udump\
tkprof stanley_ora_3444.trc stanley_ora_3444.out aggregate=yes sys=no sort=prscpu
notepad stanley_ora_3444.out

timing:
set timing on;
set timing off;