My Oracle Support Banner

General SQL_TRACE / 10046 trace Gathering Examples (Doc ID 1274511.1)

Last updated on MAY 19, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.2.0.3 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Goal

This article illustrates numerous methods by which session tracing may be initiated.


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 
 Pre-requisites for successful tracing
 Tracing the Current Session
 SQL_TRACE
 10046
 DBMS_SUPPORT
  Tracing from Another Session
 Using "dbms_system.SET_BOOL_PARAM_IN_SESSION"
 Using "dbms_system.set_ev"
 Using "dbms_system.set_sql_trace_in_session"
 Using "sys.dbms_monitor"
 Using Oradebug (as SYS)
 Use a Logon Trigger
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.