Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Fixed View: X$KCCAL

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
ALRID NUMBER
ALPRC NUMBER
ALTSM VARCHAR2(20)
ALSTM NUMBER
ALFLG NUMBER
ALTHP NUMBER
ALSEQ NUMBER
ALRLS VARCHAR2(16)
ALRLC VARCHAR2(20)
ALLOS VARCHAR2(16)
ALLOT VARCHAR2(20)
ALNXS VARCHAR2(16)
ALNXT VARCHAR2(20)
ALBCT NUMBER
ALBSZ NUMBER
ALDST NUMBER
ALNAM VARCHAR2(513)
ALFL2 NUMBER
ALTOA NUMBER
ALACD NUMBER
ALXLC NUMBER

Version 4

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
ALRID NUMBER
ALPRC NUMBER
ALTSM VARCHAR2(20)
ALSTM NUMBER
ALFLG NUMBER
ALTHP NUMBER
ALSEQ NUMBER
ALRLS VARCHAR2(16)
ALRLC VARCHAR2(20)
ALLOS VARCHAR2(16)
ALLOT VARCHAR2(20)
ALNXS VARCHAR2(16)
ALNXT VARCHAR2(20)
ALBCT NUMBER
ALBSZ NUMBER
ALDST NUMBER
ALNAM VARCHAR2(513)
ALFL2 NUMBER
ALTOA NUMBER
ALDLY NUMBER
ALACD NUMBER
ALXLC NUMBER

Indexes

Version 3

Version 3 of this fixed view has one index

Index Number Index Position Column Name
10ALRID

Version 4

Version 4 of this fixed view has one index

Index Number Index Position Column Name
10ALRID