SQL> exec show_space('MY_OBJECT','AUTO');
Total Blocks............................256
Total Bytes.............................2097152
Unused Blocks...........................64
Unused Bytes............................524288
Last Used Ext FileId....................17
Last Used Ext BlockId...................47240
Last Used Block.........................64

PL/SQL procedure successfully completed.

SQL> insert into my_object select * from my_object;

11448 rows created.


Execution Plan
----------------------------------------------------------
   0      INSERT STATEMENT Optimizer=CHOOSE
   1    0   TABLE ACCESS (FULL) OF 'MY_OBJECT'




Statistics
----------------------------------------------------------
         22  recursive calls
       1386  db block gets
        534  consistent gets
          0  physical reads
    1136844  redo size
        785  bytes sent via SQL*Net to client
        818  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
      11448  rows processed

SQL> exec show_space('MY_OBJECT','AUTO');
Total Blocks............................384
Total Bytes.............................3145728
Unused Blocks...........................64 不知道为什么Unused Blocks 不管我INSERT还是DELETE都不发生变化！
Unused Bytes............................524288
Last Used Ext FileId....................18
Last Used Ext BlockId...................49416
Last Used Block.........................64
SQL> insert into my_object select * from my_object;

22896 rows created.


Execution Plan
----------------------------------------------------------
   0      INSERT STATEMENT Optimizer=CHOOSE
   1    0   TABLE ACCESS (FULL) OF 'MY_OBJECT'




Statistics
----------------------------------------------------------
         43  recursive calls
       2764  db block gets
        907  consistent gets
          0  physical reads----为什么物理读总是0呢？
    2279992  redo size
        787  bytes sent via SQL*Net to client
        818  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
      22896  rows processed

SQL> select count(*) from my_object;


Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   SORT (AGGREGATE)
   2    1     TABLE ACCESS (FULL) OF 'MY_OBJECT'




Statistics
----------------------------------------------------------
          1  recursive calls
          1  db block gets
        569  consistent gets
          0  physical reads  ----为什么物理读总是0呢？
        120  redo size
        381  bytes sent via SQL*Net to client
        503  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

SQL>  exec show_space('MY_OBJECT','AUTO');
Total Blocks............................640
Total Bytes.............................5242880
Unused Blocks...........................64
Unused Bytes............................524288
Last Used Ext FileId....................18
Last Used Ext BlockId...................49544
Last Used Block.........................64

PL/SQL procedure successfully completed.

SQL>

0  physical reads，是因为未从磁盘上读数据；

Unused Blocks...........................64，是因为每次操作时，已用和未用的块空间不够，扩展后并满足操作后，剩余的未使用的块数都是64，个人感觉凑巧而已，可以试着进行一些其他操作，比如：刷新缓冲后再进行操作，向表里插入一些其他数据而不是用表自身的数据，因为用表自身的数据在空间上规律性比较强。个人想法，可以试试看。