Oracle trace session

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 vote411 views1 answer
Eliminate zero from integer mysql
SQL
3 votes338 views2 answers
Having in mysql
SQL
0 vote368 views1 answer
Regex any word except sql
SQL
0 vote362 views1 answer
Top frequency in sql server
SQL
0 vote559 views1 answer
Dublicate row sql
SQL
0 vote309 views1 answer
CREATE MULTIPLE FK
SQL
0 vote365 views1 answer
Do you know sql
SQL
5 votes404 views1 answer
Mysql count lines
SQL
0 vote352 views1 answer
Oracle date summer time
SQL
1 vote351 views1 answer
Describe table in sql
SQL