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