Other Way Of Get My Trace

To find the trace file more easily run:
alter session set tracefile_identifier=’10046trace’;
alter session set timed_statistics = true;
alter session set statistics_level=all;
alter session set max_dump_file_size = unlimited;
alter session set events ‘10046 trace name context forever,level 12’;
Run the problem query now.
Disconnecting the session will stop the session tracing.
show parameter dump
this shows the USER_DUMP_DEST.
cd to this directory and search for a trace file which name contains string 10046 trace.

 

HTH – Antonio NAVARRO

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