select pro.pid,pro.spid,pro.username from v s e s s i o n s e s , v session ses,v sessionses,vprocess pro where ses.sid=&522 and ses.paddr=pro.addr;
oradebug setorapid 18
Using the Oracle process identifier:
oradebug setorapid
&
Using the Operating System process identifier:
oradebug setospid 23000
oradebug unlimit
oradebug event 10046 trace name context forever,level 12;
oradebug tracefile_name
oradebug event 10046 trace name context off;
oradebug close_trace