Re: Performance problem

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 Received on Tue Jul 20 2004 - 21:57:13 CDT