Re: Slow view needs optimization help

From: Robert Klemme <bob.news_at_gmx.net>
Date: Wed, 1 Jun 2005 14:51:45 +0200
Message-ID: <3g5pb2Faqg6pU1@individual.net>

Dmitry E. Loginov wrote:
> "Jon Davis" <jon_at_REMOVE.ME.jondavis.net> wrote in message
> news:Ch_me.161$Zt.20_at_okepread05...

>> ORA-02404: specified plan table not found
>>
>>
>> "Jon Davis" <jon_at_REMOVE.ME.jondavis.net> wrote in message
>> news:Pa_me.160$Zt.5_at_okepread05...
>>> I'm pretty new to Oracle, and I'm using TOAD. TOAD tells me that no
>>> execution plan tables exist. (??)
>>>

> Look in files
> Program Files\Quest Software\Toad\temps\toadprep.sql
> or
> Program Files\Quest Software\Toad\temps\notoad.sql

You can create it with /RDBMS/ADMIN/utlxplp.sql

Also look at "Performance Tuning Guide"
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/ex_plan.htm#19259

Kind regards

robert Received on Wed Jun 01 2005 - 07:51:45 CDT