Oracle 11g 获取当前的Trace文件
Oracle 11g 获取当前的Trace文件
Oracle 11g创建一个获取当前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
评论暂时关闭