[Oracle/Sql] Oracle plan table 생성 (Orange 기준)

토드나 다른 TOOL 사용 할때는 상관 없는데 Orange 를 사용할때에는

기존에 Plan 테이블이 생성되어 있지 않다면 생성해 줘야 한다.

 

DROP TABLE ORANGE_PLAN_TABLE;
CREATE TABLE ORANGE_PLAN_TABLE -- 테이블 이름
(
 STATEMENT_ID     VARCHAR2 (30),
 TIMESTAMP DATE,
 REMARKS          VARCHAR2 (80),
 OPERATION        VARCHAR2 (30),
 OPTIONS          VARCHAR2 (255),
 OBJECT_NODE      VARCHAR2 (128),
 OBJECT_OWNER     VARCHAR2 (30),
 OBJECT_NAME      VARCHAR2 (30),
 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,
 DISTRIBUTION     VARCHAR2 (30),
 CPU_COST         NUMBER,
 IO_COST          NUMBER,
 TEMP_SPACE       NUMBER,
 ACCESS_PREDICATES VARCHAR2 (4000),
 FILTER_PREDICATES VARCHAR2 (4000)
)
TABLESPACE TBS_BM_DAT
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
STORAGE
(
 INITIAL 65536
 MINEXTENTS 1
 MAXEXTENTS UNLIMITED
 BUFFER_POOL DEFAULT
)
LOGGING ;

SELECT * FROM ORANGE_PLAN_TABLE;