DBA Data[Home] [Help] [Dependency Information]

TABLE: SYSTEM.MVIEW$_ADV_OUTPUT

Object Details
Object Name: MVIEW$_ADV_OUTPUT
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Output table for summary recommendations and evaluations

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: MVIEW$_ADV_OUTPUT_PK
  1. ColumnRUNID#
  2. ColumnRANK#
Indexes
Index Type Uniqueness Tablespace Column
MVIEW$_ADV_OUTPUT_PK NORMAL UNIQUE TablespaceSYSTEM ColumnRUNID#
ColumnRANK#
Foreign Keys
Table
Foreign Table Foreign Key Column
MVIEW$_ADV_OUTPUT MVIEW$_ADV_OUTPUT_FK TableMVIEW$_ADV_LOG MVIEW$_ADV_OUTPUT RUNID#
Columns
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

Query Text

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;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_OUTPUT does not reference any database object

SYSTEM.MVIEW$_ADV_OUTPUT is referenced by following:

SchemaSYS
Package BodyPRVT_WORKLOAD - show dependent code
SchemaSYSTEM
ViewMVIEW_EVALUATIONS
ViewMVIEW_RECOMMENDATIONS