Forum Post: RE: Lock Table Overflow

  • Thread starter Thread starter TheMadDBA
  • Start date Start date
Status
Not open for further replies.
T

TheMadDBA

Guest
The database log is only going to give you the PID and possibly the userid (depends on how they are connecting). Sometimes this will end up being a victim of another program that just pushed the lock table near the limits, sometimes it will be the offending process. If it was actually doing DB updates and not just locks there should be some info in AISCAN, but like you said it can be a pain to look through especially if you have a lot of activity.

Continue reading...
 
Status
Not open for further replies.
Back
Top