Description
noneTable properties
| name | value |
|---|
| name | HR.HTMLDB_PLAN_TABLE
|
| tablespace | USERS
|
| status | VALID
|
| percent free | 10
|
| logging | YES
|
| backed up | N
|
| rows | 0
|
| blocks | 0
|
| average row length | 0
|
Columns
| column | datatype | default | nulls | PK | FK | UQ | comment |
|---|
| STATEMENT_ID
| VARCHAR2
(30)
|
| Y
|
|
|
|
|
| PLAN_ID
| NUMBER
|
| Y
|
|
|
|
|
| TIMESTAMP
| DATE
|
| Y
|
|
|
|
|
| REMARKS
| VARCHAR2
(4000)
|
| 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_ALIAS
| VARCHAR2
(65)
|
| Y
|
|
|
|
|
| OBJECT_INSTANCE
| NUMBER
|
| Y
|
|
|
|
|
| OBJECT_TYPE
| VARCHAR2
(30)
|
| Y
|
|
|
|
|
| OPTIMIZER
| VARCHAR2
(255)
|
| Y
|
|
|
|
|
| SEARCH_COLUMNS
| NUMBER
|
| Y
|
|
|
|
|
| ID
| NUMBER
|
| Y
|
|
|
|
|
| PARENT_ID
| NUMBER
|
| Y
|
|
|
|
|
| DEPTH
| NUMBER
|
| Y
|
|
|
|
|
| POSITION
| NUMBER
|
| Y
|
|
|
|
|
| COST
| NUMBER
|
| Y
|
|
|
|
|
| CARDINALITY
| NUMBER
|
| Y
|
|
|
|
|
| BYTES
| NUMBER
|
| Y
|
|
|
|
|
| OTHER_TAG
| VARCHAR2
(255)
|
| Y
|
|
|
|
|
| PARTITION_START
| VARCHAR2
(255)
|
| Y
|
|
|
|
|
| PARTITION_STOP
| VARCHAR2
(255)
|
| Y
|
|
|
|
|
| PARTITION_ID
| NUMBER
|
| Y
|
|
|
|
|
| OTHER
| LONG
|
| Y
|
|
|
|
|
| DISTRIBUTION
| VARCHAR2
(30)
|
| Y
|
|
|
|
|
| CPU_COST
| NUMBER
|
| Y
|
|
|
|
|
| IO_COST
| NUMBER
|
| Y
|
|
|
|
|
| TEMP_SPACE
| NUMBER
|
| Y
|
|
|
|
|
| ACCESS_PREDICATES
| VARCHAR2
(4000)
|
| Y
|
|
|
|
|
| FILTER_PREDICATES
| VARCHAR2
(4000)
|
| Y
|
|
|
|
|
| PROJECTION
| VARCHAR2
(4000)
|
| Y
|
|
|
|
|
| TIME
| NUMBER
|
| Y
|
|
|
|
|
| QBLOCK_NAME
| VARCHAR2
(30)
|
| Y
|
|
|
|
|
Code
CREATE TABLE "HR"."HTMLDB_PLAN_TABLE"
( "STATEMENT_ID" VARCHAR2(30),
"PLAN_ID" NUMBER,
"TIMESTAMP" DATE,
"REMARKS" VARCHAR2(4000),
"OPERATION" VARCHAR2(30),
"OPTIONS" VARCHAR2(255),
"OBJECT_NODE" VARCHAR2(128),
"OBJECT_OWNER" VARCHAR2(30),
"OBJECT_NAME" VARCHAR2(30),
"OBJECT_ALIAS" VARCHAR2(65),
"OBJECT_INSTANCE" NUMBER(*,0),
"OBJECT_TYPE" VARCHAR2(30),
"OPTIMIZER" VARCHAR2(255),
"SEARCH_COLUMNS" NUMBER,
"ID" NUMBER(*,0),
"PARENT_ID" NUMBER(*,0),
"DEPTH" NUMBER(*,0),
"POSITION" NUMBER(*,0),
"COST" NUMBER(*,0),
"CARDINALITY" NUMBER(*,0),
"BYTES" NUMBER(*,0),
"OTHER_TAG" VARCHAR2(255),
"PARTITION_START" VARCHAR2(255),
"PARTITION_STOP" VARCHAR2(255),
"PARTITION_ID" NUMBER(*,0),
"OTHER" LONG,
"DISTRIBUTION" VARCHAR2(30),
"CPU_COST" NUMBER(*,0),
"IO_COST" NUMBER(*,0),
"TEMP_SPACE" NUMBER(*,0),
"ACCESS_PREDICATES" VARCHAR2(4000),
"FILTER_PREDICATES" VARCHAR2(4000),
"PROJECTION" VARCHAR2(4000),
"TIME" NUMBER(*,0),
"QBLOCK_NAME" VARCHAR2(30)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"