DBA_ENABLED_TRACES
displays information about enabled SQL traces.
Column | Datatype | NULL | Description |
---|---|---|---|
TRACE_TYPE |
VARCHAR2(21) |
Type of the trace:
|
|
PRIMARY_ID |
VARCHAR2(64) |
Primary qualifier (specific client identifier or service name) | |
QUALIFIER_ID1 |
VARCHAR2(48) |
Secondary qualifier (specific module name) | |
QUALIFIER_ID2 |
VARCHAR2(32) |
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 ) |
|
INSTANCE_NAME |
VARCHAR2(16) |
Instance name for tracing restricted to named instances |