60
DBMS_SPACE

The DBMS_SPACE package enables you to analyze segment growth and space requirements.

This chapter discusses the following topics:

• Security

• Requirements

• Summary of DBMS_SPACE Subprograms

Security

This package runs with SYS privileges.

Requirements

The execution privilege is granted to PUBLIC. Subprograms in this package run under the caller security. The user must have ANALYZE privilege on the object.

Summary of DBMS_SPACE Subprograms

Table 60-1 DBMS_SPACE Subprograms

Subprogram	Description
"UNUSED_SPACE Procedure"	Returns information about unused space in an object (table, index, or cluster).
"FREE_BLOCKS Procedure"	Returns information about free blocks in an object (table, index, or cluster).
"SPACE_USAGE Procedure"	Returns information about free blocks in a bitmapped segment.