DBMS_SPACE.UNUSED_SPACE Usage
(Doc ID 116923.1)
Last updated on FEBRUARY 18, 2025
Applies to:
PL/SQL - Version 8.1.5.0 to 10.2.0.4Oracle 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 |