Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

SH
Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

PLAN_TABLE

Columns

Column Datatype Nullable Default value Comment
STATEMENT_ID VARCHAR2(30) Y    
TIMESTAMP DATE Y    
REMARKS VARCHAR2(80) Y    
OPERATION VARCHAR2(30) Y    
OPTIONS VARCHAR2(255) Y    
OBJECT_NODE VARCHAR2(128) Y    
OBJECT_OWNER VARCHAR2(30) Y    
OBJECT_NAME VARCHAR2(30) Y    
OBJECT_INSTANCE NUMBER(,0) Y    
OBJECT_TYPE VARCHAR2(30) Y    
OPTIMIZER VARCHAR2(255) Y    
SEARCH_COLUMNS NUMBER(,) Y    
ID NUMBER(,0) Y    
PARENT_ID NUMBER(,0) Y    
POSITION NUMBER(,0) Y    
COST NUMBER(,0) Y    
CARDINALITY NUMBER(,0) Y    
BYTES NUMBER(,0) Y    
OTHER_TAG VARCHAR2(255) Y    
PARTITION_START VARCHAR2(255) Y    
PARTITION_STOP VARCHAR2(255) Y    
PARTITION_ID NUMBER(,0) Y    
OTHER LONG(0) Y    
DISTRIBUTION VARCHAR2(30) Y    
CPU_COST NUMBER(,0) Y    
IO_COST NUMBER(,0) Y    
TEMP_SPACE NUMBER(,0) Y    
ACCESS_PREDICATES VARCHAR2(4000) Y    
FILTER_PREDICATES VARCHAR2(4000) Y    

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized N
Logging Y
Partitioned N
Temporary N
Nested N

Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005