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@xxxxxxxxxxx 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. >=================================================== >-- >//www.freelists.org/webpage/oracle-l > >. -- //www.freelists.org/webpage/oracle-l