Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Fixed View: X$KFFXP

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
GROUP_KFFXP NUMBER
NUMBER_KFFXP NUMBER
COMPOUND_KFFXP NUMBER
INCARN_KFFXP NUMBER
PXN_KFFXP NUMBER
XNUM_KFFXP NUMBER
LXN_KFFXP NUMBER
DISK_KFFXP NUMBER
AU_KFFXP NUMBER
FLAGS_KFFXP NUMBER
CHK_KFFXP NUMBER

Version 2

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
GROUP_KFFXP NUMBER
NUMBER_KFFXP NUMBER
COMPOUND_KFFXP NUMBER
INCARN_KFFXP NUMBER
PXN_KFFXP NUMBER
XNUM_KFFXP NUMBER
LXN_KFFXP NUMBER
DISK_KFFXP NUMBER
AU_KFFXP NUMBER
FLAGS_KFFXP NUMBER
CHK_KFFXP NUMBER
SIZE_KFFXP NUMBER

Indexes

Version 1

Version 1 of this fixed view has 3 indexes

Index Number Index Position Column Name
10GROUP_KFFXP
20NUMBER_KFFXP
30COMPOUND_KFFXP

Version 2

Version 2 of this fixed view has 3 indexes

Index Number Index Position Column Name
10GROUP_KFFXP
20NUMBER_KFFXP
30COMPOUND_KFFXP