Oracle DBWR触发条件

通过以下视图可以看到DBWR进程写出block的触发条件
[quote]SQL> select name,value from v$sysstat where name like 'DBWR%';

NAME VALUE
---------------------------------------------------------------- ----------
DBWR checkpoint buffers written 8173
DBWR thread checkpoint buffers written 5415
DBWR tablespace checkpoint buffers written 0
DBWR parallel query checkpoint buffers written 0
DBWR object drop buffers written 0
DBWR transaction table writes 40
DBWR undo block writes 106815
DBWR revisited being-written buffer 0
DBWR make free requests 0
DBWR lru scans 0
DBWR checkpoints 6
DBWR fusion writes 0

12 rows selected.[/quote]

数据库版本为
[quote]SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production[/quote]