Oracle Internals

JulianDyke.com

Acknowledgements

Fixed View: X$HOFP

Versions

Oracle Version	X$ Version
10.1.0.3.0	1
10.2.0.1.0	1
11.1.0.6.0	1

Columns

Version 1

Column Name	Data Type
ADDR	RAW(4)
INDX	NUMBER
INST_ID	NUMBER
FDS_INST_ID	NUMBER
PARAMETER	VARCHAR2(30)
VALUE	VARCHAR2(64)
SOURCE	VARCHAR2(1)
ENV	VARCHAR2(1)

Indexes

Version 1

Version 1 of this fixed view does not have any indexes