Statistics
----------------------------------------------------------
43 recursive calls
42877 db block gets
572 consistent gets
27 physical reads
11019692 redo size
865 bytes sent via SQL*Net to client
842 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
3 sorts (memory)
0 sorts (disk)
9999 rows processed
#删除9999笔记录，Redolog产生量11010468，耗时00:00:03.73
SQL> delete tb_rowid where rownum<10000;
9999 rows deleted.
Commit complete.
Elapsed: 00:00:03.73
Statistics
----------------------------------------------------------
18 recursive calls
42846 db block gets
592 consistent gets
0 physical reads
11010468 redo size
865 bytes sent via SQL*Net to client
842 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
9999 rows processed
#更新9999笔记录，Redolog产生量16150340，耗时00:00:06.94
SQL> update tb_rowid set object_id=2 where rownum<10000;
9999 rows updated.
Commit complete.
Elapsed: 00:00:06.94
Statistics
----------------------------------------------------------
51 recursive calls
73132 db block gets
1292 consistent gets
109 physical reads
16150340 redo size
865 bytes sent via SQL*Net to client
858 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
3 sorts (memory)
0 sorts (disk)
9999 rows processed
#更新9999笔记录，Redolog产生量16078152，耗时00:00:07.19
SQL> update tb_rowid set object_id=2 where rownum<10000;
9999 rows updated.
Commit complete.
Elapsed: 00:00:07.19
Statistics
----------------------------------------------------------
30 recursive calls
91767 db block gets
1160 consistent gets
1 physical reads
16078152 redo size
865 bytes sent via SQL*Net to client
858 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
9999 rows processed
#表tb_rowid上有快速刷新物化视图
#建物化视图mv_tb_rowid
SQL> create materialized view mv_tb_rowid tablespace users refresh fast on commit with rowid as select * from tb_rowid;
Materialized view created.
Elapsed: 00:00:29.52
#插入9999笔记录，Redolog产生量20177192，耗时00:00:08.98
SQL> insert into tb_rowid select * from tb_rowid where rownum<10000;
9999 rows created.
Commit complete.
Elapsed: 00:00:08.98
Statistics
----------------------------------------------------------
1415 recursive calls
98178 db block gets
4696 consistent gets
412 physical reads
20177192 redo size
866 bytes sent via SQL*Net to client
870 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
92 sorts (memory)
0 sorts (disk)
9999 rows processed
#插入9999笔记录，Redolog产生量19942160，耗时00:00:07.26
SQL> insert into tb_rowid select * from tb_rowid where rownum<10000;
9999 rows created.
Commit complete.
Elapsed: 00:00:07.26