4.230 DBA_ENABLED_TRACES
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 ( |
|
|
|
Indicates whether cursor execution statistics are traced. Possible values include:
|
|
|
|
Instance name for tracing restricted to named instances |
See Also:
-
My Oracle Support note 293661.1 “Tracing Enhancements Using DBMS_MONITOR (In 10g, 11g and Above)” at the following URL for more information about using the
DBMS_MONITOR
PL/SQL package and theDBA_ENABLED_TRACES
view: -
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_MONITOR
package