如果是默认安装TOAD,在查看执行计划时会报一个错:
ORA-02404: 未找到指定的计划表[@more@]创建对应的表
CREATE TABLE TOAD_PLAN_TABLE (
STATEMENT_ID VARCHAR2 (32),
TIMESTAMP DATE,
REMARKS VARCHAR2 (80),
OPERATION VARCHAR2 (30),
OPTIONS VARCHAR2 (30),
OBJECT_NODE VARCHAR2 (128),
OBJECT_OWNER VARCHAR2 (30),
OBJECT_NAME VARCHAR2 (30),
OBJECT_INSTANCE NUMBER,
OBJECT_TYPE VARCHAR2 (30),
SEARCH_COLUMNS NUMBER,
ID NUMBER,
COST NUMBER,
PARENT_ID NUMBER,
POSITION NUMBER,
CARDINALITY NUMBER,
OPTIMIZER VARCHAR2 (255),
BYTES NUMBER,
OTHER_TAG VARCHAR2 (255),
OTHER LONG,
PARTITION NUMBER,
PARTITION_START VARCHAR2 (255),
PARTITION_STOP VARCHAR2 (255),
DISTRIBUTION VARCHAR2 (30) ) tablespace non_SYSTEM_tablepsace
(表空间不存在,可以在当前表空间下创建)
ORA-02404: 未找到指定的计划表[@more@]创建对应的表
CREATE TABLE TOAD_PLAN_TABLE (
STATEMENT_ID VARCHAR2 (32),
TIMESTAMP DATE,
REMARKS VARCHAR2 (80),
OPERATION VARCHAR2 (30),
OPTIONS VARCHAR2 (30),
OBJECT_NODE VARCHAR2 (128),
OBJECT_OWNER VARCHAR2 (30),
OBJECT_NAME VARCHAR2 (30),
OBJECT_INSTANCE NUMBER,
OBJECT_TYPE VARCHAR2 (30),
SEARCH_COLUMNS NUMBER,
ID NUMBER,
COST NUMBER,
PARENT_ID NUMBER,
POSITION NUMBER,
CARDINALITY NUMBER,
OPTIMIZER VARCHAR2 (255),
BYTES NUMBER,
OTHER_TAG VARCHAR2 (255),
OTHER LONG,
PARTITION NUMBER,
PARTITION_START VARCHAR2 (255),
PARTITION_STOP VARCHAR2 (255),
DISTRIBUTION VARCHAR2 (30) ) tablespace non_SYSTEM_tablepsace
(表空间不存在,可以在当前表空间下创建)
create public synonym TOAD_PLAN_TABLE for TOAD_PLAN_TABLE;
grant all on TOAD_PLAN_TABLE to public;
创建表以后,直接点SQL Window的Explain Plan还不行,要选中相应的SQL语句,按上面的“小救护车”按钮,或者使用快捷键
“ctrl+e”,就可以正常查看。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/262387/viewspace-1030925/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/262387/viewspace-1030925/