Parameter enque/table_size value

[Former Member]

Hi All,

We face several times lock table overflow issue, Which cause users to hang up for some time for work.

So we are planning to increase size of Enqueue table , I checked parameter enque/table_size it is set to 32768 in our system.

Please suggest the recommandations to increase value of parameter enque/table_size or how can we calculate best suited value of this enq parameter.

Regards,

Shivam

[Former Member]

Hi,

The enqueue ceiling is 1GB of memory, effectively giving you a maximum of 91,000+ locks.

But as mentioned above, size the enqueue depending on your system resources.

I have in the past had a problem when on AIX where I increased the enqueue parameter and the system started up with no locks at all.

This was due to some IPC parameter sizing in the instance profile..

Mark

[former_member213250]

This message was moderated.

[sunny_pahuja2]

Hi,

As such there is no standard value that you can set for this parameter. You need to set this parameter according to your system. Please refer below link for more information:

http://help.sap.com/saphelp_nw04/helpdata/en/37/a2e3ab344411d3acb00000e83539c3/content.htm

Thanks

Sunny