explain.sql

explain plan 
set statement_id='JACK'
into plan_table
for
SELECT * FROM aa WHERE OBJECT_NAME LIKE '%A%';

select lpad(' ',2*LEVEL)||operation||' '||options||' '||object_name "Q_PLAN"
from smithj.plan_table
where statement_id='JACK'
CONNECT BY PRIOR id=parent_id
and statement_id='JACK'
START WITH id=1;


/***
alter session set sql_trace=true;
execute dbms_session.set_sql_trace(true);

-- Set trace for a particular session
Run session to find out session_id, serial_id
then
execute sys.dbms_system.set_sql_trace_in_session(11,155,true)

/*** Tkprof

tkprof c:\oracle\admin\wenjdn\udump\ora00308.trc aa.txt sys=no sort=execpu print=3