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

9 votes162 views4 answers
Last mysql
SQL
0 vote100 views1 answer
Oracle list all stored procedures
SQL
0 vote173 views1 answer
Oracle job session
SQL
2 votes145 views1 answer
Oracle virtual column
SQL
1 vote159 views1 answer
Table valued functions in sql
SQL
0 vote169 views1 answer
Sql_inner_join
SQL
1 vote147 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
23 votes152 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote139 views1 answer
Power bi find all ids not in other tables
SQL
3 votes94 views2 answers
Mysql sum with condition
SQL