前幾天說過，Oracle10g Events CONTROLF的改變，當時猜測控制文件的變化可能是為了滿足Oracle10g Grid運算支持大量並行實例的需要。 單實例節點控制文件轉儲包含的位圖如下:
Database checkpoint: Thread=1 scn: 0x0000.0007276a
Threads: #Enabled=1, #Open=1, Head=1, Tail=1
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
今天轉儲了一個RAC數據庫的控制文件，驗證了這個猜測：
***************************************************************************
DATABASE ENTRY
***************************************************************************
(size = 316, compat size = 316, section max = 1, section in-use = 1,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 1, numrecs = 1)
12/27/2006 16:25:27
DB Name "EYGLE"
Database flags = 0x00404000 0x00001000
Controlfile Creation Timestamp 12/27/2006 16:25:30
Incmplt recovery scn: 0x0000.00000000
Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp 12/27/2006 16:25:27
Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp 01/01/1988 00:00:00
Redo Version: compatible=0xa200100
#Data files = 5, #Online files = 5
Database checkpoint: Thread=2 scn: 0x0000.008a8531
Threads: #Enabled=2, #Open=2, Head=2, Tail=1
enabled threads: 01100000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
Oracle不斷的將位圖引入數據庫的各個治理單元，顯然旨在性能提高。 -The End- http://www.eygle.com/archives/2007/02/controlfile_bitmap.Html
