Oracle教程 2023-03-24

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

本站中文解释

Oracle视图DBA_AUTO_MV_ANALYSIS_TASK视图显示系统中正在运行的自动管理物化视图（MV）分析任务的信息。

该视图包含以下列：

TASK_ID：任务的ID

TASK_TIMESTAMP：任务的运行时间

TASK_STATUS：任务的当前状态（正在运行/失败/完成）

TASK_TYPE：任务的类型

OWNER_NAME：用于发起任务的用户的名称

MV_TYPE：物化视图的类型（正常／AW／RIC等）

MV_ANALYSIS_TYPE：物化视图分析类型

OBJECT_NAME：被分析物化视图的名称

SCHEMA_NAME：被分析物化视图所属 Schema 的名称

ANALYSIS_STIME：任务分析最后一个 MV 的开始时间

ANALYSIS_ENAME：任务分析最后一个 MV 的结束时间

ANALYSIS_TIME：任务的总时间

管理员可以使用该视图查看正在进行的和已完成的MV分析任务的信息，并可用于确定某一物化视图是否已完成MV分析任务，或者确定MV分析任务是否正在运行。

官方英文解释

DBA_AUTO_MV_ANALYSIS_TASK display analysis information 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`.
`DESCRIPTION`	`VARCHAR2(256)`		User-supplied description of the task
`ADVISOR_NAME`	`VARCHAR2(128)`		Advisor associated with the task
`CREATED`	`DATE`	`NOT NULL`	Creation date of the task
`LAST_MODIFIED`	`DATE`	`NOT NULL`	Date on which the task was last modified
`PARENT_TASK_ID`	`NUMBER`		Identifier of the parent task (if the task was created because of the recommendation of another task)
`PARENT_RXEC_ID`	`NUMBER`		Identifier of the recommendation within the parent task that resulted in the creation of the task
`LAST_EXECUTION`	`VARCHAR2(128)`		Name of the current or last task execution
`EXECUTION_TYPE`	`VARCHAR2(128)`		Type of the last execution. This information is optional for single-execution tasks.
`EXECUTION_TYPE#`	`NUMBER`		Reserved for internal use
`EXECUTION_DESCRIPTION`	`VARCHAR2(256)`		Optional description of the last execution
`EXECUTION_START`	`DATE`		Execution start date and time of the task
`EXECUTION_END`	`DATE`		Execution end date and time of the task
`STATUS`	`VARCHAR2(11)`		Current operational status of the task: `INITIAL` – Initial state of the task; no recommendations are present `EXECUTING` – Task is currently running `INTERRUPTED` – Task analysis was interrupted by the user. Recommendation data, if present, can be viewed and reported at this time. `COMPLETED` – Task successfully completed the analysis operation. Recommendation data can be viewed and reported. `ERROR` – An error occurred during the analysis operation. Recommendations, if present, can be viewed and reported at this time.
`STATUS_MESSAGE`	`VARCHAR2(4000)`		Informational message provided by the advisor regarding the status
`PCT_COMPLETION_TIME`	`NUMBER`		Percent completion, in terms of time, of the task when it is executing
`PROGRESS_METRIC`	`NUMBER`		Metric that measures the progress of the task in terms of quality. Each advisor may have its own metric.
`METRIC_UNITS`	`VARCHAR2(64)`		Unit of the metric used to measure progress
`ACTIVITY_COUNTER`	`NUMBER`		Counter that is updated frequently by the advisor, denoting that useful work is being performed
`RECOMMENDATION_COUNT`	`NUMBER`		Number of recommendations produced
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Informational message or an error message indicating the current operation or condition
`SOURCE`	`VARCHAR2(128)`		Optional name that identifies the creator of the task
`HOW_CREATED`	`VARCHAR2(30)`		Optional task or template on which the object was based
`READ_ONLY`	`VARCHAR2(5)`		Indicates whether the task is read-only (`TRUE`) or not (`FALSE`)
`SYSTEM_TASK`	`VARCHAR2(5)`		Indicates whether the task is a system task (`TRUE`) or not (`FALSE`)
`ADVISOR_ID`	`NUMBER`	`NOT NULL`	Unique identifier for the advisor
`STATUS#`	`NUMBER`		Reserved for internal use

Note:

This view is available starting with Oracle Database 21c.

数据运维技术 » Oracle 视图 DBA_AUTO_MV_ANALYSIS_TASK 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