Oracle教程 2023-02-23

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

本站中文解释

ALL_MVIEW_ANALYSIS是Oracle数据库内部的一个视图，用于显示有关物化视图分析结果的信息。ALL_MVIEW_ANALYSIS内部表（上溯至9i）总是由MVIEW不停止的分析程序维护，在每种分析重新启动之前是更新障碍。它提供了一个汇总信息，以显示物理视图分析的当前状态，包括更新状态，计算状态，日期和次数。

ALL_MVIEW_ANALYSIS用于跟踪物化视图分析，其目的是发现无用的物理视图重新分析，并跟踪经常分析的物理视图，以确保它们处于最佳性能状态。使用本视图，您可以检查出错的物理视图，并及早采取行动来解决问题。

使用ALL_MVIEW_ANALYSIS视图，您可以检索新闻视图上一次成功更新计算或失败计算，以及错误代码列和错误消息列。

使用ALL_MVIEW_ANALYSIS视图，您可以创建查询来检查分析状态：

SELECT * FROM ALL_MVIEW_ANALYSIS;

官方英文解释

ALL_MVIEW_ANALYSIS describes the materialized views accessible to the current user. It provides additional information for analysis by applications. Minimal information is displayed for materialized views that do not support query rewrite (such as materialized views with remote master tables or nondeterministic functions).

Related Views

DBA_MVIEW_ANALYSIS describes all such materialized views in the database.
USER_MVIEW_ANALYSIS describes all such materialized views owned by the current user.

Note:

All of the information in these views is also displayed in ALL_MVIEWS and its related views. Oracle recommends that you refer to ALL_MVIEWS for this information instead of these views.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the materialized view
`MVIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the materialized view
`MVIEW_TABLE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the container table (see next column)
`CONTAINER_NAME`	`VARCHAR2(128)`		Name of the internal container in which the materialized view data is held. Normally this is the same as `MVIEW_NAME`. For materialized views created before Oracle8i, Oracle Database attaches the 6-byte prefix `SNAP$_`. If `MVIEW_NAME` has more than 19 bytes, then Oracle Database truncates the name to 19 bytes and adds a 4-byte sequence number as a suffix to produce a nonambiguous `CONTAINER_NAME`.
`LAST_REFRESH_SCN`	`NUMBER`		System change number (SCN) of the last refresh operation
`LAST_REFRESH_DATE`	`DATE`		`SYSDATE` of the last refresh
`REFRESH_METHOD`	`VARCHAR2(8)`		Default refresh method: `FORCE` `FAST` `COMPLETE` `NEVER`
`SUMMARY`	`VARCHAR2(1)`		Indicates whether this materialized view includes a `GROUP BY` clause or aggregation (`Y`) or not (`N`)
`FULLREFRESHTIM`	`NUMBER`		Approximate refresh time, in seconds, for full refresh
`INCREFRESHTIM`	`NUMBER`		Approximate refresh time, in seconds, for fast refresh
`CONTAINS_VIEWS`	`VARCHAR2(1)`		Indicates whether this materialized view contains a view in its definition (`Y`) or not (`N`)
`UNUSABLE`	`VARCHAR2(1)`		Indicates whether this materialized view is `UNUSABLE` (inconsistent data) (`Y`) or not (`N`). A materialized view can be `UNUSABLE` if a system failure occurs during a full refresh.
`RESTRICTED_SYNTAX`	`VARCHAR2(1)`		Indicates whether this materialized view had a restriction in its defining query that limits the use of query rewrite (`Y`) or not (`N`). More complete information is provided by the `REWRITE_CAPABILITY` column of the `*_MVIEWS` view.
`INC_REFRESHABLE`	`VARCHAR2(1)`		Indicates whether this materialized view can be fast refreshed (`Y`) or not (`N`)
`KNOWN_STALE`	`VARCHAR2(1)`		Indicates whether the data contained in the materialized view is known to be inconsistent with the master table data because that has been updated since the last successful refresh (`Y`) or not (`N`)
`INVALID`	`VARCHAR2(1)`		Indicates whether this materialized view is in an invalid state (inconsistent metadata) (`Y`) or not (`N`)
`REWRITE_ENABLED`	`VARCHAR2(1)`		Indicates whether this materialized view is currently enabled for query rewrite (`Y`) or not (`N`)
`QUERY_LEN`	`NUMBER`		Length (in bytes) of the query field
`QUERY`	`LONG`		`SELECT` expression of the materialized view definition
`REVISION`	`NUMBER`	`NOT NULL`	Reserved for internal use

本站中文解释

官方英文解释

相关推荐