[Home] [Help] [Dependency Information]
Object Name: | CDB_MVIEW_ANALYSIS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of the materialized views accessible to dba in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the materialized view |
MVIEW_NAME | VARCHAR2 | (30) | Yes | Name of the materialized view |
MVIEW_TABLE_OWNER | VARCHAR2 | (30) | 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) | ||
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 | ||
REVISION | NUMBER | Reserved for internal use | ||
CON_ID | NUMBER | container id |
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
, REVISION
, CON_ID
FROM SYS.CDB_MVIEW_ANALYSIS;
SYS.CDB_MVIEW_ANALYSIS does not reference any database object
SYS.CDB_MVIEW_ANALYSIS is referenced by following:
|
|
|