RDBPROD: Methods to Overcome Discarded Pages Caused by AIP Record Length Differences
(Doc ID 258251.1)
Last updated on APRIL 14, 2022
Oracle Rdb Server on OpenVMS - Version 7.0 and later HP OpenVMS Alpha HP OpenVMS VAX HP OpenVMS Itanium
There is a table in the database for which excessive discarded pages are observed during inserts. This causes performance degradation. One reason could be that the record length in the area inventory page (AIP) differs from the real record length. Adding a column to the table is one cause of this difference.
In this case, the table should be reorganized to avoid discarded pages. This can be done by changing the record length in the AIP, or by changing the threshold value for the logical area.
Other causes for excessive discarded pages could be locked free space in the area, or incorrect threshold settings on that area.
This article describes how to change the record length and/or the threshold value to fix a problem where the AIP record length differs from the real record length. See the Guide to Database Performance and Tuning for details on the other two causes.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!