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: Brian Dick <bdick_at_cox.net>
Date: Thu, 21 Mar 2002 15:27:46 GMT
Message-ID: <SZmm8.37760$PL1.1328321@news2.east.cox.net>


"Fax" <mollygog_at_wanadoo.fr> wrote in message news:a79s7n$i4f$1_at_wanadoo.fr...

>

> 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.

Are the batches using cursors that contain FOR UPDATE? Oracle locks all rows in the result set for a FOR UPDATE cursor. In some situations you can rewrite the cursors without the FOR UPDATE to avoid the locks. But that can get tricky.

--
Later,
BEDick
Received on Thu Mar 21 2002 - 09:27:46 CST

Original text of this message

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