show_space应用

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22745099/viewspace-625739/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22745099/viewspace-625739/