|
|
|
|
| Re: ORA-024012: PLAN_TABLE not found [message #158071 is a reply to message #157399] |
Wed, 08 February 2006 07:00   |
bhagwan
Messages: 86
Registered: September 2004
|
Member |
|
|
If you are using TOAD to access your DB..run the below script and then look for explain plan.
CREATE TABLE TOAD_PLAN_TABLE
(
STATEMENT_ID VARCHAR2(30 BYTE),
TIMESTAMP DATE,
REMARKS VARCHAR2(80 BYTE),
OPERATION VARCHAR2(30 BYTE),
OPTIONS VARCHAR2(30 BYTE),
OBJECT_NODE VARCHAR2(128 BYTE),
OBJECT_OWNER VARCHAR2(30 BYTE),
OBJECT_NAME VARCHAR2(30 BYTE),
OBJECT_INSTANCE INTEGER,
OBJECT_TYPE VARCHAR2(30 BYTE),
OPTIMIZER VARCHAR2(255 BYTE),
SEARCH_COLUMNS NUMBER,
ID INTEGER,
PARENT_ID INTEGER,
POSITION INTEGER,
COST INTEGER,
CARDINALITY INTEGER,
BYTES INTEGER,
OTHER_TAG VARCHAR2(255 BYTE),
PARTITION_START VARCHAR2(255 BYTE),
PARTITION_STOP VARCHAR2(255 BYTE),
PARTITION_ID INTEGER,
OTHER LONG,
DISTRIBUTION VARCHAR2(30 BYTE)
)
Rgds,
Bhagwan
|
|
|
|
| Re: ORA-024012: PLAN_TABLE not found [message #158106 is a reply to message #157381] |
Wed, 08 February 2006 09:08 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Don't use that create table script, automatically, to create your plan table. The table, and information available, changes from version to version. The performance tuning guide walks you through how to configure the plan_table if it isn't already done so. Basically there is a script that each version of oracle provides that you can run. utlxplan.sql I believe in the rdbms/admin folder.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
