Performance: How to enable Database trace for the Apps session which is already started running
Kanda-Oracle
Posts: 5,156 Silver Crown
Comments
-
Thank you for this input N Kandasamy. This can be very helpful.
Think it would be good to clarify that LEVEL 8 in following statement :
"ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 8"will enable tracing capturing Waits (trace will show wait events and relative information, as well as normal SQL tracing).You may also substitute LEVEL 12 in above ORADEBUG statement. This will capture both Binds and Waits.Best,DonL0 -
Thank you for this input N Kandasamy. This can be very helpful.
Hi DonL,Think it would be good to clarify that LEVEL 8 in following statement :
"ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 8"will enable tracing capturing Waits (trace will show wait events and relative information, as well as normal SQL tracing).You may also substitute LEVEL 12 in above ORADEBUG statement. This will capture both Binds and Waits.Best,DonLThanks a lot for the feedback.Yes.Thanks for mentioning it. Level 12 will be helpful if you wanted to get bind variables which allows to run the sql statement from SQL*Plus. However I prefer level 8 for troubshooting performance which is less expensive operation.Thank you,N Kandasamy0 -
Thank you for this input N Kandasamy. This can be very helpful.
Hi All,Think it would be good to clarify that LEVEL 8 in following statement :
"ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 8"will enable tracing capturing Waits (trace will show wait events and relative information, as well as normal SQL tracing).You may also substitute LEVEL 12 in above ORADEBUG statement. This will capture both Binds and Waits.Best,DonLThere was a typo. Sorry about that.4.2) tkprof tracefile.trc output.txt explain=apps/<passwd> sort=prsela,exeela,fchelThe above line should read as4.2) tkprof tracefile.trc output.txt explain=apps/<passwd> sort=prsela,exeela,fchelaThis procedure helps when you want to troubleshoot a session which is performing slow , Hangs (Long running).Thank you,N Kandasamy0