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 vote188 views3 answers
Between keyword sql
SQL
0 vote179 views1 answer
Sql server port 1434
SQL
50 votes280 views6 answers
Install mysql on ubuntu
SQL
0 vote207 views1 answer
Show table structure mysql console
SQL
-2 votes189 views2 answers
Union vs union all in sql
SQL
0 vote214 views1 answer
Sqlcl format
SQL
4 votes178 views1 answer
Sql any
SQL
0 vote191 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote186 views1 answer
How to reset the database value in SQL server
SQL
2 votes175 views2 answers
How to check database username and password in postgresql
SQL