COLUMN_NAME |
DATA_TYPE |
NULLABLE |
DATA_DEFAULT |
COLUMN_ID |
COMMENTS |
INSERTABLE |
UPDATABLE |
DELETABLE |
RUNID |
NUMBER |
No |
null |
1 |
null |
NO |
NO |
NO |
ALL_TABLES |
VARCHAR2(2000) |
Yes |
null |
2 |
null |
NO |
NO |
NO |
FACT_TABLES |
VARCHAR2(1000) |
Yes |
null |
3 |
null |
NO |
NO |
NO |
GROUPING_LEVELS |
VARCHAR2(2000) |
Yes |
null |
4 |
null |
NO |
NO |
NO |
QUERY_TEXT |
LONG() |
Yes |
null |
5 |
null |
NO |
NO |
NO |
RECOMMENDATION_NUMBER |
NUMBER |
No |
null |
6 |
null |
NO |
NO |
NO |
RECOMMENDED_ACTION |
VARCHAR2(6) |
Yes |
null |
7 |
null |
NO |
NO |
NO |
MVIEW_OWNER |
VARCHAR2(30) |
Yes |
null |
8 |
null |
NO |
NO |
NO |
MVIEW_NAME |
VARCHAR2(30) |
Yes |
null |
9 |
null |
NO |
NO |
NO |
STORAGE_IN_BYTES |
NUMBER |
Yes |
null |
10 |
null |
NO |
NO |
NO |
PCT_PERFORMANCE_GAIN |
NUMBER |
Yes |
null |
11 |
null |
NO |
NO |
NO |
BENEFIT_TO_COST_RATIO |
NUMBER |
No |
null |
12 |
null |
NO |
NO |
NO |