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 |