My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2022

Applies to:

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


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?


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

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