10046获取执行trc
alter session set current_schema=xxxx ; alter session set tracefile_identifier='3mn7p3hcprt8m'; alter session set events '10046 trace name context forever,level 1'; sqltext alter session set events '10046 trace name context off'; select distinct(m.sid),p.pid,p.tracefile from v$mystat m,v$session s,v$process p where m.sid=s.sid and s.paddr=p.addr; tkprof 3mn7p3hcprt8m_10046.trc 3mn7p3hcprt8m_10046.txt