My Oracle Support Banner

Rebuilding LOB freepools (Doc ID 365156.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [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
 What does the modify do?
 Tracking the progress of the rebuild
 Very slow progress?
 Can the operation be canceled?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.