I believe this is what query plan stability gives you in 8i (maybe 8.1.6).
Ceratinly the plans are stored seperately (under the OUTLN account, though
wether you can have more than 1 I don't recall - we can't use them because
its an enterprise only feature).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message
news:3921284b.1437528_at_news-server...
> On Mon, 15 May 2000 21:50:26 GMT, michael_bialik_at_my-deja.com wrote:
>
> >
> > There is a new feature called QUERY OUTLINE from 8.1.5 and up.
> > I didn't try it yet, but it's supposed to solve the problem
> > of execution plan stability in CBO environment.
> >
>
> ORACLE needs to explore the possibility of separately stored and named
> "execution plans" like DB2 does. That is the way to go. Flexible, and
> it satisfies EVERY possible situation or combination.
Received on Fri May 19 2000 - 00:00:00 CDT
