oradebug采集进程或sid trace10046

select pro.pid,pro.spid,pro.username from v$sessionses,v$process 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