Re: Deadlock read

hi,Chadi Kassan

does the table has unique constraint/PK/unique indexes ? what is the initrans/pctfree   

you can dump the block via package dbms_rowid and the rowid how much space is left in the block? row migration ?

Best regards

msn: biti_rainy_at_hotmail.com
a dba from alibaba(china)

• from the mail-----
  >Hi everyone,
  >
  >Can anyone explain what caused this deadlock or how to read this kind of
  >deadlock (i'm just wondering how it happens with the insert).
  >
  >thank you
  >
  >=================================================
  >DEADLOCK DETECTED
  >Current SQL statement for this session:
  >INSERT INTO COLORS (color_code, clr_id, clr_name, bu_bu_id) VALUES (:1, :2,
  >:3, :4)
  >The following deadlock is not an ORACLE error. It is a
  >deadlock due to user error in the design of an application
  >or from issuing incorrect ad-hoc SQL. The following
  >information may aid in determining the deadlock:
  >Deadlock graph:
  > ---------Blocker(s)--------
  >---------Waiter(s)---------
  >Resource Name process session holds waits process session holds
  >waits
  >TX-0056001a-0000008d 50 368 X 74 426
  >S
  >TX-00660018-0000006f 74 426 X 50 368
  >S
  >session 368: DID 0001-0032-00039980 session 426: DID 0001-004A-00022694
  >session 426: DID 0001-004A-00022694 session 368: DID 0001-0032-00039980
  >Rows waited on:
  >Session 426: obj - rowid = 000101AA - AAAQGqAAXAAAAkKAAA
  > (dictionary objn - 65962, file - 23, block - 2314, slot - 0)
  >Session 368: obj - rowid = 000101C7 - AAAQHHAAWAAAGANAAA
  > (dictionary objn - 65991, file - 22, block - 24589, slot - 0)
  >Information on the OTHER waiting sessions:
  >Session 426:
  > pid=74 serial=2070 audsid=189403 user: 71/ADI_IL_TEST
  > O/S info: user: , term: , ospid: 1234, machine: esjmstst01
  > program:
  > Current SQL Statement:
  > INSERT INTO COLORS (color_code, clr_id, clr_name, bu_bu_id) VALUES (:1,
  >:2, :3, :4)
  >End of information on OTHER waiting sessions.
  >===================================================
  >--
  >http://www.freelists.org/webpage/oracle-l
  >
  >.
  

--
http://www.freelists.org/webpage/oracle-l