SQL Debug

on July 27, 2016 at 11:23 am
Posted In: 12c Performance (Cat)

SQL> ORADEBUG SETOSPID 10189

Oracle pid: 81, Unix process pid: 10189, image: oracle@nnn.com

SQL> ORADEBUG TRACEFILE_NAME;

/u01/app/oracle/diag/rdbms/dbn/dbn_id/trace/db_id_ora_10189.trc

SQL> oradebug event 10046 trace name context forever, level 12

SQL> oradebug event 10046 trace name context off

 

SQL> oradebug session_event 10046 trace name context forever,level 12

 

SQL> oradebug event 10046 trace name context off

 

 

Â