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 vote130 views1 answer
How to select a row in sql
SQL
0 vote140 views1 answer
Template MySQL Zabbix agent
SQL
0 vote152 views1 answer
Provera dupliranih konatakata
SQL
0 vote154 views1 answer
ORACLE PARSE STRING
SQL
3 votes134 views1 answer
Select sequence oracle
SQL
0 vote129 views1 answer
Install squirrel sql ubuntu
SQL
1 vote119 views1 answer
Setval pgsql
SQL
0 vote78 views1 answer
Mysql convert column to uppercase
SQL
4 votes120 views1 answer
Mysql copy table with new name
SQL
25 votes140 views6 answers
How to change column name in mysql
SQL