Oracle in a Nutshell

Calls

PROCEDURE DBMS_SPACE.FREE_BLOCKS (segment_owner IN VARCHAR2, segment_name IN VARCHAR2, segment_type IN VARCHAR2, freelist_group_id IN NUMBER, free_blks OUT NUMBER [,scan_limit IN NUMBER DEFAULT NULL] [,partition_name IN VARCHAR2 DEFAULT NULL]);

Returns into free_blks the number of blocks on the freelist on instance freelist_group_id for segment segment_name of type segment_type (TABLE, INDEX, or CLUSTER) owned by segment_owner in partition partition_name (optional, new with Oracle8). scan_limit (optional) limits the number of free blocks scanned.

PROCEDURE DBMS_SPACE.SPACE_USAGE (segment_owner IN VARCHAR2, segment_name IN VARCHAR2, segment_type IN VARCHAR2, unformatted_blocks OUT NUMBER, unformatted_bytes OUT NUMBER, fs1_blocks OUT NUMBER, fs1_bytes OUT NUMBER, fs2_blocks OUT NUMBER, fs2_bytes OUT NUMBER, fs3_blocks OUT NUMBER, fs3_bytes OUT NUMBER, fs4_blocks OUT NUMBER, fs4_bytes OUT NUMBER, full_blocks OUT NUMBER, full_bytes OUT NUMBER, partition_name IN VARCHAR2 DEFAULT NULL);

Returns unused space in segment_name owned by segment_owner in partition_name of segment_type (TABLE, INDEX, or CLUSTER). Parameters display the number of blocks and bytes that are unformatted, with less than 25% free space (fs1), 25-50% free space (fs2), 50-75% free space (fs3), and at least 75% free space (fs4), as well as the number of blocks and bytes that are full. New with Oracle9i.

PROCEDURE DBMS_SPACE.UNUSED_SPACE (segment_owner IN VARCHAR2, segment_name IN VARCHAR2, segment_type IN VARCHAR2, ...