My Oracle Support Banner

RDBPROD: Excessive Page locks or Deacklocks with APF enabled (Doc ID 222110.1)

Last updated on APRIL 14, 2022

Applies to:

Oracle Rdb Server on OpenVMS - Version to
HP OpenVMS Alpha
HP OpenVMS Itanium


Various lock stalls are seen in RMU/SHOW STATISTICS. These could be:
    Excessive stalls for page locks
    Excessive deadlocks
    If it's a standby database, excessive stalls for SPAM page locks

APF (Asynchronous Prefech) is enabled on the database.


Upgrade to Oracle Rdb release or Oracle Rdb release 7.1


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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