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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment