Sunday, August 12, 2012

How to enable or disable user tracing

User tracing is enabled or disabled at the session or instance level by using the following commands and

• Session level using the ALTER SESSION command: ALTER SESSION SET SQL_TRACE = TRUE
• Session level by executing DBMS procedure: dbms_system.SET_SQL_TRACE_IN_SESSION
• Instance level by setting the initialization parameter: SQL_TRACE = TRUE

No comments:

Post a Comment