Skip to Content
0
Nov 30, 2011 at 05:48 AM

ENQUEUE and DEQUEUE in a loop

1040 Views

Hi All,

I have a program where I am doing locking and unlocking at the record level.

This ENQUEUE and DEQUEUE is being done in a loop. So, the flow of the code in a single loop pass is as follows:

ENQUEUE-> Update-> DEQUEUE.

Since I am trying to update close to 100000-150000 records, the lock table gets overflowed and program is terminated.

MY question:

If i am doing a DEQUEUE in the loop pass itself, ideally the lock entry should be deleted from the lock table. Why does the entries dont get deleted and the lock table overflow appears?

Note:

1. I am correctly doing a locking and unlocking at the record level.

2. I am aware that we should do mass updation by using table level lock rather than record level lock.

Thanks & Regards,

Swati Dogra