SYSTEM.MVIEW_EVALUATIONS

Table 34-21 SYSTEM.MVIEW_EVALUATIONS

Column	NULL?	Datatype	Description
RUNID	NOT NULL	NUMBER	Run id identifying a unique advisor call
MVIEW_OWNER		VARCHAR2(30)	Owner of materialized view
MVIEW_NAME		VARCHAR2(30)	Name of an exiting materialized view in this database
RANK	NOT NULL	NUMBER	Rank of this materialized view in descending order of benefit_to_cost_ratio
STORAGE_IN_BYTES		NUMBER	Size of the materialized view in bytes
FREQUENCY		NUMBER	Number of times this materialized view appears in the workload
CUMULATIVE_BENEFIT		NUMBER	The cumulative benefit of the materialized view
BENEFIT_TO_COST_RATIO	NOT NULL	NUMBER	The ratio of cumulative_benefit to storage_in_bytes