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 vote156 views2 answers
Add new column after in sql
SQL
11 votes175 views2 answers
Safe mode off mysql
SQL
10 votes171 views1 answer
Query to find object dependencies in oracle
SQL
5 votes212 views1 answer
Oracle ora-00054 resource busy
SQL
1 vote164 views1 answer
Postgresql reset serial counter after deleting content
SQL
21 votes183 views4 answers
Add column mssql
SQL
0 vote162 views1 answer
Query on date sqlite flutter
SQL
1 vote169 views2 answers
How to enable error squiggles in vs code
SQL
11 votes158 views1 answer
Oracle insert into where
SQL
0 vote159 views2 answers
Azure sql-datenbank
SQL