Oracle教程 2023-04-05

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

Oracle视图DBA_ADDM_TASK_DIRECTIVES用来查看Automatic Database Diagnostic Monitor(ADDM)任务指令的细节。ADDM任务指令之间相互依赖，可以考虑用这个视图来查看和分析现有ADDM任务指令的顺序执行。

用法：

（1）查询视图所有列：

SELECT * FROM dba_addm_task_directives;

（2）查询指定任务下所有指令：

SELECT * FROM dba_addm_task_directives WHERE task_name = ‘TaskName’;

DBA_ADDM_TASK_DIRECTIVES displays information about all ADDM task directives in the database.

Related View

USER_ADDM_TASK_DIRECTIVES displays information about ADDM task directives owned by the current user.

Column	Datatype	NULL	Description
`TASK_ID`	`NUMBER`		An ADDM advisor task identifier to which the directive instance is associated
`TASK_NAME`	`VARCHAR2(128)`		An ADDM advisor task to which the directive instance is associated
`USERNAME`	`VARCHAR2(128)`	`NOT NULL`	Database user who owns the ADDM task instance
`SEQ_ID`	`NUMBER`	`NOT NULL`	Unique ID for the directive instance. The directive management engine automatically generates ID numbers.
`INSTANCE_NAME`	`VARCHAR2(128)`	`NOT NULL`	A user-assigned name for the ADDM task 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 task directive, shown in the language used by the current session