Oracle Internals

JulianDyke.com

Acknowledgements

Fixed View: X$KCBSH

Versions

Oracle Version	X$ Version
10.1.0.3.0	2
10.2.0.1.0	2
11.1.0.6.0	2

Columns

Version 2

Column Name	Data Type
ADDR	RAW(4)
INDX	NUMBER
INST_ID	NUMBER
TS#	NUMBER
DBARFIL	NUMBER
DBABLK	NUMBER
SET_ID	NUMBER
SEGIDX	NUMBER

Indexes

Version 2

Version 2 of this fixed view does not have any indexes