Comments

Tuesday, May 28, 2013

Find Trace File location using SQL

Posted by at 3:33 AM Read our previous post
You can use the following script to find the location of the trace file that the current session writes.


SELECT      u_dump.value || '/' || instance.value || '_ora_' ||
            v$process.spid|| nvl2(v$process.traceid, '_' ||  
            $process.traceid, null ) || '.trc'"Trace File"
FROM       V$PARAMETER u_dump
CROSS JOIN V$PARAMETER instance
CROSS JOIN V$PROCESS
JOIN       V$SESSION on v$process.addr = V$SESSION.paddr
WHERE      u_dump.name = 'user_dump_dest'
AND        instance.name = 'instance_name'
AND        V$SESSION.audsid=sys_context('userenv','sessionid'); 


You may also like to read      Find Profile Option values using SQL queries
                                             Process to Debug a Concurrent Request
                                             Checking the File Versions with SQL Query

                                             Sending Email using PL/SQL Procedure

No comments:

Post a Comment

© Oracle Apps CRM is powered by Blogger - Template designed by Stramaxon - Best SEO Template