Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow view needs optimization help
"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