DBA_ADVISOR_DIR_TASK_INST

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
`DIRECTIVE_ID`	`NUMBER`	`NOT NULL`	Unique id for directive. The directive management engine automatically generates ID numbers.
`SEQ_ID`	`NUMBER`	`NOT NULL`	Unique id for the directive instance. The directive management engine automatically generates ID numbers.
`INSTANCE_NAME`	`VARCHAR2(30)`	`NOT NULL`	A user-assigned name for the directive instance.
`USERNAME`	`VARCHAR2(30)`	`NOT NULL`	Database user who owns the task instance.
`TASK_ID`	`NUMBER`		An advisor task identifier to which the directive instance is associated
`TASK_NAME`	`VARCHAR2(30)`		An advisor task to which the directive instance is associated.
`DATA`	`CLOB`	`NOT NULL`	An XML document that gives meaningful default values for all parts of the directive.