DBA_ENABLED_TRACES

DBA_ENABLED_TRACES displays information about enabled SQL traces.

Column	Datatype	Description
`TRACE_TYPE`	`VARCHAR2(21)`	Type of the trace: `CLIENT_ID` `SERVICE` `SERVICE_MODULE` `SERVICE_MODULE_ACTION` `DATABASE`
`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