Is it recommended to change the PCTVERSION to 0 to reduce the size of the segments for the EDR lobs?
Last updated on MARCH 08, 2017
Applies to:Oracle E-Records - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Nov-2012***
Based on <note 298698.1>, Oracle recommend to change the PCTVERSION to 0 for the segment SYS_LOB0000034032C00004$$ related with table FND_LOBS
Is it recommended to change the PCTVERSION to 0 to reduce the size of the segments for the lobs EDR.SYS_LOB0000240378C00002$$ and SYS_LOB0000240378C00003$$ as well?
The lob segments SYS_LOB0000240378C00002$$ and SYS_LOB0000240378C00003$$ related with the table EDR.EDR_PSIG_DOCUMENTS are growing more than 2G by month which is more than expected. We had a similar issue with the lob related with FND_lOB table, so we changed the pctversion to 0 for the lob segment APPLSYS.SYS_LOB0000034032C00004$$ according with the metalink note 298698.1 and it seems that solved the issue.
Could you please confirm if there is a similar action to perform for this 2 lobs of EDR.EDR_PSIG_DOCUMENTS?
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