Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Fixed View: X$KCCBI

Versions

Oracle Version X$ Version
10.1.0.3.0 1
10.2.0.1.0 1
11.1.0.6.0 2

Columns

Version 1

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
BIRID NUMBER
BITSM VARCHAR2(20)
BISTM NUMBER
BIBSS NUMBER
BIBSC NUMBER
BIMDT VARCHAR2(20)
BIFSZ NUMBER
BISIX NUMBER

Version 2

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
BIRID NUMBER
BITSM VARCHAR2(20)
BISTM NUMBER
BIBSS NUMBER
BIBSC NUMBER
BIMDT VARCHAR2(20)
BIFSZ NUMBER
BISIX NUMBER
BIDUN VARCHAR2(30)
BIFLG NUMBER

Indexes

Version 1

Version 1 of this fixed view has one index

Index Number Index Position Column Name
10BIRID

Version 2

Version 2 of this fixed view has one index

Index Number Index Position Column Name
10BIRID