Re: EXPLAIN PLAN differences

From: bgt0990 <btighe_at_neometrics.com>
Date: Tue, 4 Jun 2002 14:50:49 -0400
Message-ID: <3cfd0a63$1_5@corp-goliath.newsgroups.com>

Are the 2 database setups identical, init.ora etc? Memory settings, cursor settings, etc etc all affect the cost based optimizer. Let's see the actual explain plans and code!

Barry

"Richard Spee" <rhpspee_at_wxs.nl> wrote in message news:adirii$ilc$1_at_reader12.wxs.nl...
> Seems as if execution plans are different.
> Use stored outlines to provide execution plan stability.
> Read about this new feature of Oracle8i.
>
>
> "traceable1" <traceable1_at_hotmail.com> wrote in message
> news:8551d8c9.0206040837.364b51f7_at_posting.google.com...
> > Please Help!!
> >
> > If I do an execution plan on the same query on 2 different boxes, I
> > get different results (Cost 26 vs 158). What does this mean? I'm
> > trying to make the two databases behave the same, but they will not.
> > One box has a lot more data than the other, but statistics have been
> > run. I've checked the OPTIMIZER_MODE, what else could be causing the
> > difference?
> > They are both Oracle 8.1.7 on W2K.
> >
> > Any thoughts are very much appreciated!!
> >
> > Trace
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Jun 04 2002 - 13:50:49 CDT