Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Presentations

Diagnostics

Internals

Acknowledgements

Fixed View: X$KCBSW

Versions

Oracle Version X$ Version
10.1.0.3.0 3
10.2.0.1.0 3
11.1.0.6.0 4

Columns

Version 3

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
WHY0 NUMBER
WHY1 NUMBER
WHY2 NUMBER
OTHER_WAIT NUMBER

Version 4

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
OTHER_WAIT NUMBER

Indexes

Version 3

Version 3 of this fixed view has 2 indexes

Index Number Index Position Column Name
10ADDR
20INDX

Version 4

Version 4 of this fixed view has 2 indexes

Index Number Index Position Column Name
10ADDR
20INDX