How to fix DB Contention in XXX_SOAINFRA.soaqtz_LOCKS table
(Doc ID 2810980.1)
Last updated on MAY 15, 2023
Applies to:
Oracle SOA Suite - Version 12.2.1.4.0 to 12.2.1.4.0 [Release 12c]Information in this document applies to any platform.
Symptoms
It was noted a Database contention in the XXX_SOAINFRA.soaqtz_LOCKS table: (long running SQL Statement)
UPDATE soaqtz_LOCKS SET LOCK_NAME = LOCK_NAME WHERE LOCK_NAME = :1
ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /u01/app/oracle/diag/rdbms/r7cfn1d1/r7cfn1d1/trace/r7cfn1d1_ora_9675.trc.
2021-09-09T13:58:32.949767-04:00
Errors in file /u01/app/oracle/diag/rdbms/r7cfn1d1/r7cfn1d1/trace/r7cfn1d1_ora_10200.trc:
2021-09-09T13:58:33.899350-04:00
ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /u01/app/oracle/diag/rdbms/r7cfn1d1/r7cfn1d1/trace/r7cfn1d1_ora_10200.trc.
2021-09-09T13:58:35.936344-04:00
Errors in file /u01/app/oracle/diag/rdbms/r7cfn1d1/r7cfn1d1/trace/r7cfn1d1_ora_9064.trc:
2021-09-09T13:58:36.724454-04:00
ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /u01/app/oracle/diag/rdbms/r7cfn1d1/r7cfn1d1/trace/r7cfn1d1_ora_9064.trc.
2021-09-09T13:58:40.941546-04:00
Errors in file /u01/app/oracle/diag/rdbms/r7cfn1d1/r7cfn1d1/trace/r7cfn1d1_ora_12725.trc:
2021-09-09T13:58:41.329958-04:00
ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /u01/app/oracle/diag/rdbms/r7cfn1d1/r7cfn1d1/trace/r7cfn1d1_ora_12725.trc.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |