Name Value
CREATED 27/08/11
LAST_DDL_TIME 27/08/11
OWNER SYSTEM
VIEW_NAME MVIEW_RECOMMENDATIONS
TEXT_LENGTH 520
TEXT select t1.runid# as runid, t1.from_clause as all_tables, fact_tables, grouping_levels, query_text, rank# as recommendation_number, action_type as recommended_action, summary_owner as mview_owner, summary_name as mview_name, storage_in_bytes, pct_performance_gain, 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 = 0 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