如何获取 Trace file

如何获取Trace File ?  总结了一下, 有以下几种方式:

1.  select tracefile

from v$process

where addr in (select paddr

from v$session

where sid in(select sid

from v$mystat));

2. select value from v$diag_info where name  = 'Default Trace File' ;

3.  Select RTRIM ( C.VALUE, '/') ||'/' || D.INSTANCE_NAME || '_ora_' || LTRIM (TO_CHAR(A.SPID) ||'.trc'

      from v$process a,

             v$session b,

            v$parameter c,

            v$instance d

   where a.addr = b.paddr

       and b.audsid = SYS_CONTEXT('userenv','sessionsid')

       and c.name = 'user_dump_dest';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/283126/viewspace-2131948/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/283126/viewspace-2131948/