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.