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.




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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s