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: Jon Davis <jon_at_REMOVE.ME.jondavis.net>
Date: Tue, 31 May 2005 07:12:51 -0700
Message-ID: <Ch_me.161$Zt.20@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
>>
>
>
Received on Tue May 31 2005 - 09:12:51 CDT

Original text of this message

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