Concurrent Processing - ORA-00060: Deadlock Detected - UPDATE FND_CONCURRENT_QUEUES
(Doc ID 866298.1)
Last updated on MAY 05, 2024
Applies to:
Oracle Concurrent Processing - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]Information in this document applies to any platform.
Alert, log, concurrent, ORA-00060:, Deadlock Detected, UPDATE FND_CONCURRENT_QUEUES, FND_CONCURRENT_REQUESTS
Symptoms
The Alert log reports an ORA-00060: Deadlock on a daily basis on the FND_CONCURRENT_QUEUES table:
"Mon Jul 27 01:47:28 2009
ORA-00060: Deadlock detected. More info in file
/ora/TEST/dumpdest/diag/rdbms/TEST/TEST/trace/TEST_ora_14335.trc.
...
DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
...
----- Current SQL Statement for this session (sql_id=fxrsqg45jy3kt) -----
UPDATE FND_CONCURRENT_QUEUES SET RUNNING_PROCESSES = 1, MAX_PROCESSES = 1, CONTROL_CODE = NULL
WHERE MANAGER_TYPE = 6 AND NODE_NAME = :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xfb2e1fe0 88 package body APPS.FND_CP_FNDSM
0xfb36ec50 1 anonymous block
..."
ORA-00060: Deadlock detected. More info in file
/ora/TEST/dumpdest/diag/rdbms/TEST/TEST/trace/TEST_ora_14335.trc.
...
DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
...
----- Current SQL Statement for this session (sql_id=fxrsqg45jy3kt) -----
UPDATE FND_CONCURRENT_QUEUES SET RUNNING_PROCESSES = 1, MAX_PROCESSES = 1, CONTROL_CODE = NULL
WHERE MANAGER_TYPE = 6 AND NODE_NAME = :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xfb2e1fe0 88 package body APPS.FND_CP_FNDSM
0xfb36ec50 1 anonymous block
..."
The deadlock can also occur with the FND_CONCURRENT_REQUESTS table.
Changes
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 |
| Changes |
| Cause |
| Solution |
| Information Center, Diagnostics, & Community |
| References |