Re: RELICATION QUESTIONS

"Laconic2" <laconic2_at_comcast.net> wrote in message news:<0aidnd_xYv2NGEnd4p2dnA_at_comcast.com>...
> Is Oracle using the same optimizer in both instances?

If they are both using the cost-based optimizer, are the cost-based optimizer parameters (i.e. optimizer_index_cost_adjustment) identical?  What about things like multi-block read count?

When you analyze the tables on the two databases, are you using the same process to gather statistics? Or are you doing things differently-- different histograms, for example?

Justin Cave <jcave_at_ddbcinc.com>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

> "Paul" <paul821_at_yahoo.com> wrote in message
> news:CLXAc.21694$V57.5004971_at_news4.srv.hcvlny.cv.net...
> I have two databases (8.1.7), one master and one replicated. I'm
> getting different results in my explain plan from the same query. Both
> dbs have the same indexes and all tables have been analyzed.
>
> I'm using all the indexes I should on the master db but not on the
> replicated db. Does anyone have any ideas why the optimizer is behaving
> differently in the two databases?
>
> Thank you.
>
> --
> Paul
> --
Received on Sun Jun 20 2004 - 01:07:51 CEST