How to create PLAN_TABLE in my schema,its my personal computer where i have installed oracle 9i,i need to practice Explain plan technique to optimize the query.please can anybody give me the detailed steps for this process.thanks in advance laxmi

Interview Candidate
Jan 14th, 2007
3
3741

Showing Answers 1 - 3 of 3 Answers

suresh

Mar 7th, 2007

you can create a a plan_table, by searching in the oracle folder of c drive in ur computer. look for the file utlxplan which usually resides in c:oracleora92rdbmsadmin. where u can get the script and create plan table.

and the syntax being
Explain plan into plan_table for
<sql statement>.

the above will populate the details in the table.
there is another specific query u have to look up to get the result in a readable format from the plan_table.
u can fing it very easy in google.
all the best.