Answers for "oracle trace file location"

SQL

2

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');

Posted by: Guest on September-01-2021

Source

Code answers related to "oracle trace file location"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#