Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Presentations

Diagnostics

Internals

Acknowledgements

Fixed View: X$K2GTE2

Versions

Oracle Version X$ Version
10.1.0.3.0 2
10.2.0.1.0 2
11.1.0.6.0 3

Columns

Version 2

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
K2GTIFMT NUMBER
K2GTITLN NUMBER
K2GTIBLN NUMBER
K2GTITID_ORA VARCHAR2(64)
K2GTITID_EXT RAW(64)
K2GTIBID RAW(64)
K2GTECNT NUMBER
K2GTDSES RAW(4)
K2GTDBRN RAW(4)
K2GTDXCB RAW(4)
K2GTERCT NUMBER
K2GTDPCT NUMBER
K2GTDFLG NUMBER
K2GTETYP NUMBER

Version 3

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
K2GTIFMT NUMBER
K2GTITLN NUMBER
K2GTIBLN NUMBER
K2GTITID_ORA VARCHAR2(64)
K2GTITID_EXT RAW(64)
K2GTIBID RAW(64)
K2GTECNT NUMBER
K2GTDSES RAW(4)
K2GTDBRN RAW(4)
K2GTDXCB RAW(4)
K2GTERCT NUMBER
K2GTDPCT NUMBER
K2GTDFLG NUMBER
K2GTETYP NUMBER
K2GTEILH RAW(4)
K2GTEID1 NUMBER
K2GTEGTX NUMBER
K2GTBILH RAW(4)
K2GTBID2 NUMBER
K2GTBGTX NUMBER

Indexes

Version 2

Version 2 of this fixed view does not have any indexes

Version 3

Version 3 of this fixed view does not have any indexes