Lock Table

[rash]

What does it mean by lock table &
What progress does in case of overflow of lock table? or can we overcome from this situation?

 

[veenit]

Lock table is virtual system table. you can access it by _lock table. For a progress session, the number of locks are predefined in pf file, if the lock exceeds that number then the lock overflow message appears.

To overcome this, handle the locks properly so that no unused lock left in the session and still problem persist then increase the -L limit in pf file.

 

[rzr]

@rash: I see a *pattern* / *direction* where you are going. If you are planning to attend any interview then search this forum & othe forums in this site for FAQ's. Even otherwise it should help you !

 

[RealHeavyDude]

Blowing a reasonably set lock table ( the multi-user default is 8192 ) is always a result of bad code - namely transactions scope larger than need be. There is not much you can do from the database point of view against clients with bad manners - you tell 'em, back their transactions out and kiss their bad attitude goodbye ...

Heavy Regards, RealHeavyDude.

 

[jdpjamesp]

@rash: I see a *pattern* / *direction* where you are going. If you are planning to attend any interview then search this forum & othe forums in this site for FAQ's. Even otherwise it should help you !

Indeed - most of the questions you ask have been asked before, in a very similar fashion. Therefore, a quick search will help