Oracle 视图 DBA_ADDM_SYSTEM_DIRECTIVES 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图:DBA_ADDM_SYSTEM_DIRECTIVES
用途:DBA_ADDM_SYSTEM_DIRECTIVES视图用于查询在自动性能诊断器(ADDM)运行过程中收集的系统配置指令,以及它们的描述和有效值。
使用方法:
1. 查询系统配置指令:
SELECT directive_name,description,value
FROM dba_addm_system_directives;
2. 查询特定配置指令:
SELECT directive_name,description,value
FROM dba_addm_system_directives
WHERE directive_name = ‘WORKLOAD_REPLAY_DISABLED’;
官方英文解释
DBA_ADDM_SYSTEM_DIRECTIVES
displays information about global instances for ADDM system directives.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique ID for the directive instance. The directive management engine automatically generates ID numbers. |
|
|
|
User-assigned name for the directive instance. |
|
|
|
Any value that further classifies this directive within a domain. The domain and the name form a unique key for the directive. |
|
|
Description of the ADDM system directive, shown in the language used by the current session |