Oracle Database Discussions

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!

Trace file not being generated

oratestMar 28 2010 — edited May 4 2011

Hi,

I am using Oracle 10g Rel2.

I am trying to generate trace file for a session using DBMS_SYSTEM.

Firstly I used DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure to generate trace file for a session, but this was generating trace files in udump directory. Then i checked on net & found that we can not generate trace file this way for active sessions.

Then I tried using DBMS_SYSTEM.SET_ENV procedure, same results. This is also not generating trace files?

Any idea why this is happening? Moreover for around how much duration I should enable trace?

Thanks in advance.

This post has been answered by Lukasz Mastalerz on May 13 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2011

Added on Mar 28 2010

#general-database-discussions

16 comments

7,231 views