Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i performance problem

Re: Oracle 8i performance problem

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 20 Mar 2002 15:08:05 GMT
Message-ID: <pB1m8.83918$q2.9174@sccrnsc01>


That is good information. My guess is that your batch processes are NOT using bind variables. So when the batch process runs it consumes a lot of CPU on the server. USE bind variables, you will reduce your cpu usage a lot and speed up the batch process. Point the developers to the Oracle Manual for application developers.
Jim
"Fax" <mollygog_at_wanadoo.fr> wrote in message news:a79s7n$i4f$1_at_wanadoo.fr...
> > There could be a lot of variables here.What major things are done on
> > your system at that time.It could be a lot of different things
> > CPU,Memory,Lots of sql ,slow network,better tuning of the database
> > etc.
> > Did you finally get to your alert log?
>
> Yes we did and it does not show anything wrong so far...
> Well the major operations done when the system freezes are batches. It
seems
> strange tho, that a few simple batch files can slow down the whole system
so
> much.
>
>
> anyways, thanks for your help and all :D
>
> > If you have more information feel free to update this thread
> > God bless
> > Michael Tubuo Ngong(Sr DBA)
>
>
Received on Wed Mar 20 2002 - 09:08:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US