Thanks for the question.
Asked: November 10, 2018 - 10:36 am UTC
Last updated: November 12, 2018 - 11:02 am UTC
Version: 12c
Viewed 1000+ times
EODA@muphy>select c.value || '/' || d.instance_name || '_ora_' || a.spid || '.trc' trace from V $process a, V $session b, V $parameter c, V $instance D where a.addr=b.paddr and b.audsid=userenv('session id') and c.name='user_dump_dest';
select value from v$diag_info where name = 'Diag Trace'; VALUE /ade/b/2757588126/oracle/log/diag/rdbms/db122/db122/trace
select tracefile from v$process a, V$session b where a.addr = b.paddr and b.audsid = sys_context ( 'USERENV', 'SESSIONID' ); TRACEFILE /ade/b/2757588126/oracle/log/diag/rdbms/db122/db122/trace/db122_s000_50940.trc
A reader, November 13, 2018 - 2:58 pm UTC
Need more information on Administration? Check out the Administrators guide for the Oracle Database