[Home] [Help] [Dependency Information]
Object Name: | MVIEW$_ADV_OUTPUT |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Output table for summary recommendations and evaluations
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MVIEW$_ADV_OUTPUT_PK | NORMAL | UNIQUE | SYSTEM |
RUNID#
RANK# |
Table | |
Foreign Table | Foreign Key Column | MVIEW$_ADV_OUTPUT | MVIEW$_ADV_LOG | MVIEW$_ADV_OUTPUT RUNID# |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RUNID# | NUMBER | Yes | ||
OUTPUT_TYPE | NUMBER | Yes | ||
RANK# | NUMBER | Yes | ||
ACTION_TYPE | VARCHAR2 | (6) | ||
SUMMARY_OWNER | VARCHAR2 | (128) | ||
SUMMARY_NAME | VARCHAR2 | (128) | ||
GROUP_BY_COLUMNS | VARCHAR2 | (2000) | ||
WHERE_CLAUSE | VARCHAR2 | (2000) | ||
FROM_CLAUSE | VARCHAR2 | (2000) | ||
MEASURES_LIST | VARCHAR2 | (2000) | ||
FACT_TABLES | VARCHAR2 | (1000) | ||
GROUPING_LEVELS | VARCHAR2 | (2000) | ||
QUERYLEN | NUMBER | |||
QUERY_TEXT | LONG | (0) | ||
STORAGE_IN_BYTES | NUMBER | |||
PCT_PERFORMANCE_GAIN | NUMBER | |||
FREQUENCY | NUMBER | |||
CUMULATIVE_BENEFIT | NUMBER | |||
BENEFIT_TO_COST_RATIO | NUMBER | Yes | ||
VALIDATED | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RUNID#
, OUTPUT_TYPE
, RANK#
, ACTION_TYPE
, SUMMARY_OWNER
, SUMMARY_NAME
, GROUP_BY_COLUMNS
, WHERE_CLAUSE
, FROM_CLAUSE
, MEASURES_LIST
, FACT_TABLES
, GROUPING_LEVELS
, QUERYLEN
, QUERY_TEXT
, STORAGE_IN_BYTES
, PCT_PERFORMANCE_GAIN
, FREQUENCY
, CUMULATIVE_BENEFIT
, BENEFIT_TO_COST_RATIO
, VALIDATED
FROM SYSTEM.MVIEW$_ADV_OUTPUT;
SYSTEM.MVIEW$_ADV_OUTPUT does not reference any database object
SYSTEM.MVIEW$_ADV_OUTPUT is referenced by following:
|
|
|