Oracle DBWR觸發條件

透過以下檢視可以看到DBWR程式寫出block的觸發條件

引用

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.

資料庫版本為

引用

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

轉自：