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#
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#
|
|
|