My Oracle Support Banner

Questions on "pctfree" Value and Row Chaining (Doc ID 2302720.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.16.1.0.0 and later
Information in this document applies to any platform.

Goal

The upgrade from OHI Claims 2.14 to 2.16 is causing a lot of chained rows in the database.  Consequently a table re-org is being done as a pre-step to the upgrade using the following command:


The upgrade is causing around 20% of chained rows in these tables. Do we need to re-org these tables?  Will it impact our production in terms of performance.  If yes, how can we overcome this issue?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


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