Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i performance problem
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