Re: Performance problems oracle 8i

From: Robert Klemme <bob.news_at_gmx.net>
Date: Fri, 13 Jan 2006 17:32:09 +0100
Message-ID: <42q30bF1jri1tU1@individual.net>

legedoos_at_gmail.com wrote:
> We made a "cold" backup and used the db files for the copy. All
> tablespaces etc. are exact the same.
>
> The strange thing here is that the copy db is very fast and the
> original (production) is slow.

Hm, you wrote

> What I can see is that the production server uses
> lots more Physical Reads/s for the same query than the test server.

That's what one would expect: you said the production machine is more powerful.

Maybe there is more activity on the production machine (concurrent DB accesses, other activities, backup...) that slows it down. Or you have a concurrent long running transaction that keeps a lock on something your query needs. Lots of opportunities...

robert Received on Fri Jan 13 2006 - 10:32:09 CST