eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYSTEM.MVIEW_RECOMMENDATIONS

Object Details

Object Name:	MVIEW_RECOMMENDATIONS
Object Type:	VIEW
Owner:	SYSTEM
Subobject Name:
Status:	VALID

This view gives DBA access to summary recommendations

[View Source]

Columns

Name	Datatype	Length	Mandatory
RUNID	NUMBER		Yes
ALL_TABLES	VARCHAR2	(2000)
FACT_TABLES	VARCHAR2	(1000)
GROUPING_LEVELS	VARCHAR2	(2000)
QUERY_TEXT	LONG	(0)
RECOMMENDATION_NUMBER	NUMBER		Yes
RECOMMENDED_ACTION	VARCHAR2	(6)
MVIEW_OWNER	VARCHAR2	(128)
MVIEW_NAME	VARCHAR2	(128)
STORAGE_IN_BYTES	NUMBER
PCT_PERFORMANCE_GAIN	NUMBER
BENEFIT_TO_COST_RATIO	NUMBER		Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RUNID
,      ALL_TABLES
,      FACT_TABLES
,      GROUPING_LEVELS
,      QUERY_TEXT
,      RECOMMENDATION_NUMBER
,      RECOMMENDED_ACTION
,      MVIEW_OWNER
,      MVIEW_NAME
,      STORAGE_IN_BYTES
,      PCT_PERFORMANCE_GAIN
,      BENEFIT_TO_COST_RATIO
FROM SYSTEM.MVIEW_RECOMMENDATIONS;

Dependencies

[top of page]

SYSTEM.MVIEW_RECOMMENDATIONS references the following:

PUBLIC: ALL_USERS
SYSTEM: MVIEW$_ADV_LOG; MVIEW$_ADV_OUTPUT

SYSTEM.MVIEW_RECOMMENDATIONS is not referenced by any database object