Name Value
CREATED 27/08/11
LAST_DDL_TIME 27/08/11
OWNER SYSTEM
VIEW_NAME MVIEW_EVALUATIONS
TEXT_LENGTH 397
TEXT 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#
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N