This discussion is archived
4 Replies Latest reply: Jul 7, 2013 7:09 PM by Hemant K Chitale RSS

Deadlock issues when a program runs first time after Database bounce but doesn't face issue later on until again db is bounced

BLKR Newbie
Currently Being Moderated

Current configuration of database:

Database version --

OS: Linux x86-64



Recently upgraded from to



To Explain the issue:


Recently it has come to our notice that 1 of our concurrent program gets locking issues immediately after a Database and application bounce.

This issue had been coming up after we upgraded our Database from 10g to 11g.

We generally have our maintenance during the weekend(sunday) once or twice a month depending on business need.


Immediately after the Database Upgrade when the Program was submitted it failed with the below error.



Team then applied the fix as in note id: 974396.1


execute immediate('ALTER session SET '||'"_fix_control"'||'='||'''5909305:OFF''');


It then has been brought up to us now that the same program is now facing problems with Locks.

In general what's happening is whenever we have a DB and application services bounce, the very first time after bounce when the program is submitted it gets locking issues as below:


Issue with Application program is not completely ruled out but same code worked fine in 10g and it also works fine after a few days of maintenance.



Cause: You are trying to lock a row in the pay_org_paym

Error creating Paycard Payment Method for Employee Number :1031699 :ORA-20001: The current row is locked



After a week or two of bounce when the Program is submitted it never faces any locks issue.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points