Performance issue

We have a oracle database setup on a development platform and one on the pre-production platform, both of similar spec, but the pre-prod database is very slow. The cpu maxes out when queries are sent through to it. The link is a 100mb link from the client, so network speed is not expected to be the problem.

The development db is probably slightly bigger in size.

This is a very broad question I know, but perhaps there are several key things for me to check, ie

on the apps side:
- check the optimisation mode choose/rule

• depending on mode, check indexes/statistics
• test the qep in both databases for sample sql's to check results are the same on both the client and the server
• check versions of oracle are the same and similarly patched
• check operating system versions are the same and similarly patched
• check settings in the v$parameter between the 2 databases

on the server side:
pretty limited in my knowledge here...
- compare contents of oracle.ini

• any ideas ???

Thanks for any ideas Received on Wed Jan 31 2001 - 00:42:22 CST