Re: Calculating LOCKS
On Thu, 20 Jan 2000, Pablo Herrero wrote:
>
>
> Hi all,
>
> I'm looking for the way of calculating the maximun number of locks I
> could have in an environment in order to set "LOCKS" in onconfig file.
>
> Thanks
> --
> Pablo F Herrero Fernandez
> Gijon
> Asturias (Spain)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Locks do not take much in the way of resources so there is not much wasted
if they are set high. A rough (very rough) starting point would be
pick the largest transaction you will process, add one lock for each row,
plus one lock for each index on that row. Multiply by the number of users
actively hitting the database at the same time, and you will have your
starting point.
You can monitor lock starvation by using onstat -p and looking at the
ovlock field, which is a cumulative count of lock requests that did not
have sufficient locks.
====================================================================
Harold Luse Phone: (970) 491-4120
Veterinary Teaching Hospital Fax: (970) 491-4123
Colorado State University Pager: (970) 229-8173
Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu
====================================================================