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 18.104.22.168 to 22.214.171.124
HP OpenVMS VAX
HP OpenVMS Alpha
HP OpenVMS Itanium
Various lock stalls are seen in RMU/SHOW STATISTICS. These could be:
Excessive stalls for page locks
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 126.96.36.199 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!