Oracle trace file

SELECT s.SID,
       s.SERIAL#,
       pa.VALUE || '/' || lower(sys_context('userenv', 'instance_name')) ||
       '_ora_' || p.SPID || '.trc' AS TRACE_FILE
FROM V$SESSION s, V$PROCESS p, V$paRAMETER pa
WHERE pa.NAME = 'user_dump_dest'
  AND s.paDDR = p.ADDR
  AND s.AUDSID = sys_context('USERENV', 'SESSIONID');

Source: oracle-base.com

Similar codes

0 vote95 views1 answer
Sql select by content lenght
SQL
12 votes91 views4 answers
Mysql version
SQL
0 vote94 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
6 votes89 views1 answer
Oracle list primary key
SQL
2 votes88 views2 answers
Postgresql date at timezone
SQL
0 vote98 views2 answers
Connect to mysql server mac terminal
SQL
0 vote97 views1 answer
Oracle sql date winter time
SQL
2 votes114 views1 answer
Mysql now format
SQL
1 vote102 views1 answer
Oracle previous year
SQL
0 vote100 views1 answer
Insert overwrite table in mysql in nifi
SQL