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

VIEW: SYSTEM.MVIEW_EVALUATIONS

Object Details
Object Name: MVIEW_EVALUATIONS
Object Type: VIEW
Owner: SYSTEM
Subobject Name:
Status: VALID

This view gives DBA access to summary evaluation output

[View Source]

Columns
Name Datatype Length Mandatory Comments
RUNID NUMBER
Yes
MVIEW_OWNER VARCHAR2 (128)
MVIEW_NAME VARCHAR2 (128)
RANK NUMBER
Yes
STORAGE_IN_BYTES NUMBER

FREQUENCY NUMBER

CUMULATIVE_BENEFIT NUMBER

BENEFIT_TO_COST_RATIO NUMBER
Yes
Query Text

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


SELECT RUNID
,      MVIEW_OWNER
,      MVIEW_NAME
,      RANK
,      STORAGE_IN_BYTES
,      FREQUENCY
,      CUMULATIVE_BENEFIT
,      BENEFIT_TO_COST_RATIO
FROM SYSTEM.MVIEW_EVALUATIONS;

Dependencies

[top of page]

SYSTEM.MVIEW_EVALUATIONS references the following:

SchemaPUBLIC
SynonymALL_USERS
SchemaSYSTEM
TableMVIEW$_ADV_LOG
TableMVIEW$_ADV_OUTPUT

SYSTEM.MVIEW_EVALUATIONS is not referenced by any database object