使用events id
alter session set events '10046 trace name context forever,level 12';
alter session set events '10046 trace name context off';
使用events name
alter session set events 'err_num trace name errorstack level 10';
alter session set events 'err_num trace name errorstack off'
err_num=报错代码,如ORA-00942 应该在err_num填入942
使用dbms_support(trace别的session):
exec dbms_support.start_trace_in_session(sid=>XX,seiral#=>XXX,wait=>true,binds=>true);
exec dbms_support.stop_trace_in_session(sid=>XX,seiral#=>XXX);
使用oradebug(trace别的session):
oradebug setospid (PID 能从ps -ef 中得出)
oradebug unlimit
oradebug event 10046 trace name context forever,level 12;
oradebug event 10046 trace name context off;
使用dbms_system.set_ev:
exec dbms_system.set_ev(sid,serial#,10046,trace_level,'username');
exec dbms_system.set_ev(sid,serial#,10046,0,'username');
获得dump文件
select value
||'/'
||(select value from v$parameter where name='db_unique_name')
||'_ora_'
||(select spid
from v$process
where addr=(select paddr from v$session
where sid=(select sid from v$mystat where rownum=1)))
||'.trc' dump_file_name
from v$parameter where name='user_dump_dest';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/18841027/viewspace-1586423/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/18841027/viewspace-1586423/