RDBPROD: How to identify fragmented rows in a table
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
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.
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