DBA_ENABLED_TRACES displays information about enabled SQL traces.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Type of the trace:
|
|
|
|
|
Primary qualifier (specific client identifier or service name) |
|
|
|
|
Secondary qualifier (specific module name) |
|
|
|
|
Additional qualifier (specific action name) |
|
|
|
|
Indicates whether waits are traced ( |
|
|
|
|
Indicates whether binds are traced ( |
|
|
|
|
Instance name for tracing restricted to named instances |
See Also:
The following support note on My Oracle Support at http://www.myoraclesupport.com for more information about using the DBMS_MONITOR PL/SQL package and the DBA_ENABLED_TRACES view:
Note 293661.1 "Tracing Enhancements In 10g and 11g Using DBMS_MONITOR"
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_MONITOR package