為何all_table_modifications沒有定時更新

資料庫版本:10.2.0.3
OS:rhel4 U 4

10G中每15分鐘smon會將sga中儲存的修改資料資料flush到XXX_table_modifications中,但我測試發現oracle並沒有這樣做.

Monitoring tracks the approximate number of INSERT, UPDATE, and DELETE
operations for the table since the last time statistics were gathered.
information about how many rows are affected is maintained in the SGA,
until periodically (about every 15 minutes) SMON flush the data into the data
dictionary.

而是晚上22:00時才flush了一次.測試過程就不貼了,我寫了個指令碼只要all_table_modifications有更新的話就會寫一筆資料到定義的表中.

懷疑是不是10.2.0.3的bug?

[ 本帖最後由 jolly10 於 2008-5-23 10:18 編輯 ]