Re: Performance problem

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 21 Jul 2004 15:38:54 GMT
Message-ID: <i6wLc.16546$2L6.10191@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 :)

-- 
Michael Austin.
Consultant - Available.
Donations welcomed. http://www.firstdbasource.com/donations.html
:)

Received on Wed Jul 21 2004 - 10:38:54 CDT