RDBPROD: Methods to Overcome Discarded Pages Caused by AIP Record Length Differences (Doc ID 258251.1)

Last updated on APRIL 16, 2024

Applies to:

Goal

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.

See section 3.10 in the Oracle Rdb7 Guide to Database Performance and Tuning, or the My Oracle Support article that was incorporated into the manual, which discuss excessive pages checked.

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.

Solution

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