Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Fixed View: X$KCBWDS

Versions

Oracle Version X$ Version
10.1.0.3.0 12
10.2.0.1.0 14
11.1.0.6.0 14

Columns

Version 12

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
SET_ID NUMBER
DBWR_NUM NUMBER
BLK_SIZE NUMBER
PROC_GROUP NUMBER
CNUM_SET NUMBER
FLAG NUMBER
CKPT_LATCH RAW(4)
CKPT_LATCH1 RAW(4)
SET_LATCH RAW(4)
NXT_REPL RAW(4)
PRV_REPL RAW(4)
NXT_REPLAX RAW(4)
PRV_REPLAX RAW(4)
CNUM_REPL NUMBER
ANUM_REPL NUMBER
COLD_HD RAW(4)
HBMAX NUMBER
HBUFS NUMBER
NXT_WRITE RAW(4)
PRV_WRITE RAW(4)
NXT_WRITEAX RAW(4)
PRV_WRITEAX RAW(4)
CNUM_WRITE NUMBER
ANUM_WRITE NUMBER
NXT_XOBJ RAW(4)
PRV_XOBJ RAW(4)
NXT_XOBJAX RAW(4)
PRV_XOBJAX RAW(4)
CNUM_XOBJ NUMBER
ANUM_XOBJ NUMBER
NXT_XRNG RAW(4)
PRV_XRNG RAW(4)
NXT_XRNGAX RAW(4)
PRV_XRNGAX RAW(4)
CNUM_XRNG NUMBER
ANUM_XRNG NUMBER
NXT_REQ RAW(4)
PRV_REQ RAW(4)
NXT_REQAX RAW(4)
PRV_REQAX RAW(4)
CNUM_REQ NUMBER
ANUM_REQ NUMBER
BUF_GOT NUMBER
SUM_WRT NUMBER
SUM_SCN NUMBER
NUM_SCN NUMBER
HOT_SCN NUMBER
PIN_SCN NUMBER
WRT_MOV NUMBER
AUX_MOV NUMBER
FBWAIT NUMBER
WCWAIT NUMBER
BBWAIT NUMBER
FBINSP NUMBER
DBINSP NUMBER
PNINSP NUMBER
HOTMVS NUMBER
DBBCHG NUMBER
DBBGET NUMBER
CONGET NUMBER
PREAD NUMBER
PWRITE NUMBER
FGSDEPTH NUMBER
DBHDEPTH NUMBER
TGTCLEAN NUMBER
PWBCNT NUMBER

Version 14

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
SET_ID NUMBER
DBWR_NUM NUMBER
BLK_SIZE NUMBER
PROC_GROUP NUMBER
CNUM_SET NUMBER
FLAG NUMBER
CKPT_LATCH RAW(4)
CKPT_LATCH1 RAW(4)
SET_LATCH RAW(4)
NXT_REPL RAW(4)
PRV_REPL RAW(4)
NXT_REPLAX RAW(4)
PRV_REPLAX RAW(4)
CNUM_REPL NUMBER
ANUM_REPL NUMBER
COLD_HD RAW(4)
HBMAX NUMBER
HBUFS NUMBER
NXT_WRITE RAW(4)
PRV_WRITE RAW(4)
NXT_WRITEAX RAW(4)
PRV_WRITEAX RAW(4)
CNUM_WRITE NUMBER
ANUM_WRITE NUMBER
NXT_XOBJ RAW(4)
PRV_XOBJ RAW(4)
NXT_XOBJAX RAW(4)
PRV_XOBJAX RAW(4)
CNUM_XOBJ NUMBER
ANUM_XOBJ NUMBER
NXT_XRNG RAW(4)
PRV_XRNG RAW(4)
NXT_XRNGAX RAW(4)
PRV_XRNGAX RAW(4)
CNUM_XRNG NUMBER
ANUM_XRNG NUMBER
NXT_REQ RAW(4)
PRV_REQ RAW(4)
NXT_REQAX RAW(4)
PRV_REQAX RAW(4)
CNUM_REQ NUMBER
ANUM_REQ NUMBER
BUF_GOT NUMBER
SUM_WRT NUMBER
SUM_SCN NUMBER
FBWAIT NUMBER
WCWAIT NUMBER
BBWAIT NUMBER
FBINSP NUMBER
DBINSP NUMBER
PNINSP NUMBER
HOTMVS NUMBER
DBBCHG NUMBER
DBBGET NUMBER
CONGET NUMBER
PREAD NUMBER
PWRITE NUMBER
FGSDEPTH NUMBER
TGTCLEAN NUMBER
PWBCNT NUMBER
PROTCNT NUMBER

Indexes

Version 12

Version 12 of this fixed view has 2 indexes

Index Number Index Position Column Name
10ADDR
20INDX

Version 14

Version 14 of this fixed view has 2 indexes

Index Number Index Position Column Name
10ADDR
20INDX