December 2002
Intermediate to advanced
928 pages
85h 29m
English
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, ...