ORA-000060: Deadlock detected.
I'm having this kind of error on my sql statements.
ORA-000060: Deadlock detected.
Here is the exact error that i got:
DEADLOCK DETECTED
Current SQL statement for this session:
INSERT INTO P_WORK_ITEM_VERSION(WORK_VERSION_ID,ACTIVITY_ID,PARENT_ACTIVITY_ID,WORK_ITEM_ID,PROCESS_TYPE_CODE,CU RRENT_IND,BOX_TYPE_CODE,VERSION,DELETED_IND,PRIORITY_CODE,STATUS_CODE,EMAIL_SENT_IND,VIEWED_IND,RECI PIENTS,SENDERS,SENDER_USER_ID,SENDER_APP_ID,SENT_DATETIME,BOX_ACTOR_TYPE_CODE,BOX_ACTOR_ID,BOX_APP_I D,OWNER_USER_ID,OWNER_APP_ID,HAS_ATTACHMENTS_IND,HAS_COMMENTS_IND,CREATION_DATETIME,CREATED_BY,LAST_ UPDATE_DATETIME,LAST_UPDATE_BY,ERROR_DISPLAY_MESSAGE,ERROR_EXCEPTION_MESSAGE,ERROR_DATETIME,EXPIRED_ IND,PREVIOUS_EXPIRED_IND,PROCESSED_IND,CASCADE_ITERATION,CASCADE_ASSIGN_DATETIME,REMOTE_IND,PERSONAL _SUBFLOW_CORRELATION,PARENT_VERSION_ID,PREVIOUS_ERROR_IND,EXPIRED_EMAIL_SENT_IND,ACTIVITY_PATH,RECLO CK) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27, :28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44)
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-000500bc-000003e3 13 20 X 18 19 S
TX-0003009a-000003e8 18 19 X 13 20 S
session 20: DID 0001-000D-00000002 session 19: DID 0001-0012-00000002
session 19: DID 0001-0012-00000002 session 20: DID 0001-000D-00000002
Rows waited on:
Session 19: no row
Session 20: no row
What should I do to resolve this?.. Thanks!