Re: lock table overflow
After bringing the server online for about 2 hours, onstat -p shows"
ovrlocks = 12
ovrbufs = 23
bufwaits = 265372
lokreqs = 64million+
In onconfig:
LOCKS = 20,000BUFFS = 200
Does this seem reasonable?
If not, what values would be appropriate?
What other parameters should I check?
> Bill,
> what is onstat -p showing for ovlocks?
>
sending to informix-list
On Wed, 20 Aug 2003 14:04:49 -0500, "Bill Hamilton" <bham@finsco.com>
wrote:
>
>After bringing the server online for about 2 hours, onstat -p shows"
>ovrlocks = 12
>ovrbufs = 23
>bufwaits = 265372
>lokreqs = 64million+
>
>In onconfig:
>LOCKS = 20,000>BUFFS = 200
>
>Does this seem reasonable?
Only 200 BUFFERS seems a bit too few . . .. how much physical memory
is on your server?
Any way to see what process is hitting the ovrlock condition??
>If not, what values would be appropriate?
>What other parameters should I check?
>
>> Bill,
>> what is onstat -p showing for ovlocks?
>>
>sending to informix-list