10.2.0.5的库,设置16m db_cache_size,sga_max=0 (内存自动调节功能禁止)
scott.big表占6902个block(db_block__size 8k)
update big set created=sysdate;
commit;
2 and s.NAME
3 in( 'undo change vector size','redo size');
NAME VALUE
---------------------------------------------------------------- ----------
redo size 0
undo change vector size 0
SQL> select count(*) from scott.big;
COUNT(*)
----------
40714
SQL>
SQL> select s.name,m.VALUE from v$mystat m,v$statname s where m.statistic#=s.STATISTIC#
2 and s.NAME
3 in( 'undo change vector size','redo size');
NAME VALUE
---------------------------------------------------------------- ----------
redo size 490836
undo change vector size 0
delay block cleanout没有产生undo