|
RUNID |
|
NUMBER |
Run id identifying a unique advisor call |
|
ALL_TABLES |
|
VARCHAR2(2000) |
A comma-separated list of fully qualified table names for structured recommendations |
|
FACT_TABLES |
|
VARCHAR2(1000) |
A comma-separated list of grouping levels, if any, for structured recommendation |
|
GROUPING_LEVELS |
|
VARCHAR2(2000) |
|
|
QUERY_TEXT |
|
LONG |
Query text of materialized view if RECOMMENDED_ACTION is CREATE; null otherwise |
|
RECOMMENDATION_NUMBER |
NOT NULL |
NUMBER |
Unique identifier for this recommendation |
|
RECOMMENDED_ACTION |
|
VARCHAR2(6) |
CREATE, RETAIN, or DROP, Retain, Create, or Drop |
|
MVIEW_OWNER |
|
VARCHAR2(30) |
Owner of the materialized view if RECOMMENDED_ACTION is RETAIN or DROP; null otherwise |
|
MVIEW_NAME |
|
VARCHAR2(30) |
Name of the materialized view if RECOMMENDED_ACTION is RETAIN or DROP; null otherwise |
|
STORAGE_IN_BYTES |
|
NUMBER |
Actual or estimated storage in bytes |
|
PCT_PERFORMANCE_GAIN |
|
NUMBER |
The expected incremental improvement in performance obtained by accepting this recommendation relative to the initial condition, assuming that all previous recommendations have been accepted, or NULL if unknown |
|
BENEFIT_TO_COST_RATIO |
NOT NULL |
NUMBER |
Ratio of the incremental improvement in performance to the size of the materialized view in bytes, or NULL if unknown |
