Oracle Internals

JulianDyke.com

Acknowledgements

Fixed View: X$DUAL

Versions

Oracle Version	X$ Version
10.1.0.3.0	2
10.2.0.1.0	2
11.1.0.6.0	2

Columns

Version 2

Column Name	Data Type
ADDR	RAW(4)
INDX	NUMBER
INST_ID	NUMBER
DUMMY	VARCHAR2(1)

Indexes

Version 2

Version 2 of this fixed view has 2 indexes

Index Number	Index Position	Column Name
1	0	ADDR
2	0	INDX