Oracle教程 2023-02-24

Oracle 视图 DBA_ENABLED_TRACES 官方解释，作用，如何使用详细说明

视图DBA_ENABLED_TRACES显示了注册在当前实例环境中的跟踪定义，它可以帮助检测多个活动结果之间的模式、及时采取措施解决可能出现的性能或可靠性问题等。

使用方法：

该视图可以使用管理员对和调整运行状况的数据库的跟踪作为一种技术，以及在Reorganize结果时改善追踪的状态。可以使用以下查询来检查是否存在允许的跟踪：

SELECT * FROM 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(64)`	Secondary qualifier (specific module name)
`QUALIFIER_ID2`	`VARCHAR2(64)`	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`)
`PLAN_STATS`	`VARCHAR2(10)`	Indicates whether cursor execution statistics are traced. Possible values include: `ALL_EXEC`: Execution statistics are dumped at each cursor execution `NEVER`: Execution statistics are never dumped `FIRST_EXEC`: Execution statistics are dumped during the first execution of the cursor. This is the default behavior.
`INSTANCE_NAME`	`VARCHAR2(16)`	Instance name for tracing restricted to named instances