RDBPROD: ENQLM 32767 sometimes used as effective limit (Doc ID 793382.1)

Last updated on APRIL 16, 2024

Applies to:

Symptoms

A process using Oracle Rdb may abort due to exceeded ENQLM quota. In some cases, there may be an EXCEEDED QUOTA message, in other cases a bugcheck.

Monitoring a process may also show the available ENQUEUE quota decreasing to the point where it has been or is about to be exhausted. The process may be checked with

or by using one of the quota watcher DCL procedures (see Doc ID 863180.1  or Doc ID 406047.1).

If a bugcheck has been generated, see Doc ID 65352.1 for instructions on identifying quota problems.

Having identified an ENQLM problem, why does this occur for a process where the limit was specified as 32767, or "virtually unlimited"?

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.