Statistics
----------------------------------------------------------
223 recursive calls
97346 db block gets
7576 consistent gets
1 physical reads
19942160 redo size
866 bytes sent via SQL*Net to client
871 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
24 sorts (memory)
0 sorts (disk)
9999 rows processed
#删除9999笔记录，Redolog产生量25751700，耗时00:00:08.75
SQL> delete tb_rowid where rownum<10000;
9999 rows deleted.
Commit complete.
Elapsed: 00:00:08.75
Statistics
----------------------------------------------------------
227 recursive calls
136425 db block gets
2362 consistent gets
0 physical reads
25751700 redo size
866 bytes sent via SQL*Net to client
842 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
24 sorts (memory)
0 sorts (disk)
9999 rows processed
#删除9999笔记录，Redolog产生量25890548，耗时00:00:08.73
SQL> delete tb_rowid where rownum<10000;
9999 rows deleted.
Commit complete.
Elapsed: 00:00:08.73
Statistics
----------------------------------------------------------
204 recursive calls
136332 db block gets
2223 consistent gets
241 physical reads
25890548 redo size
868 bytes sent via SQL*Net to client
842 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
22 sorts (memory)
0 sorts (disk)
9999 rows processed
#更新9999笔记录，Redolog产生量42848860，耗时00:00:18.52
SQL> update tb_rowid set object_id=2 where rownum<10000;
9999 rows updated.
Commit complete.
Elapsed: 00:00:18.52
Statistics
----------------------------------------------------------
902 recursive calls
249586 db block gets
5487 consistent gets
292 physical reads
42848860 redo size
868 bytes sent via SQL*Net to client
858 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
24 sorts (memory)
0 sorts (disk)
9999 rows processed
#更新9999笔记录，Redolog产生量43267360，耗时00:00:16.95
SQL> update tb_rowid set object_id=2 where rownum<10000;
9999 rows updated.
Commit complete.
Elapsed: 00:00:16.95
Statistics
----------------------------------------------------------
215 recursive calls
250097 db block gets
4048 consistent gets
0 physical reads
43267360 redo size
868 bytes sent via SQL*Net to client
858 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
22 sorts (memory)
0 sorts (disk)
9999 rows processed
总结：
表上无物化视图日志 表上有物化视图日志 表上有物化视图日志且有一个快速刷新的物化视图
插入 1M/0.21秒 10M/3.73秒 20M/8.98秒
删除 4M/0.5秒 10M/3.88秒 25M/8.75秒
更新 1M/0.13秒 15M/6.94秒 40M/18.52秒