Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slow view needs optimization help

Re: Slow view needs optimization help

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 31 May 2005 14:29:07 GMT
Message-ID: <Xns96674C251D2F0SunnySD@68.6.19.6>


"Jon Davis" <jon_at_REMOVE.ME.jondavis.net> wrote in 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. (??)
>>
>> Jon
>>
>> "Robert Klemme" <bob.news_at_gmx.net> wrote in message 
>> news:3g38ktF9u9bbU1_at_individual.net...
>>> Jon Davis wrote:
>>>> This might be too much hassle for most of you but someone might be up
>>>> for a good challenge. I need to figure out how to optimize this query
>>>> (at bottom of this post) for Oracle 9i.
>>>
>>> <snip/>
>>>
>>> Did you look at the execution plan?  Did it give you any hints?
>>>
>>>    robert
>>>
>>
>> 

>
>

SQL> @$ORACLE_HOME/rdbms/admin/dbmsxpln.sql -- SHOULD CREATE THE NECESSARY PLAN_TABLE for you Received on Tue May 31 2005 - 09:29:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US