CREATE TABLE 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)
);
'OraclE' 카테고리의 다른 글
OGG 동기화 테이블 추가 (0) | 2022.04.04 |
---|---|
active session history (0) | 2022.01.30 |
벌크 insert 빠르게 하는 방법 (0) | 2018.03.21 |
RMAN backup set 에서 archivelog 추출하여 logminor 수행 (0) | 2018.02.22 |
Oracle RAC 마스터 노드 찾기 (find Master Node) (0) | 2017.09.14 |