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 |