获取跟踪文件名称的脚本gettrcname.sql-LinuxOracle
SELECT a.VALUE || b.SYMBOL || c.instance_name || '_ora_' || d.spid ||'.trc' trace_file
FROM (SELECT VALUE FROM V$PARAMETER WHERE NAME = 'user_dump_dest') a,
(SELECT SUBSTR(VALUE, -6, 1) SYMBOL FROM V$PARAMETER
WHERE NAME = 'user_dump_dest') b,
(SELECT INSTANCE_NAME FROM V$INSTANCE) c,
(SELECT SPID FROM v$SESSION S, V$PROCESS P, V$MYSTAT M
WHERE S.PADDR = P.ADDR
AND S.SID = M.SID
AND M.STATISTIC# = 0) d;
TRACE_FILE
------------------------------------------------------------
/DBBK/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_20101.trc
页:
[1]