1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
SQL> create table dvp2 as select * from all_objects where rownum=1;
Table created.
SQL> alter table dvp2 minimize records_per_block;
Table altered.
SQL> analyze table dvp2 compute statistics;
Table analyzed.
SQL> select table_name,num_rows,blocks from all_tables where table_name='DVP2';
TABLE_NAME NUM_ROWS BLOCKS
------------------------------ ---------- ----------
DVP2 1 1
SQL> insert into dvp2 select * from all_objects;
61423 rows created.
SQL> commit;
Commit complete.
SQL> analyze table dvp2 compute statistics;
Table analyzed.
SQL> select table_name,num_rows,blocks from all_tables where table_name='DVP2';
TABLE_NAME NUM_ROWS BLOCKS
------------------------------ ---------- ----------
DVP2 61424 30716 |
Partager