转自:http://blog.sina.com.cn/s/blog_61cd89f60102ef3u.html
oradebug setmypid
oradebug setospid
oradebug setorapid
oradebug unlimit
oradebug tracefile_name
oradebug session_event 10046 trace name context forever ,level 4--启用会话级10046
oradebug event 10046 trace name contextoff
oradebug event 10046 trace name context forever ,level 4
oradebug event 10046 trace name context off
alter session set events '10046 trace name context forever,level12';
--操作
alter session set events '10046 trace name context off';
--10g
select d.value || '/' || lower(rtrim(i.instance, chr(0))) ||'_ora_' ||
--11g
select value from v$diag_info where name='Default TraceFile';