pid oradebug

SQL> oradebug setospid 22363
Oracle pid: 207, Unix process pid: 22363, image: oracle@orcl

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

SQL> oradebug tracefile_name
/oracle/app/oracle/product/920/rdbms/log/tracefile_name.trc

SQL> oradebug event 10046 trace name context off

$tkprof tracefile_name.trc explain=user/passwd sys=no output=1.lis