Oracle 视图 DBA_AUTO_MV_ANALYSIS_EXECUTIONS 官方解释，作用，如何使用详细说明
本站中文解释
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 of the task |
|
|
|
|
Unique identifier of the task |
|
|
|
|
Name of the task The value of this column is always |
|
|
|
|
Name of the task execution with which this entry (row) is associated |
|
|
|
|
Execution ID |
|
|
|
|
User-supplied description of the task |
|
|
|
|
Type of the last execution (optional for single-execution tasks) |
|
|
|
|
Reserved for internal use |
|
|
|
|
Execution start date and time |
|
|
|
|
Last modified date and time for the execution |
|
|
|
|
Execution end date and time |
|
|
|
|
The degree of parallelism (DOP) value requested by the user (through the |
|
|
|
|
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 |
|
|
|
|
Indicates whether concurrency was used for this execution ( |
|
|
|
|
Advisor associated with the task |
|
|
|
|
Unique identifier for the advisor |
|
|
|
|
Current operational status of the task:
|
|
|
|
|
Reserved for internal use |
|
|
|
|
Informational message provided by the advisor regarding the status |
|
|
|
|
Informational message or an error message indicating the current operation or condition |
Note:
This view is available starting with Oracle Database 21c.
