Обсуждение: Help with database locking

Поиск
Список
Период
Сортировка

Help with database locking

От
Matt Beauregard
Дата:
We're having awful trouble with something getting locks on one of our
tables (or locks on something) and shutting out other clients.  Is
there a way of getting a list of what locks are active, or logging
them as they're set and unset?  Do locks have a timeout, and can we
adjust it?  We're running 7.0.3.  Any suggestions would be greatly
appreciated.


--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233   Fx: +61 2 9361 4633