Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Presentations

Diagnostics

Internals

Acknowledgements

Fixed View: X$KCCBL

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
BLRID NUMBER
BLTSM VARCHAR2(20)
BLSTM NUMBER
BLBSS NUMBER
BLBSC NUMBER
BLTHP NUMBER
BLSEQ NUMBER
BLRLS VARCHAR2(16)
BLRLC VARCHAR2(20)
BLLOS VARCHAR2(16)
BLLOT VARCHAR2(20)
BLNXS VARCHAR2(16)
BLNXT VARCHAR2(20)
BLBCT NUMBER
BLBSZ NUMBER
BLSIX NUMBER

Version 4

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
BLRID NUMBER
BLTSM VARCHAR2(20)
BLSTM NUMBER
BLBSS NUMBER
BLBSC NUMBER
BLTHP NUMBER
BLSEQ NUMBER
BLRLS VARCHAR2(16)
BLRLC VARCHAR2(20)
BLLOS VARCHAR2(16)
BLLOT VARCHAR2(20)
BLNXS VARCHAR2(16)
BLNXT VARCHAR2(20)
BLBCT NUMBER
BLBSZ NUMBER
BLSIX NUMBER
BLFLG NUMBER

Indexes

Version 3

Version 3 of this fixed view has one index

Index Number Index Position Column Name
10BLRID

Version 4

Version 4 of this fixed view has one index

Index Number Index Position Column Name
10BLRID