My Oracle Support Banner

DBMS_SPACE.UNUSED_SPACE Usage (Doc ID 116923.1)

Last updated on OCTOBER 14, 2019

Applies to:

PL/SQL - Version 8.1.5.0 to 10.2.0.4
Oracle Database - Enterprise Edition - Version 8.1.5.0 to 10.2.0.4 [Release 8.1.5 to 10.2]
Information in this document applies to any platform.

PL/SQL - Version: 8.1.5.0 to 10.2.0.4
Information in this document applies to any platform.
Last tested: 23-Jul-2012 against a 10.2.0.4 Database

Purpose

This package provides segment space information not currently available through the standard views. The DBMS_SPACE package enables the analysis of segment growth and space requirements. The DBMS_SPACE package is created by dbmsutil.sql script that is called by catproc.sql.

This note illustrates an example using the UNUSED_SPACE procedure.

Scope

Here are some Security related items to keep in mind:
--------------------------------------------------------
- Package runs with SYS privileges.
- The execution privilege is granted to PUBLIC. Procedures in this package run under the CALLER security.
- The user must have ANALYZE privilege on the object.

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
References

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