VIEW:X$KCCRS-Controlfile Record Section directory (8.0 - 8.1)
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)
posted on 2013-03-19 00:32 Oracle和MySQL 阅读(165) 评论(0) 收藏 举报

2群基础群 适合刚入门的同学,会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群,空位多多,无需面试
浙公网安备 33010602011771号