SQL> exec show_space('idx_test_keyno');
 
 
## the tablespace of this segment is AUTO ##
 
total_blocks-----------------------> 896
total_bytes------------------------> 7(m)
unused_blocks----------------------> 54
unused_bytes-----------------------> 0.42(m)
last_used_extent_file_id-----------> 6
last_used_extent_block_id----------> 6921
last_used_block--------------------> 74
unformatted_blocks-----------------> 0
unformatted_bytes------------------> 0(m)
 0% --  25% free space blocks------> 0
 0% --  25% free space bytes-------> 0(m)
25% --  50% free space blocks------> 1
25% --  50% free space bytes-------> 0.01(m)
50% --  75% free space blocks------> 0
50% --  75% free space bytes-------> 0(m)
75% -- 100% free space blocks------> 0
75% -- 100% free space bytes-------> 0(m)
full_blocks------------------------> 819
full_bytes-------------------------> 6.4(m)
 
PL/SQL procedure successfully completed
 
SQL> exec show_space('test');
 
 
## the tablespace of this segment is AUTO ##
 
total_blocks-----------------------> 6032
total_bytes------------------------> 47.13(m)
unused_blocks----------------------> 7
unused_bytes-----------------------> 0.05(m)
last_used_extent_file_id-----------> 6
last_used_extent_block_id----------> 6153
last_used_block--------------------> 9
unformatted_blocks-----------------> 0
unformatted_bytes------------------> 0(m)
 0% --  25% free space blocks------> 2
 0% --  25% free space bytes-------> 0.02(m)
25% --  50% free space blocks------> 1
25% --  50% free space bytes-------> 0.01(m)
50% --  75% free space blocks------> 0
50% --  75% free space bytes-------> 0(m)
75% -- 100% free space blocks------> 0
75% -- 100% free space bytes-------> 0(m)
full_blocks------------------------> 5918
full_bytes-------------------------> 46.23(m)
 
PL/SQL procedure successfully completed