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 views3 answers
Remove folders from remote git
SQL
0 vote313 views1 answer
Adding primery key constraint to a column
SQL
15 votes300 views2 answers
Sql order by multiple columns
SQL
18 votes301 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote280 views1 answer
Oracle sql date summer time
SQL
10 votes330 views4 answers
Else if mysql
SQL
0 vote303 views1 answer
Double in sql server example
SQL
7 votes314 views2 answers
Mysql get year from date
SQL
0 vote301 views4 answers
Database stuck at restoring state
SQL
2 votes318 views4 answers
Mysql get all tables row count
SQL