[Home] [Help] [Dependency Information]
Object Name: | MVIEW_RECOMMENDATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
This view gives DBA access to summary recommendations
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
SYSTEM.MVIEW_RECOMMENDATIONS is not referenced by any database object
|
|
|