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 vote417 views2 answers
Remove mysql workbench ubuntu
SQL
2 votes347 views3 answers
How to pass password mysql command line
SQL
11 votes336 views1 answer
How to get ddl for materialized view
SQL
0 vote341 views1 answer
Oracle get running queries
SQL
0 vote345 views1 answer
Postgres data location
SQL
0 vote352 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote372 views1 answer
Multiple like values for single column postgres
SQL
0 vote378 views1 answer
Exit psql
SQL
4 votes340 views1 answer
Postgresql create table with index
SQL
0 vote341 views1 answer
Change default schema sql server
SQL