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!

How to check if a SQL TRACE is enabled

593075Oct 10 2007 — edited Oct 11 2007

Hello,

i wanted to learn about SQL TRACE and came across the following question and could not find an answer to it:

How can i check if SQL TRACE is currently enabled (especially when tracing another users session with "DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION") ?

I'm asking because i want to avoid unnecessary load on the database.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2007

Added on Oct 10 2007

#general-database-discussions

4 comments

5,943 views