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 AI Database 26ai, Release Update 23.7.

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