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

网络编程 Oracle 视图 DBA_AUTO_MV_ANALYSIS_EXECUTIONS 官方解释，作用，如何使用详细说明 10-19

本站中文解释

Oracle 视图DBA_AUTO_MV_ANALYSIS_EXECUTIONS用于查看MVIEW分析作业的状态，包括执行时间等信息，查看其中数据可以判断重建MVIEW（工作）操作是否成功和执行状态等。它是一种用于自动分析MVIEW（工作）状态的机制。

该视图由两个列组成：

1.LAST_ANALYSIS_TIME：上次分析的时间；

2.STATUS：分析的状态，可能的状态为’COMPLETE’,’IN_PROGRESS’,’FAILURE’等。

使用此视图可以查看任何指定MView（工作）的分析执行状态，如：

SQL> SELECT lAST_ANALYSIS_TIME, STATUS FROM DBA_AUTO_MV_ANALYSIS_EXECUTIONS WHERE MVIEW_WORK = ‘MyMView’;

官方英文解释

DBA_AUTO_MV_ANALYSIS_EXECUTIONS displays information about analysis and tuning executions associated with automatic materialized views.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		Owner of the task
`TASK_ID`	`NUMBER`	`NOT NULL`	Unique 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)`	`NOT NULL`	Name of the task execution with which this entry (row) is associated
`EXECUTION_ID`	`NUMBER`	`NOT NULL`	Execution ID
`DESCRIPTION`	`VARCHAR2(256)`		User-supplied description of the task
`EXECUTION_TYPE`	`VARCHAR2(128)`		Type of the last execution (optional for single-execution tasks)
`EXECUTION_TYPE#`	`NUMBER`		Reserved for internal use
`EXECUTION_START`	`DATE`		Execution start date and time
`EXECUTION_LAST_MODIFIED`	`DATE`	`NOT NULL`	Last modified date and time for the execution
`EXECUTION_END`	`DATE`		Execution end date and time
`REQUESTED_DOP`	`NUMBER`		The degree of parallelism (DOP) value requested by the user (through the `TEST_EXECUTE_DOP` parameter). It can be any value greater or equal to zero.
`ACTUAL_DOP`	`NUMBER`		The actual degree of parallelism (DOP) with which the execution finished. If the requested DOP is greater than than what is available on the system, the `ACTUAL_DOP` value can be lower than the `REQUESTED_DOP` value.
`CONCURRENT_EXECUTION`	`VARCHAR2(3)`		Indicates whether concurrency was used for this execution (`YES`) or not (`NO`)
`ADVISOR_NAME`	`VARCHAR2(128)`		Advisor associated with the task
`ADVISOR_ID`	`NUMBER`	`NOT NULL`	Unique identifier for the advisor
`STATUS`	`VARCHAR2(11)`		Current operational status of the task: `EXECUTING` `COMPLETED` `INTERRUPTED` `CANCELLED` `FATAL ERROR`
`STATUS#`	`NUMBER`	`NOT NULL`	Reserved for internal use
`STATUS_MESSAGE`	`VARCHAR2(4000)`		Informational message provided by the advisor regarding the status
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Informational message or an error message indicating the current operation or condition

Note:

This view is available starting with Oracle Database 21c.

编辑：广州葆元健康生物科技有限公司

标签：状态,视图,工作,作业,执行时间