Oracle教程 2023-02-24

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

本站中文解释

Oracle视图DBA_ADVISOR_ACTIONS用于查看行动指南所提出的建议和推荐的行动。它提供了给定行动指南及其具体建议的信息。其中包含有关EXECUTION_ID、TASK_NAME、ACTION、ACTION_CATEGORY和ACTION_STATUS等列。通过此视图，DBA能从按照建议进行的行动中发现某些行动失败的信息。DBA可以使用DBA_ADVISOR_ACTIONS视图识别和下达需要立即实施的行动建议，更新其状态，以确保视图的准确性。

官方英文解释

DBA_ADVISOR_ACTIONS displays information about the actions associated with all recommendations in the database.

Each action is specified by the COMMAND and ATTR1 through ATTR6 columns. Each command defines how the attribute columns will be used.

Related View

USER_ADVISOR_ACTIONS displays information about the actions associated with the recommendations owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		Owner of the task
`TASK_ID`	`NUMBER`	`NOT NULL`	Identifier of the task
`TASK_NAME`	`VARCHAR2(128)`		Name of the task
`EXECUTION_NAME`	`VARCHAR2(128)`		The name of the task execution with which this entry (row) is associated
`REC_ID`	`NUMBER`	`NOT NULL`	Recommendation associated with the action
`ACTION_ID`	`NUMBER`	`NOT NULL`	Unique identifier for the action
`OBJECT_ID`	`NUMBER`		Object associated with the action
`COMMAND`	`VARCHAR2(64)`		Command to be executed See Also: `DBA_ADVISOR_COMMANDS` for a list of commands
`COMMAND_ID`	`NUMBER`	`NOT NULL`	ID of the command to be executed See Also: `DBA_ADVISOR_COMMANDS` for a list of commands
`FLAGS`	`NUMBER`		Advisor-specific flags
`ATTR1`	`VARCHAR2(4000)`		Parameters defining the command
`ATTR2`	`VARCHAR2(4000)`		Parameters defining the command
`ATTR3`	`VARCHAR2(4000)`		Parameters defining the command
`ATTR4`	`VARCHAR2(4000)`		Parameters defining the command
`ATTR5`	`CLOB`		Parameters defining the command; to be used if the text is significantly large (for example, a SQL statement defining a materialized view)
`ATTR6`	`CLOB`		Parameters defining the command; to be used if the text is significantly large (for example, a SQL statement defining a materialized view)
`NUM_ATTR1`	`NUMBER`		General numeric attribute
`NUM_ATTR2`	`NUMBER`		General numeric attribute
`NUM_ATTR3`	`NUMBER`		General numeric attribute
`NUM_ATTR4`	`NUMBER`		General numeric attribute
`NUM_ATTR5`	`NUMBER`		General numeric attribute
`MESSAGE`	`VARCHAR2(4000)`		Message associated with the action
`FILTERED`	`VARCHAR2(1)`		A value of `Y` means that the row in the view was filtered out by a directive (or a combination of directives). A value of `N` means that the row was not filtered.
`RESULT_STATUS`	`VARCHAR2(25)`		Result status. Possible values: `AUTOMATION PENDING` `TIMED OUT` `MISSING INFORMATION` `COMPLETED WITH NO RESULTS` `COMPLETED AND IMPLEMENTED` `ENCOUNTERED ERROR` `NOT AUTOMATED`
`RESULT_LAST_MODIFIED`	`TIMESTAMP(3)`		Time at which result status was last modified
`RESULT_MESSAGE`	`VARCHAR2(4000)`		Result message text

本站中文解释

官方英文解释

相关推荐