剖析shrink 操作原理

在上一篇介绍了move 的操作，这篇介绍下shrink 操作:

 

在oracle 10g之后，推出了，shrink 操作，使用shrink 操作的时候索引可以不失效，这个对应用系统的影响要小不少。

SQL> create table daodao (id int, name char(2000)) tablespace users;  

Table created.

SQL> insert into daodao select rownum,'ddd' from dba_objects where rownum <=50;

50 rows created.

SQL> commit;

Commit complete.


SQL> show user;
USER is "SYS"
SQL> select header_file,header_block from dba_segments where segment_name ='DAODAO';

HEADER_FILE HEADER_BLOCK
----------- ------------
          4         2387


SQL> set pages 2000;
SQL> select Dbms_Rowid.rowid_block_number(rowid),count(1)  from daodao group by  Dbms_Rowid.rowid_block_number(rowid) ;

DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)   COUNT(1)
------------------------------------ ----------
                                2388          3
                                2389          3
                                2398          3
                                2390          3
                                2393          3
                                2395          3
                                2399          3
                                2400          3
                                2404          3
                                2405          3
                                2391          3
                                2397          3
                                2392          3
                                2406          3
                                2407          2
                                2394          3