Problems using the Explain Plan Window

[laurarana]

Hi,

I have a SQL query that is not optimized, and I obtain the results in around 45 minuts. I know that usign the Explain Plan Window, I can optimize the query. My problem is that Cost and Cardinality are not displayed. I saw the help on line information, and there is written that:

"If you are using Oracle Server 7.2 or earlier, the cost and cardinality are not available in the plan table. If you are using Oracle Server 7.3 or higher and cost and cardinality are not displayed, you probably need to upgrade the plan table".

I have two databases, one in Oracle Server 7.3.8 and one in Oracle Server 8.1.7.

Anybody can tell me how can I upgrade the plan table?

Thanks a lot,

LAURA ARANA

 

[Christo Kutrovsky]

Look in your $ORACLE_HOME/rdbms/admin directory and you will find a script that creates the proper explain plan table.

if I remember right it should be utlx*.sql. If you can't find it to a grep:

grep -i "PLAN_TABLE" *.sql

in that directory.