Oracle 视图 DBA_ADVISOR_DIR_TASK_INST 官方解释，作用，如何使用详细说明
本站中文解释
ANCES
DBA_ADVISOR_DIR_TASK_INSTANCES是一个视图，可用于以结构化的方式显示实例任务的元信息。其每行表示任务实例，可用于查找已执行或正在执行的建议任务实例的ID。
该视图包含运行任务实例的配置数据，包括任务名称、实例ID、分配给该任务的参数和接收和反馈项等。有关每个字段的含义，请参阅Oracle Database Reference中提供的相关文档。
要使用该视图，必须先创建ADVISOR实例并且至少在系统中启动一个任务实例，然后执行以下查询：
SELECT * FROM DBA_ADVISOR_DIR_TASK_INSTANCES;
以上查询会返回系统中的所有任务实例的信息，包括实例ID、任务实例的参数、接收和反馈项等。
官方英文解释
DBA_ADVISOR_DIR_TASK_INST provides information about all task directive instances.
Related View
USER_ADVISOR_DIR_TASK_INST provides information about all task directive instances owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique id for directive. The directive management engine automatically generates ID numbers. |
|
|
|
|
Unique id for the directive instance. The directive management engine automatically generates ID numbers. |
|
|
|
|
A user-assigned name for the directive instance. |
|
|
|
|
Database user who owns the task instance. |
|
|
|
An advisor task identifier to which the directive instance is associated |
|
|
|
|
An advisor task to which the directive instance is associated. |
|
|
|
|
|
An XML document that gives meaningful default values for all parts of the directive. |
See Also:
“USER_ADVISOR_DIR_TASK_INST”
