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

2 votes45 views1 answer
Enum in SQL Server
SQL
2 votes49 views1 answer
How to find constraints on a table in oracle
SQL
7 votes56 views2 answers
What is sql clause
SQL
0 vote51 views1 answer
Show create table in postgresql
SQL
2 votes49 views2 answers
Convert_tz mysql
SQL
0 vote45 views1 answer
Where date in datetime mysql
SQL
0 vote79 views1 answer
Sql quary stuf
SQL
0 vote36 views1 answer
Microsoft sql server python connection
SQL
1 vote46 views2 answers
Find a column in all tables mysql
SQL
22 votes47 views3 answers
Remove all records from table mysql
SQL