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

Last updated on AUGUST 30, 2017

Applies to:

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

Goal

QUESTION #1
===========

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

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