[Home] [Help] [Dependency Information]
Object Name: | DBA_ENABLED_TRACES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Information about enabled SQL traces
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 |
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
FROM SYS.DBA_ENABLED_TRACES;
|
|
|