RDBPROD: How to identify fragmented rows in a table (Doc ID 283203.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1.3 and later
HP OpenVMS Alpha
HP OpenVMS Itanium


Goal

The purpose of this article is to explain how to identify rows in a table that are fragmented, causing extra IO and CPU to fetch data.

Fragmentation occurs when either the row is too large to fit entirely on a page or an existing row was updated to a larger size and no space existed at that time for the expanded row. The first case requires that the page size be changed for the area. However, for the second case a DELETE and INSERT of the row might remove the fragmentation. In that case, the RDB$$IS_ROW_FRAGMENTED function, introduced in Oracle Rdb version 7.1.3, allows the DBA to identify candidate fragmented rows.

Solution

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 hundreds of Community platforms