alter table move & shrink space(2)

ALTER TABLE GC.R_WIP_KEYPARTS_T  MOVE

 

analyze table GC.R_WIP_KEYPARTS_T compute statistics;

 

SELECT BLOCKS,EMPTY_BLOCKS FROM DBA_TABLES

WHERE OWNER='GC' AND TABLE_NAME='R_WIP_KEYPARTS_T';

BLOCKS:137381 --move之后看到BLOCKS減少

EMPTY_BLOCKS:1883

 

SELECT BLOCKS FROM DBA_SEGMENTS WHERE SEGMENT_NAME='R_WIP_KEYPARTS_T';

BLOCKS:139264 --空間并沒有回收，總的塊數還是139264，但HWM下降到了137381

注：DBA_TABLES中欄位含義

BLOCKS*	Number of used data blocks in the table
EMPTY_BLOCKS*	Number of empty (never used) data blocks in the table