熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle10gEventsCONTROLF的改變

2013-11-13 15:39:51  來源: Oracle 

  《深入淺出Oracle》的一個讀者在我的留言板上提出一個問題他說以下這條命令運行生成的跟蹤文件和我書上的結果完全不同

alter session set events immediate trace name controlf level ;

  注意一下他的輸出:

DUMP OF CONTROL FILES Seq # = xe
V STYLE FILE HEADER:
Compatibility Vsn = =xa
Db ID==xecd Db Name=TESTDB
Activation ID==x
Control Seq==xe File size==xa
File Number= Blksiz= File Type= CONTROL

  原來是V Style的輸出這是Oracleg的數據庫我書中第一章的測試來自OracleiR由於events是Oracle的內部事件其行為在不同的版本中可能不同

  在Oracleg中使用Level 的trace得到以下的輸出
在這個輸出中和Oraclei最大的不同是enabled threads部分增加了位圖信息這個信息的增加我猜測是為了滿足Oracleg Grid運算支持大量並行實例的需要Level 及的trace將包含DUMP memory的信息可讀性又有所降低了

  記錄一下還有待於進一步研究

DUMP OF CONTROL FILES Seq # = xa
V STYLE FILE HEADER:
Compatibility Vsn = =xa
Db ID==x Db Name=EYGLE
Activation ID==x
Control Seq==xa File size==xae
File Number= Blksiz= File Type= CONTROL




***************************************************************************
DATABASE ENTRY
***************************************************************************
(size = compat size = section max = section inuse =
lastrecid= oldrecno = lastrecno = )
(extent = blkno = numrecs = )
// ::
DB Name EYGLE
Database flags = x x
Controlfile Creation Timestamp // ::
Incmplt recovery scn: x
Resetlogs scn: x Resetlogs Timestamp // ::
Prior resetlogs scn: x Prior resetlogs Timestamp // ::
Redo Version: compatible=xa
#Data files = #Online files =
Database checkpoint: Thread= scn: xa
Threads: #Enabled= #Open= Head= Tail=
enabled threads:
















Max log members = Max data members =
Arch list: Head= Tail= Force scn: xaebscn: x
Activation ID:
Controlfile Checkpointed at scn: xd // ::
thread: rba:(x)
enabled threads:




