My Oracle Support Banner

Rebuilding LOB freepools (Doc ID 365156.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.



Purpose

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.

Scope

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.

Details

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
Purpose
Scope
Details
 What does the modify do?
 Tracking the progress of the rebuild
 Very slow progress?
 Can the operation be canceled?
 Alternatives
 Warning:
References

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