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

INSTANCE_ID

NUMBER

NOT NULL

Unique ID for the directive instance. The directive management engine automatically generates ID numbers.

INSTANCE_NAME

VARCHAR2(128)

NOT NULL

User-assigned name for the directive instance.

DIRECTIVE_NAME

VARCHAR2(128)

NOT NULL

Any value that further classifies this directive within a domain. The domain and the name form a unique key for the directive.

DESCRIPTION

VARCHAR2(4000)

Description of the ADDM system directive, shown in the language used by the current session


数据运维技术 » Oracle 视图 DBA_ADDM_SYSTEM_DIRECTIVES 官方解释,作用,如何使用详细说明