创建一个获取当前trace文件的函数
- create or replace function current_trace return varchar2
- is
- v_file varchar2(100);
- begin
- select par.value||'/'||ins.instance_name||'_ora_'||pro.spid||'.trc' into v_file from
- v$parameter par,
- v$instance ins,
- v$process pro,
- v$session ses,
- v$mystat mys
- where par.name = 'user_dump_dest' and
- pro.addr=ses.paddr and
- ses.sid = mys.sid and
- mys.statistic#=0;
- return (v_file);
- end current_trace;
- /
- SQL> select current_trace from dual;
- CURRENT_TRACE
- -----------------------------------------------------------
- /opt/app/oracle/diag/rdbms/db2/db2/trace/db2_ora_9456.trc
SQL > select tracefile from v$process where addr in (select paddr from v$session where sid in (select sid from v$mystat))
我发现这个也可以。。。。
转载于:https://blog.51cto.com/feixiong/772580