Oracle 10g:
v$mystat --> sid --> v$session --> paddr --> v$process --> spid
select a.value
||'/'
||(select instance_name from v$instance)
||'_ora_'
|| c.spid
||'.trc'
from v$parameter a,v$session b,v$process c
where a.name='user_dump_dest'
and b.sid=(select sid
from v$mystat
where rownum=1)
and b.paddr=c.addr;
Oracle 11g:
select value from v$diag_info where name='Diag Trace';
v$mystat --> sid --> v$session --> paddr --> v$process --> spid
select a.value
||'/'
||(select instance_name from v$instance)
||'_ora_'
|| c.spid
||'.trc'
from v$parameter a,v$session b,v$process c
where a.name='user_dump_dest'
and b.sid=(select sid
from v$mystat
where rownum=1)
and b.paddr=c.addr;
Oracle 11g:
select value from v$diag_info where name='Diag Trace';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28675539/viewspace-1170341/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28675539/viewspace-1170341/