*************************************************************************** CHECKPOINT PROGRESS RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = )
(extent = blkno = numrecs = )
THREAD # status:x flags:x dirty: low cache rba:(xdc) on disk rba:(xdf) on disk scn: xc // :: resetlogs scn: x // :: heartbeat: mount id: THREAD # status:x flags:x dirty: low cache rba:(x) on disk rba:(x) on disk scn: x // :: resetlogs scn: x // :: heartbeat: mount id: THREAD # status:x flags:x dirty: low cache rba:(x) on disk rba:(x) on disk scn: x // :: resetlogs scn: x // :: heartbeat: mount id: THREAD # status:x flags:x dirty: low cache rba:(x) on disk rba:(x) on disk scn: x // :: resetlogs scn: x // :: heartbeat: mount id: THREAD # status:x flags:x dirty: low cache rba:(x) on disk rba:(x) on disk scn: x // :: resetlogs scn: x // :: heartbeat: mount id: THREAD # status:x flags:x dirty: low cache rba:(x) on disk rba:(x) on disk scn: x // :: resetlogs scn: x // :: heartbeat: mount id: THREAD # status:x flags:x dirty: low cache rba:(x) on disk rba:(x) on disk scn: x // :: resetlogs scn: x // :: heartbeat: mount id: THREAD # status:x flags:x dirty: low cache rba:(x) on disk rba:(x) on disk scn: x // :: resetlogs scn: x // :: heartbeat: mount id: *************************************************************************** EXTENDED DATABASE ENTRY ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) Control AutoBackup date(dd/mm/yyyy)=/ / Next AutoBackup sequence= Database recovery target inc#: Last open inc#: flg:x flag:x Change tracking state= file index= checkpoint count= Flashback log count= block count= Oldest guarantee restore point= ***************************************************************************
REDO THREAD RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) THREAD # status:xf thread links forward: back: #logs: first: last: current: last used seq#:x enabled at scn: x // :: disabled at scn: x // :: opened at // :: by instance eygle Checkpointed at scn: xa // :: thread: rba:(xad) enabled threads: log history: ***************************************************************************
LOG FILE RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) LOG FILE #: (name #) D:\ORADATA\EYGLE\ONLINELOG\O_MF__GOGOQG_LOG (name #) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O_MF__GOGTJH_LOG Thread redo log links: forward: backward: siz: x seq: x hws: xd bsz: nab: xed flg: x dup: Archive links: fwrd: back: Prev scn: xaeb Low scn: xed // :: Next scn: xb // :: LOG FILE #: (name #) D:\ORADATA\EYGLE\ONLINELOG\O_MF__GOGZKN_LOG (name #) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O_MF__GOHJL_LOG Thread redo log links: forward: backward: siz: x seq: x hws: x bsz: nab: xffffffff flg: x dup: Archive links: fwrd: back: Prev scn: xed Low scn: xb // :: Next scn: xffffffffffff // :: LOG FILE #: (name #) D:\ORADATA\EYGLE\ONLINELOG\O_MF__GOHQ_LOG (name #) D:\ORADATA\FLASH_RECOVERY_AREA\EYGLE\ONLINELOG\O_MF__GOHXX_LOG Thread redo log links: forward: backward: siz: x seq: x hws: xf bsz: nab: xffd flg: x dup: Archive links: fwrd: back: Prev scn: xbc Low scn: xaeb // :: Next scn: xed // :: ***************************************************************************
DATA FILE RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) DATA FILE #: (name #) D:\ORADATA\EYGLE\DATAFILE\O_MF_SYSTEM_GOHFX_DBF creation size= block size= status=xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x // :: Checkpoint cnt: scn: xa // :: Stop scn: xffffffffffff // :: Creation Checkpointed at scn: x // :: thread: rba:(x) enabled threads: Offline scn: x prev_range: Online Checkpointed at scn: x thread: rba:(x) enabled threads: Hot Backup end marker scn: x aux_file is NOT DEFINED DATA FILE #: (name #) D:\ORADATA\EYGLE\DATAFILE\O_MF_UNDOTBS_GOJNB_DBF creation size= block size= status=xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x // :: Checkpoint cnt: scn: xa // :: Stop scn: xffffffffffff // :: Creation Checkpointed at scn: xcc // :: thread: rba:(xab) enabled threads: Offline scn: x prev_range: Online Checkpointed at scn: x thread: rba:(x) enabled threads: Hot Backup end marker scn: x aux_file is NOT DEFINED DATA FILE #: (name #) D:\ORADATA\EYGLE\DATAFILE\O_MF_SYSAUX_GOJHP_DBF creation size= block size= status=xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x // :: Checkpoint cnt: scn: xa // :: Stop scn: xffffffffffff // :: Creation Checkpointed at scn: xe // :: thread: rba:(xac) enabled threads: Offline scn: x prev_range: Online Checkpointed at scn: x thread: rba:(x) enabled threads: Hot Backup end marker scn: x aux_file is NOT DEFINED DATA FILE #: (name #) D:\ORADATA\EYGLE\DATAFILE\O_MF_USERS_GOJYYS_DBF creation size= block size= status=xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x // :: Checkpoint cnt: scn: xa // :: Stop scn: xffffffffffff // :: Creation Checkpointed at scn: xf // :: thread: rba:(xf) enabled threads: Offline scn: x prev_range: Online Checkpointed at scn: x thread: rba:(x) enabled threads: Hot Backup end marker scn: x aux_file is NOT DEFINED ***************************************************************************
TEMP FILE RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) TEMP FILE #: External File # (name #) D:\ORADATA\EYGLE\DATAFILE\O_MF_TEMP_GOJPDX_TMP creation size= block size= status=xe head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: x // :: TEMP FILE #: External File # creation size= block size= status=xc head= tail= dup= tablespace index= krfil= prev_file= unrecoverable scn: xa // :: *************************************************************************** TABLESPACE RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) TABLESPACE # SYSTEM: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x // :: Tablespace PITR last completion scn: x // :: TABLESPACE # UNDOTBS: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x // :: Tablespace PITR last completion scn: x // :: TABLESPACE # SYSAUX: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x // :: Tablespace PITR last completion scn: x // :: TABLESPACE # TEMP: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x // :: Tablespace PITR last completion scn: x // :: TABLESPACE # USERS: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x // :: Tablespace PITR last completion scn: x // :: TABLESPACE # TEMP: recno= First datafile link= Tablespace Flag= Tablespace PITR mode start scn: x // :: Tablespace PITR last completion scn: x // :: ***************************************************************************
RMAN CONFIGURATION RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** FLASHBACK LOGFILE RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** THREAD INSTANCE MAPPING RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) eygle recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= UNNAMED_INSTANCE_ recno= ***************************************************************************
MTTR RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) MTTR record for thread MTTR statistics status: Init time: Avg: us Times measured: File open time: Avg: us Times measured: Log block read time: Avg: us Times measured: Data block read/claim time: Avg: us Times measured: Data block write time: Avg: us change vector apply time: Avg: us Times measured: Ratio Information: # of log blocks measured: # of data blocks measured: # of change vectors measured: *************************************************************************** STANDBY DATABASE MAP RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** RESTORE POINT RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) ***************************************************************************
LOG FILE HISTORY RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) Earliest record: RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: x // :: Next scn: xa Latest record: RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xed // :: Next scn: xb RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xaeb // :: Next scn: xed RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xbc // :: Next scn: xaeb RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: x // :: Next scn: xbc RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: x // :: Next scn: x RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xfb // :: Next scn: x RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xb // :: Next scn: xfb RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xda // :: Next scn: xb RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xeaff // :: Next scn: xda RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: x // :: Next scn: xeaff RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xe // :: Next scn: x RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xca // :: Next scn: xe RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: x // :: Next scn: xca RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xefa // :: Next scn: x RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xfd // :: Next scn: xefa RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xb // :: Next scn: xfd RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: x // :: Next scn: xb RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xed // :: Next scn: x RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: x // :: Next scn: xed RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xef // :: Next scn: x RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: xa // :: Next scn: xef RECID # Recno Record timestamp // :: Thread= Seq#= LinkRecid= kccicRecid= Low scn: x // :: Next scn: xa *************************************************************************** OFFLINE RANGE RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** ARCHIVED LOG RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP SET RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP PIECE RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP DATAFILE RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP LOG RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** DATAFILE COPY RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** BACKUP DATAFILE CORRUPTION RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** DATAFILE COPY CORRUPTION RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** DELETION RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) ***************************************************************************
PROXY COPY RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** INCARNATION RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) Earliest record: RECID # Recno Record timestamp Resetlogs scn and time scn: x // :: Previous Resetlogs scn and time scn: x // :: Incarnation (parent inc# flag)=( ) Latest record: RECID # Recno Record timestamp Resetlogs scn and time scn: x // :: Previous Resetlogs scn and time scn: x // :: Incarnation (parent inc# flag)=( ) ***************************************************************************
RMAN STATUS RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** DATAFILE HISTORY RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *************************************************************************** NORMAL RESTORE POINT RECORDS ***************************************************************************
(size = compat size = section max = section inuse = lastrecid= oldrecno = lastrecno = ) (extent = blkno = numrecs = ) *** END OF DUMP ***

  The End

  tml


From:http://tw.wingwit.com/Article/program/Oracle/201311/17097.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.