Re: Performance issue

Actually yes, most of the work is being done through OCI wrappers and C++ programs (also some spatial), do you have some experience with this problem?

Jim Kennedy wrote:
>
> 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

-- 
-----------------------------------------------------------

Steven Salvemini
Peoplesoft Technical Specialist, Information Technology Services
ADELAIDE UNIVERSITY SA 5005
AUSTRALIA
Tel: +61 8 8303 6358  Fax: +61 8 8303 4400
Email: steve.salvemini_at_adelaide.edu.au

----------------------------------------------------------- 
This email message is intended only for the addressee(s) 
and contains information which may be confidential and/or
copyright.  If you are not the intended recipient please
do not read, save, forward, disclose, or copy the contents
of this email. If this email has been sent to you in error,
please delete this email and any copies or links to this
email completely and immediately from your system.  No 
representation is made that this email is free of viruses.
Virus scanning is recommended and is the responsibility of 
the recipient.