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 -> reason of block level lock ?

reason of block level lock ?

From: Jaret Lafoudravecmonhné <toto_at_toto.com>
Date: Wed, 17 Jul 2002 10:09:34 +0200
Message-ID: <ah386m$9rm$1@reader1.imaginet.fr> 






Hello,



this night a program which run in multi-instance is fallen in dead-lock.
Typical "No-row" dead-lock you obtain  when INITRANS is too low.



But INITRANS is 16 on the table the deadlock appears and only 4 instances of
the program (massive delete) work on this table.



Initrans is 16 since the creation on this table.



So is there another reason to obtain these sort of deadlock ?




thanks for any help.



Ludo
Received on Wed Jul 17 2002 - 03:09:34 CDT












Original text of this message













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