5.334 DBA_ENABLED_TRACES

DBA_ENABLED_TRACES displays information about enabled SQL traces.

Column Datatype NULL Description

TRACE_TYPE

VARCHAR2(21)

Type of trace:

  • CLIENT_ID

  • DATABASE

  • SERVICE

  • SERVICE_MODULE

  • SERVICE_MODULE_ACTION

PRIMARY_ID

VARCHAR2(64)

Primary qualifier (specific client identifier or service name)

QUALIFIER_ID1

VARCHAR2(64)

Secondary qualifier (specific module name)

QUALIFIER_ID2

VARCHAR2(64)

Additional qualifier (specific action name)

WAITS

VARCHAR2(5)

Indicates whether waits are traced (TRUE) or not (FALSE)

BINDS

VARCHAR2(5)

Indicates whether binds are traced (TRUE) or not (FALSE)

PLAN_STATS

VARCHAR2(10)

Indicates whether cursor execution statistics are traced. Possible values include:

  • ALL_EXEC: Execution statistics are dumped at each cursor execution

  • FIRST_EXEC: Execution statistics are dumped during the first execution of the cursor. This is the default behavior.

  • NEVER: Execution statistics are never dumped

INSTANCE_NAME

VARCHAR2(16)

Instance name for tracing restricted to named instances

USER_TYPEFoot 1

VARCHAR2(7)

  

Indicates the type of user that is traced:

  • COMMON - Only common users are traced

  • LOCAL - Only local users are traced

  • ANY - Both common and local users are traced

Footnote 1 This column is available starting with Oracle Database 23ai, Release Update 23.7.

See Also:

Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_MONITOR package