"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
