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

TABLE: SYSTEM.MVIEW$_ADV_ELIGIBLE

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

Summary management rewrite eligibility information

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: MVIEW$_ADV_ELIGIBLE_PK
  1. ColumnSUMOBJN#
  2. ColumnRUNID#
Indexes
Index Type Uniqueness Tablespace Column
MVIEW$_ADV_ELIGIBLE_PK NORMAL UNIQUE TablespaceSYSTEM ColumnSUMOBJN#
ColumnRUNID#
Foreign Keys
Table
Foreign Table Foreign Key Column
MVIEW$_ADV_ELIGIBLE MVIEW$_ADV_ELIGIBLE_FK TableMVIEW$_ADV_LOG MVIEW$_ADV_ELIGIBLE RUNID#
Columns
Name Datatype Length Mandatory Comments
SUMOBJN# NUMBER
Yes
RUNID# NUMBER
Yes
BYTECOST NUMBER
Yes
FLAGS NUMBER
Yes
FREQUENCY NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUMOBJN#
,      RUNID#
,      BYTECOST
,      FLAGS
,      FREQUENCY
FROM SYSTEM.MVIEW$_ADV_ELIGIBLE;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_ELIGIBLE does not reference any database object

SYSTEM.MVIEW$_ADV_ELIGIBLE is referenced by following:

SchemaSYS
Package BodyPRVT_WORKLOAD - show dependent code