Question: How the
the LOB retention storage work in 11g?
Answer: (Brian Peasland) In the
olden days, we would use the PCTVERSION storage parameter
for their LOB segments to reserve a percentage of storage
space for read consistency of LOB segments.
Starting with Oracle 11g, you can now use the RETENTION
The RETENTION parameter will use the
UNDO_RETENTION parameter for determining how long to keep
LOB data for read-consistency purposes. But please be
advised that the RETENTION parametervdoes not use the Undo
tablespace, and the LOB segment’s tablespace is used for
When you change the
UNDO_RETENTION parameter, the LOB segment’s retention value
is not modified. If you query the RETENTION column of the
DBA_LOBS view, you will notice the old UNDO_RETENTION value
still remains after you have modified the UNDO_RETENTION
parameter. To change the LOB segment’s RETENTION value to
match the new UNDO_RETENTION value, do the following:
ALTER TABLE my_table MODIFY LOB (lob_column) (PCTVERSION
ALTER TABLE my_table MODIFY LOB (lob_column)
By momentarily changing
the LOB to use PCTVERSION and then back to RETENTION, the
new value of UNDO_RETENTION will be used. You need to do
this for all LOB segments that you intend to modify.
Oracle Training from Don Burleson
The best on site
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
Burleson is the American Team
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
is the registered trademark of Oracle Corporation.