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 vote170 views2 answers
Reseed sql identity
SQL
2 votes148 views1 answer
Mysql query unique column
SQL
0 vote152 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
1 vote158 views1 answer
Postgresql contains
SQL
0 vote121 views1 answer
Online sql compiler
SQL
2 votes212 views2 answers
Postgres set user as superuser
SQL
-1 vote151 views2 answers
Postgresql user permissions to database
SQL
0 vote148 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
28 votes152 views4 answers
Show tables mysql
SQL
2 votes146 views1 answer
Mysql sysdate
SQL