Re: Performance problem

"Michael Austin" <maustin_at_firstdbasource.com> wrote in message news:i6wLc.16546$2L6.10191_at_newssvr23.news.prodigy.com...
> Daniel Morgan wrote:
>
> > Shankar wrote:
> >
> >> hello,
> >> We are moving one of the user from one database ( database A) to
> >> another database (database B)
> >>
> >> Both are cost based and query executed against the db A comes back in
> >> 10 seconds (its a big query), but it takes about 2 minutes+ in the db
> >> B.
> >>
> >> Server configuration are same ( db A's server and db B's server) and
> >> all the parameter set up for db A and db B are exactly same.
> >>
> >> Currently user count on each server is also very minimum.
> >> Explain plan for the query is same for both the dbs.
> >>
> >> so what are we missing? why so much difference in the performance?
> >
> >
> > No hardware platform
> > No operating system
> > No verion information
> > No edition name
> > No index information
> > No EXPLAIN PLAN
> > No trace file
> > No information on validity of statitistics
> > No information on the optimizer
> > No information on parameter values
> > No RDA
> > No Stats Pack
> > No information on other transactions
> >
> > What do you want us to do? Guess!
> >
> > Ok ... I guess orange. Well actually more of a peach color than orange.
> >
> > Daniel Morgan
> >
>
> I was thinking 42 :)

Or a quote from the Pointy-haired boss in Dilbert: "I think mauve has the most RAM"

>
> --
> Michael Austin.
> Consultant - Available.
> Donations welcomed. http://www.firstdbasource.com/donations.html
> :)
Received on Wed Jul 21 2004 - 14:24:51 CDT