Performance problems oracle 8i

Hi there!

We have a problem. We are converting data of a database to an oracle environment. Therefore we have a production server (win 2000 4 processors, a bulk of memory) and a test server (win 2000, only one processor, less memory). The production server should be faster than the test server.

We wrote lots of scripts on the test environment and this all was ok. But now we're trying the scripts on the production server and it all works very slow.

For testing we copied the production db to the test db, so the table spaces, tables, indexes where exactly the same. We use Spotlight to monitor the servers. What I can see is that the production server uses lots more Physical Reads/s for the same query than the test server. The test server finishes the script in 5 minutes, and the production server took all night and wasn't finished this morning.

Settings like SGA, buffer size and archive logging are the same on both servers.

Anyone an idea about what can be the problem?

Thanks in advance!

Rob Received on Fri Jan 13 2006 - 05:01:12 CST