REM
REM The script yields the following output:
REM
REM   Unformatted Blocks = 0 
REM   FS1 Blocks         = 0 
REM   FS2 Blocks         = 0 
REM   FS3 Blocks         = 0 
REM   FS4 Blocks         = 1 
REM   Full Blocks        = 9 

REM Where:
REM 
REM   FS1 means 0-25%   free space within a block 
REM  FS2 means 25-50%  free space within a block 
REM  FS3 means 50-75%  free space within a block 
REM  FS4 means 75-100% free space within a block 


SET serveroutput on

DECLARE 
 v_unformatted_blocks number; 
 v_unformatted_bytes number; 
 v_fs1_blocks number; 
 v_fs1_bytes number; 
 v_fs2_blocks number; 
 v_fs2_bytes number; 
 v_fs3_blocks number; 
 v_fs3_bytes number; 
 v_fs4_blocks number; 
 v_fs4_bytes number; 
 v_full_blocks number; 
 v_full_bytes number; 

BEGIN 
dbms_space.space_usage ('SYSTEM', 'TEST', 'TABLE', v_unformatted_blocks, v_unformatted_bytes, v_fs1_blocks, v_fs1_bytes, v_fs2_blocks, v_fs2_bytes, v_fs3_blocks, v_fs3_bytes, v_fs4_blocks, v_fs4_bytes, v_full_blocks, v_full_bytes); 
dbms_output.put_line('Unformatted Blocks = '||v_unformatted_blocks); 
dbms_output.put_line('FS1 Blocks         = '||v_fs1_blocks); 
dbms_output.put_line('FS2 Blocks         = '||v_fs2_blocks); 
dbms_output.put_line('FS3 Blocks         = '||v_fs3_blocks); 
dbms_output.put_line('FS4 Blocks         = '||v_fs4_blocks); 
dbms_output.put_line('Full Blocks        = '||v_full_blocks); 
end; 
