View: X$KCCRS [K]ernel [C]ache [C]ontrolfile management controlfile [R]ecord [S]ection directory Column Type Description -------- ---- ----------- ADDR RAW(4) address of this row/entry in the SGA INDX NUMBER control file record type The following are the non-circular-reuse record types: KCCDEDBI 0 DataBase Info record KCCDECKP 1 Checkpoint progress KCCDERTH 2 Redo THread record KCCDELOG 3 LOgFile record KCCDEDBF 4 DataBase File record KCCDENAM 5 file NAMe record KCCDETBS 6 8.x TaBleSpace record KCCDERS1 7 8.0 reserved for future use. non-circular re-use KCCDETFL 7 8.1 Temporary File record KCCDERS2 8 8.x reserved for future use. non-circular re-use KCCDERMC 8 9.x RMan Configuration record The following are the circular-Reuse record types: KCCDELHR 9 8.x Log History Record KCCDEORR 10 8.x Offline Range Record KCCDEALR 11 8.x Archived Log Record KCCDEBSR 12 8.x Backup Set Record KCCDEBPR 13 8.x Backup Piece Record KCCDEBFR 14 8.x Backup dataFile Record KCCDEBLR 15 8.x Backup redoLog Record KCCDEDCR 16 8.x Datafile Copy Record KCCDEFCR 17 8.x backup dataFile Corruption Record KCCDECCR 18 8.x datafile Copy Corruption Record KCCDEDLR 19 8.x DeLeted object Record KCCDERS3 20 8.0 reserved for future use. circular re-use. KCCDEPCR 20 8.1 proxy copy record KCCDERS4 21 8.x reserved for future use. circular re-use. KCCDENEN 6 7.3 actual # entry types in control file KCCDEMEN 10 7.3 max possible # entry types in control file KCCDEMNR 9 8.x MiNimum circular-Reuse record type KCCDEMXR 21 8.x MaXimum circular-Reuse record type KCCDEMAX 22 8.x MAX # record types in current format INST_ID NUMBER oracle instance number RSLBN NUMBER Logical Blk Number (base 1) of section start RSRSZ NUMBER Record SiZe in bytes RSNUM NUMBER NUMber of usable record slots in section RSNUS NUMBER circ-reuse: Number of in-USe slots in section non-circ-reuse: highest USed slot Number RSIOL NUMBER circ-reuse: Index (base 1) of OLdest (init 0) RSILW NUMBER circ-reuse: Index of Last Written (init 0) RSRLW NUMBER circ-reuse: Recid of Last Written (init 0) non-circ-reuse: incr'd by kccicr() (init 0)
VIEW:X$KCCRS-Controlfile Record Section directory (8.0 – 8.1)
2008/06/08 by Leave a Comment
Comment