kshenes wrote:

>
> Is there anyway to determine which clients are consuming the locks?

Yes for classic, no for superserver

> Is there anyway to determine which transactions are causing the locks?
>

Yes. The answer in both cases is to get a lock print. I think that
just -o will give you enough information since it includes the owner
blocks and the number of lock requests each owner has.

The primary use of lock table space is "latches" - transient locks on
pages in the cache. The larger the cache, the more pages can be locked.
The more active transactions, the more owners, thus the more locks on
pages.

Regards,


Ann