show_space 查询表数据块碎片问题 - show

实例：
SQL> set serveroutput on
SQL> exec show_space('HWCUST_ICSP_AGREEMENT_T','TABLE','AUTO','Y', NULL,'HWCUST') ;

---- 以下由DBMS_SPACE.UNUSED_SPACE输出
Total Blocks............................256 ---- 分配给object的总的blocks(高水位线上下的)
Total Bytes.............................2097152
Unused Blocks...........................128 ---- 分配了但是未被使用的Blocks，shrink能够释放的空间
Unused Bytes............................1048576 ---- HWM=total blocks-unused blocks. 这种计算得到的结果应该是high HWM的值。
Last Used Ext FileId....................4144 ---- Returns the file ID of the last extent which contains data
Last Used Ext BlockId...................807424 ---- Returns the starting block ID of the last extent which contains data
Last Used Block.........................128 ---- Returns the last block within this extent which contains data
---- 以下由 DBMS_SPACE.SPACE_USAGE 输出
Thesegment is analyzed
0% -- 25% free space blocks..............0
0% -- 25% free space bytes...............0
25% -- 50% free space blocks.............0
25% -- 50% free space bytes..............0
50% -- 75% free space blocks.............0
50% -- 75% free space bytes..............0
75% -- 100% free space blocks............31
75% -- 100% free space bytes.............253952
Unused (unformatted) Blocks...........................90
Unused (unformatted) Bytes............................737280
Total Blocks (100%)............................1
Total bytes (100%).............................8192
PL/SQL procedure successfully completed.
SQL>

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

转载于:http://blog.itpub.net/35489/viewspace-1409766/