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 vote322 views2 answers
Sqlite
SQL
2 votes327 views1 answer
Oracle index size
SQL
4 votes348 views4 answers
Oracle tablespace tables list
SQL
0 vote333 views1 answer
Mysql count by month
SQL
0 vote364 views1 answer
Show tables in cassandra cql
SQL
5 votes329 views1 answer
Update sql user password
SQL
0 vote351 views1 answer
Consulta alias con inner join
SQL
4 votes391 views2 answers
Postgresql float data type
SQL
0 vote363 views1 answer
Sql sum show 0 result
SQL
0 vote322 views1 answer
Oracle call a function in a insert statement
SQL