CHAPTER 81. ORACLE RDBMS CHAPTER 81. ORACLE RDBMS
SQL> select * from x$version;
ADDR INDX INST_ID
BANNER
0DBAF574 0 1
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
...
This table has some additional fields, likeADDRandINDX.
While scrollingkqf.oinIDAwe can spot another table that contains a pointer to theX$VERSIONstring, this iskqftab:
Listing 81.6: kqf.o
.rodata:0803CAC0 dd 9 ; element number 0x1f6
.rodata:0803CAC4 dd offset _2STRING_13113_0 ; "X$VERSION"
.rodata:0803CAC8 dd 4
.rodata:0803CACC dd offset _2__STRING_13114_0 ; "kqvt"
.rodata:0803CAD0 dd 4
.rodata:0803CAD4 dd 4
.rodata:0803CAD8 dd 0
.rodata:0803CADC dd 4
.rodata:0803CAE0 dd 0Ch
.rodata:0803CAE4 dd 0FFFFC075h
.rodata:0803CAE8 dd 3
.rodata:0803CAEC dd 0
.rodata:0803CAF0 dd 7
.rodata:0803CAF4 dd offset _2STRING_13115_0 ; "X$KQFSZ"
.rodata:0803CAF8 dd 5
.rodata:0803CAFC dd offset _2__STRING_13116_0 ; "kqfsz"
.rodata:0803CB00 dd 1
.rodata:0803CB04 dd 38h
.rodata:0803CB08 dd 0
.rodata:0803CB0C dd 7
.rodata:0803CB10 dd 0
.rodata:0803CB14 dd 0FFFFC09Dh
.rodata:0803CB18 dd 2
.rodata:0803CB1C dd 0
There are a lot of references to the X$-table names, apparently, to all Oracle RDBMS 11.2 X$-tables. But again, we don’t
have enough information. It’s not clear what does thekqvtstring stands for. Thekqprefix may meankernelorquery. v
apparently stands forversionandt—type? Hard to say.
A table with a similar name can be found inkqf.o:
Listing 81.7: kqf.o
.rodata:0808C360 kqvt_c_0 kqftap_param <4, offset _2STRING_19_0, 917h, 0, 0, 0, 4, 0,⤦
Ç0>
.rodata:0808C360 ; DATA XREF: .rodata:08042680
.rodata:0808C360 ; "ADDR"
.rodata:0808C384 kqftap_param <4, offset _2STRING_20_0, 0B02h, 0, 0, 0, 4, 0,⤦
Ç 0> ; "INDX"
.rodata:0808C3A8 kqftap_param <7, offset _2__STRING_21_0, 0B02h, 0, 0, 0, 4, 0,⤦
Ç 0> ; "INST_ID"
.rodata:0808C3CC kqftap_param <6, offset _2STRING_5017_0, 601h, 0, 0, 0, 50h,⤦
Ç 0, 0> ; "BANNER"
.rodata:0808C3F0 kqftap_param <0, offset _2STRING_0_0, 0, 0, 0, 0, 0, 0, 0>
It contains information about all fields in theX$VERSIONtable. The only reference to this table is in thekqftaptable:
Listing 81.8: kqf.o
.rodata:08042680 kqftap_element <0, offset kqvt_c_0, offset kqvrow, 0> ;⤦
Çelement 0x1f6