Questions on "pctfree" Value and Row Chaining
(Doc ID 2302720.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Health Insurance Claims Adjudication - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 8-February-2019***
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