oracle 整理表碎片

公司数据库10.2.0.1.0 

通过命令set autotrace traceonly   explain stat

select count(1) from T;

发现consistent gets 读取比表实际行数多10倍，可能是数据库删除太多数据导致。

	  0  recursive calls
	  0  db block gets
     557965  consistent gets
	  0  physical reads
	  0  redo size
	519  bytes sent via SQL*Net to client
	469  bytes received via SQL*Net from client
	  2  SQL*Net roundtrips to/from client
	  0  sorts (memory)
	  0  sorts (disk)
	  1  rows processed

1.允许表数据可移动

alter table LOGOUT_ACCOUNT enable row movement;

2.整理表
alter table LOGOUT_ACCOUNT shrink space;