Oracle教程 2023-02-23

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

本站中文解释

Oracle视图DBA_AUTO_MV_ANALYSIS_ACTIONS的用途是显示执行的基于MV的自动分析操作及其历史信息。

此视图包含每次从发布之后执行的自动MV分析操作的详细信息，如果支持，还包括其他自动维护任务的统计信息。

可以使用此视图来监测由自动基于MV的分析执行的任务，以及这些任务的执行时间和结果，以及在重新分析时发生的变化情况。

对于查询视图，可以使用多个条件来提取详细信息，例如：执行时间、成功执行的情况、历史变更情况、失败的情况等。

还可以使用DBMS_AUTO_MV_ANALYZE.CLEAR_ANALYZE_HISTORY存储过程来删除特定类型的历史信息。

官方英文解释

DBA_AUTO_MV_ANALYSIS_ACTIONS displays information about analysis and tuning activities associated with automatic materialized views.

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

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 The value of this column is always `SYS_AUTO_MV_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