windows 得到trace 文件路径:select dst '\' lower(dbname) '_ora_' process '.trc'
from (select (select value from v$parameter where name = 'user_dump_dest') dst,
(select name from v$database where rownum = 1) dbname,
p.spid process
from v$process p, v$session s
where p.addr = s.PADDR
and s.sid in (select sid from v$mystat where rownum = 1));
linux 得到trace 文件路径:
select dst '/' lower(dbname) '_ora_' process '.trc'
from (select (select value from v$parameter where name = 'user_dump_dest') dst,
(select name from v$database where rownum = 1) dbname,
p.spid process
from v$process p, v$session s
where p.addr = s.PADDR
and s.sid in (select sid from v$mystat where rownum = 1));