SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find out TRACE file of a session

Anjan SilSep 23 2008 — edited Jun 9 2010

Hi,
I'm generating trace file of a session (not the session where I'm login into) by the following command..
EXEC DBMS_SUPPORT.start_trace(sid=>123, serial=>1234, waits=>TRUE, binds=>FALSE);

Now, after start tracing I cannot find out the trace file which is generated for SID=123.
Can you help me to find out the trace file? I mean, is there anyway to find out the trace file name for SID=123?

Thanks,
Anjan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2010

Added on Sep 23 2008

9 comments

9,063 views