Where Is My Trace ?

This statements return us the path to the trace for current session;

 

SELECT

para.value || ‘/’ || LOWER(SYS_CONTEXT(‘userenv’,’instance_name’)) ||

‘_ora_’ || p.spid || ‘.trc’ AS “TRACE LOCATION”

FROM v$session s,

v$process p,

v$parameter para

WHERE para.name = ‘user_dump_dest’

AND s.paddr = p.addr

AND s.audsid = SYS_CONTEXT(‘USERENV’, ‘SESSIONID’);

 

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s