How to Trace SQL Using oradebug
To collect the event 10046 trace file, the following syntax was used in SQLPlus:
step 1
get pid
step 2
step 1
get pid
step 2
Set trace level 10046, 12
SQL> connect / as sysdba
SQL > oradebug setospid $ospid
SQL > oradebug unlimit
SQL > oradebug event 10046 trace name context forever , level 12
SQL > ...enter your query here...
SQL > oradebug event 10046 trace name context off
SQL> oradebug tracefile_name
SQL > exit
SQL > oradebug event 10046 trace name context off
SQL> oradebug tracefile_name
SQL > exit
where ospid is the pid number from step 1
Notes :
Level
1 (SQL_TRACE),
4 (SQL_TRACE+BINDS),
8 (SQL_TRACE+WAITS),
12(SQL_TRACE+BINDS+WAITS)
Level
1 (SQL_TRACE),
4 (SQL_TRACE+BINDS),
8 (SQL_TRACE+WAITS),
12(SQL_TRACE+BINDS+WAITS)
Hope this helps. Regards Rupam
