[Home] [Help] [Dependency Information]
Object Name: | MVIEW$_ADV_PLAN |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Private plan table for estimate_mview_size operations
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATEMENT_ID | VARCHAR2 | (30) | ||
TIMESTAMP | DATE | |||
REMARKS | VARCHAR2 | (80) | ||
OPERATION | VARCHAR2 | (30) | ||
OPTIONS | VARCHAR2 | (255) | ||
OBJECT_NODE | VARCHAR2 | (128) | ||
OBJECT_OWNER | VARCHAR2 | (128) | ||
OBJECT_NAME | VARCHAR2 | (128) | ||
OBJECT_INSTANCE | NUMBER | |||
OBJECT_TYPE | VARCHAR2 | (30) | ||
OPTIMIZER | VARCHAR2 | (255) | ||
SEARCH_COLUMNS | NUMBER | |||
ID | NUMBER | |||
PARENT_ID | NUMBER | |||
POSITION | NUMBER | |||
COST | NUMBER | |||
CARDINALITY | NUMBER | |||
BYTES | NUMBER | |||
OTHER_TAG | VARCHAR2 | (255) | ||
PARTITION_START | VARCHAR2 | (255) | ||
PARTITION_STOP | VARCHAR2 | (255) | ||
PARTITION_ID | NUMBER | |||
OTHER | LONG | (0) | ||
DISTRIBUTION | VARCHAR2 | (30) | ||
CPU_COST | NUMBER | |||
IO_COST | NUMBER | |||
TEMP_SPACE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT STATEMENT_ID
, TIMESTAMP
, REMARKS
, OPERATION
, OPTIONS
, OBJECT_NODE
, OBJECT_OWNER
, OBJECT_NAME
, OBJECT_INSTANCE
, OBJECT_TYPE
, OPTIMIZER
, SEARCH_COLUMNS
, ID
, PARENT_ID
, POSITION
, COST
, CARDINALITY
, BYTES
, OTHER_TAG
, PARTITION_START
, PARTITION_STOP
, PARTITION_ID
, OTHER
, DISTRIBUTION
, CPU_COST
, IO_COST
, TEMP_SPACE
FROM SYSTEM.MVIEW$_ADV_PLAN;
SYSTEM.MVIEW$_ADV_PLAN does not reference any database object
SYSTEM.MVIEW$_ADV_PLAN is not referenced by any database object
|
|
|