If there CPU is maxing out then it may be that you are forcing Oracle to
parse the queries too many times. Are you using host variables?
Jim
"Steve Salvemini" <steve.salvemini_at_adelaide.edu.au> wrote in message
news:3A77B3CE.21BAB04D_at_adelaide.edu.au...
> 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 - 07:39:31 CST
