eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_MVIEW_ANALYSIS

Object Details

Object Name:	ALL_MVIEW_ANALYSIS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of the materialized views accessible to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the materialized view
MVIEW_NAME	VARCHAR2	(128)	Yes	Name of the materialized view
MVIEW_TABLE_OWNER	VARCHAR2	(128)	Yes	Owner of the container table
CONTAINER_NAME	VARCHAR2	(128)		Name of the container table for this materialized view
LAST_REFRESH_SCN	NUMBER			The SCN of the last transaction to refresh the materialized view
LAST_REFRESH_DATE	DATE			The date of the last refresh of the materialized view
REFRESH_METHOD	VARCHAR2	(8)		User declared method of refresh for the materialized view
SUMMARY	VARCHAR2	(1)		Indicates if the materialized view includes the GROUP BY clause
FULLREFRESHTIM	NUMBER			The time that it took to fully refresh the materialized view
INCREFRESHTIM	NUMBER			The time that it took to incrementally refresh the materialized view
CONTAINS_VIEWS	VARCHAR2	(1)		This materialized view contains views in the FROM clause
UNUSABLE	VARCHAR2	(1)		This materialized view is unusable, the build was deferred
RESTRICTED_SYNTAX	VARCHAR2	(1)		This materialized view contains restrictive syntax
INC_REFRESHABLE	VARCHAR2	(1)		This materialized view is not restricted from being incrementally refreshed
KNOWN_STALE	VARCHAR2	(1)		This materialized view is directly stale
INVALID	VARCHAR2	(1)		Invalidity of the materialized view, Y = INVALID, N = VALID
REWRITE_ENABLED	VARCHAR2	(1)		This materialized view is enabled for query rewrite
QUERY_LEN	NUMBER			The length (in bytes) of the query field
QUERY	LONG	(0)		SELECT expression of the materialized view definition
REVISION	NUMBER		Yes	Reserved for internal use

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      MVIEW_NAME
,      MVIEW_TABLE_OWNER
,      CONTAINER_NAME
,      LAST_REFRESH_SCN
,      LAST_REFRESH_DATE
,      REFRESH_METHOD
,      SUMMARY
,      FULLREFRESHTIM
,      INCREFRESHTIM
,      CONTAINS_VIEWS
,      UNUSABLE
,      RESTRICTED_SYNTAX
,      INC_REFRESHABLE
,      KNOWN_STALE
,      INVALID
,      REWRITE_ENABLED
,      QUERY_LEN
,      QUERY
,      REVISION
FROM SYS.ALL_MVIEW_ANALYSIS;

Dependencies

[top of page]

SYS.ALL_MVIEW_ANALYSIS references the following:

SYS: OBJ$; OBJAUTH$; SNAP$; SUM$; USER$

SYS.ALL_MVIEW_ANALYSIS is referenced by following:

PUBLIC: ALL_MVIEW_ANALYSIS