#30_140724_WSHOP2_오렌지 실행계획 오류

오렌지 실행계획 오류

l 오렌지 실행계획(ctrl + E)이 안보이면 아래를 scott 에서 수행

1.     scott에서 수행

SQL> @?/rdbms/admin/utlxplan.sql SQL> desc plan_table

2.     오렌지에서 아래 스크립트 수행

create table 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    numeric,         object_type        varchar2(30),         optimizer          varchar2(255),         search_columns     number,         id                 numeric,         parent_id          numeric,         depth              numeric,         position           numeric,         cost               numeric,         cardinality        numeric,         bytes              numeric,         other_tag          varchar2(255),         partition_start    varchar2(255),         partition_stop     varchar2(255),         partition_id       numeric,         other              long,         distribution       varchar2(30),         cpu_cost           numeric,         io_cost            numeric,         temp_space         numeric,         access_predicates  varchar2(4000),         filter_predicates  varchar2(4000),         projection         varchar2(4000),         time               numeric,         qblock_name        varchar2(30),         other_xml          clob );

3.     tools 에서 plan tool 수행후 option -> option에 들어가서 plan_table에 ‘plan_table’ 입력