DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_ENABLED_TRACES

Object Details
Object Name: CDB_ENABLED_TRACES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about enabled SQL traces in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRACE_TYPE VARCHAR2 (21)
Type of the trace (CLIENT_ID, SERVICE, etc.)
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)
TRUE of waits are traced
BINDS VARCHAR2 (5)
TRUE of binds are traced
PLAN_STATS VARCHAR2 (10)
INSTANCE_NAME VARCHAR2 (16)
Instance name for tracing restricted to named instances
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRACE_TYPE
,      PRIMARY_ID
,      QUALIFIER_ID1
,      QUALIFIER_ID2
,      WAITS
,      BINDS
,      PLAN_STATS
,      INSTANCE_NAME
,      CON_ID
FROM SYS.CDB_ENABLED_TRACES;

Dependencies

[top of page]

SYS.CDB_ENABLED_TRACES does not reference any database object

SYS.CDB_ENABLED_TRACES is referenced by following:

SchemaPUBLIC
SynonymCDB_ENABLED_TRACES