IDENTIFYING YOUR TRACE FILE

Identifying the trace file is not a complex task. But its not very easy also.
Oracle helps in identifying the correct tracefile for a session.

ALTER SESSION SET tracefile_identifier=SANDEEP;

Then you can easily identify the file. Oracle will generate the file name like

sid_ora_pid_SANDEEP.trc

OR if you have session id,

You can query, v$session to check the column tracefile.

Hope this helps.

Regards
Sandeep Panchal.

No comments:

Post a Comment