VIEW: SYSTEM.MVIEW_EVALUATIONS

Source

View Text - Preformatted

select
  t1.runid# as runid,
  summary_owner AS mview_owner,
  summary_name AS mview_name,
  rank# as rank,
  storage_in_bytes,
  frequency,
  cumulative_benefit,
  benefit_to_cost_ratio
from SYSTEM.MVIEW$_ADV_OUTPUT t1, SYSTEM.MVIEW$_ADV_LOG t2, ALL_USERS u
where
  t1.runid# = t2.runid# and
  u.username = t2.uname and
  u.user_id = userenv('SCHEMAID') and
  t1.output_type = 1
order by t1.rank#

View Text - HTML Formatted

SELECT T1.RUNID# AS RUNID
, SUMMARY_OWNER AS MVIEW_OWNER
, SUMMARY_NAME AS MVIEW_NAME
, RANK# AS RANK
, STORAGE_IN_BYTES
, FREQUENCY
, CUMULATIVE_BENEFIT
, BENEFIT_TO_COST_RATIO FROM SYSTEM.MVIEW$_ADV_OUTPUT T1
, SYSTEM.MVIEW$_ADV_LOG T2
, ALL_USERS U WHERE T1.RUNID# = T2.RUNID# AND U.USERNAME = T2.UNAME AND U.USER_ID = USERENV('SCHEMAID') AND T1.OUTPUT_TYPE = 1 ORDER BY T1.RANK#