Oracle Internals

JulianDyke.com

Acknowledgements

Fixed View: X$GLOBALCONTEXT

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
NAMESPACE	VARCHAR2(31)
ATTRIBUTE	VARCHAR2(31)
VALUE	VARCHAR2(4000)
USERNAME	VARCHAR2(31)
CLIENTIDENTIFIER	VARCHAR2(65)

Indexes

Version 2

Version 2 of this fixed view does not have any indexes