Rebuilding LOB freepools
(Doc ID 365156.1)
Last updated on MARCH 05, 2019
Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 9.2 to 11.2]
Information in this document applies to any platform.
This bulletin explains what happens when you specify a statement to change the number of freepools for a CLOB, like:
SQL> alter table [tablename] modify lob ([clob name]) (freepools [n]);
The bulletin explains what this statement does and how to monitor the execution progress.
This article gives an overview of what happens internally when the number of freepools are changed, and how to monitor the progress. This can be useful when investigating problems in this area.
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.