X$ tables: reading X$KQFCO from Oracle binary¶
Let us find out how to get X$ table columns from the Oracle binary.
Column definition structures are stored in kqftap:
[oracle@db-21 ~]$ xinfo list 'X$KCCCP' -o json --with-kqftap
{
"457": {
"obj": 4294951392,
"ver": 5,
"nam_ptr": 383999376,
"nam": "X$KCCCP",
"xstruct_nam_ptr": 383999384,
"xstruct": "kctcpx",
"typ": 5,
"flg": 0,
"rsz": 552,
"coc": 25,
"kqftap": {
"xstruct_ptr": 382889376,
"cb2_ptr": 75535856,
"xstruct": "kctcpx_c",
"cb2": "kctxcp"
}
}
}
For example, the structure kctcpx_c defines X$KCCCP's columns:
[oracle@db-21 bin]$ readelf -s oracle | grep -E -A1 -w 'Symbol|kctcpx_c' --no-group-separator
Symbol table '.dynsym' contains 225083 entries:
Num: Value Size Type Bind Vis Ndx Name
Symbol table '.symtab' contains 402534 entries:
Num: Value Size Type Bind Vis Ndx Name
80301: 0000000016d77100 1664 OBJECT LOCAL DEFAULT 17 kctcpx_c
80302: 0000000016d77780 2304 OBJECT LOCAL DEFAULT 17 kctmtx_c
Here is what it looks like:
[oracle@db-21 bin]$ objdump -s --start-address=0x0000000016d77100 --stop-address=$((0x0000000016d77100+1664)) oracle
oracle: file format elf64-x86-64
Contents of section .rodata:
16d77100 04000000 00000000 9c95e616 00000000 ................
16d77110 17090000 00000000 00000000 00000000 ................
16d77120 00000000 00000000 08000000 00000000 ................
16d77130 00000000 00000000 00000000 00000000 ................
16d77140 04000000 00000000 60d6d715 00000000 ........`.......
16d77150 020b0000 00000000 00000000 00000000 ................
16d77160 00000000 00000000 04000000 00000000 ................
16d77170 00000000 00000000 00000000 00000000 ................
16d77180 07000000 00000000 b0960f16 00000000 ................
16d77190 020b0000 00000000 00000000 00000000 ................
16d771a0 00000000 00000000 04000000 00000000 ................
16d771b0 00000000 00000000 00000000 00000000 ................
16d771c0 06000000 00000000 5c8de716 00000000 ........\.......
16d771d0 020b0000 00000000 00000000 00000000 ................
16d771e0 00000000 00000000 02000000 00000000 ................
16d771f0 00000000 00000000 00000000 00000000 ................
16d77200 05000000 00000000 6c82e916 00000000 ........l.......
16d77210 02000100 00000000 00000000 00000000 ................
16d77220 00000000 00000000 04000000 00000000 ................
16d77230 0c020000 00000000 00000000 00000000 ................
Each column is defined within 64 bytes:
[oracle@db-21 bin]$ for a in 16e6959c 15d7d660 160f96b0 16e78d5c 16e9826c
> do
> objdump -s --start-address=0x$a --stop-address=$((0x$a+16)) oracle
> done
oracle: file format elf64-x86-64
Contents of section .rodata:
16e6959c 41444452 00000000 6b71665f 66696c6c ADDR....kqf_fill
oracle: file format elf64-x86-64
Contents of section .rodata:
15d7d660 494e4458 00000000 49535355 45440000 INDX....ISSUED..
oracle: file format elf64-x86-64
Contents of section .rodata:
160f96b0 494e5354 5f494400 71656573 46696e64 INST_ID.qeesFind
oracle: file format elf64-x86-64
Contents of section .rodata:
16e78d5c 434f4e5f 49440000 5352435f 434f4e5f CON_ID..SRC_CON_
oracle: file format elf64-x86-64
Contents of section .rodata:
16e9826c 4350544e 4f000000 43505354 41000000 CPTNO...CPSTA...
Here is the structure of X$KCCCP:
SQL> desc x$kcccp
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(8)
INDX NUMBER
INST_ID NUMBER
CON_ID NUMBER
CPTNO NUMBER
CPSTA NUMBER
CPFLG NUMBER
CPDRT NUMBER
CPRDB NUMBER
CPLRBA_SEQ NUMBER
CPLRBA_BNO NUMBER
CPLRBA_BOF NUMBER
CPODR_SEQ NUMBER
CPODR_BNO NUMBER
CPODR_BOF NUMBER
CPODS VARCHAR2(20)
CPODT VARCHAR2(20)
CPODT_I NUMBER
CPHBT NUMBER
CPRLS VARCHAR2(20)
CPRLC NUMBER
CPMID NUMBER
CPSDR_SEQ NUMBER
CPSDR_BNO NUMBER
CPSDR_ADB NUMBER
And the actual X$KQFCO rows:
SQL> select kqfcocno,
2 kqfconam,
3 kqfcosiz,
4 kqfcodty,
5 kqfcotyp,
6 kqfcomax,
7 kqfcolsz,
8 kqfcolof,
9 kqfcooff,
10 kqfcoidx,
11 kqfcoipo
12 from x$kqfta t,
13 x$kqfco c
14 where t.kqftanam = 'X$KCCCP'
15 and c.kqfcotab = t.indx
16 order by 1;
KQFCOCNO KQFCONAM KQFCOSIZ KQFCODTY KQFCOTYP KQFCOMAX KQFCOLSZ KQFCOLOF KQFCOOFF KQFCOIDX KQFCOIPO
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
1 ADDR 8 23 9 0 0 0 0 0 0
2 INDX 4 2 11 0 0 0 0 0 0
3 INST_ID 4 2 11 0 0 0 0 0 0
4 CON_ID 2 2 11 0 0 0 0 0 0
5 CPTNO 4 2 0 0 0 0 524 1 0
6 CPSTA 4 2 11 0 0 0 0 0 0
7 CPFLG 4 2 11 0 0 0 4 0 0
8 CPDRT 4 2 11 0 0 0 8 0 0
9 CPRDB 4 2 11 0 0 0 548 0 0
10 CPLRBA_SEQ 4 2 11 0 0 0 12 0 0
11 CPLRBA_BNO 4 2 11 0 0 0 16 0 0
12 CPLRBA_BOF 2 2 11 0 0 0 20 0 0
13 CPODR_SEQ 4 2 11 0 0 0 24 0 0
14 CPODR_BNO 4 2 11 0 0 0 28 0 0
15 CPODR_BOF 2 2 11 0 0 0 32 0 0
16 CPODS 20 1 5 0 0 0 484 0 0
17 CPODT 20 1 5 0 0 0 504 0 0
18 CPODT_I 4 2 11 0 0 0 44 0 0
19 CPHBT 4 2 11 0 0 0 60 0 0
20 CPRLS 20 1 5 0 0 0 528 0 0
21 CPRLC 4 2 11 0 0 0 48 0 0
22 CPMID 4 2 11 0 0 0 64 0 0
23 CPSDR_SEQ 4 2 11 0 0 0 104 0 0
24 CPSDR_BNO 4 2 11 0 0 0 108 0 0
25 CPSDR_ADB 2 2 11 0 0 0 112 0 0
25 rows selected.
The xinfo tool has a describe command that produces the same data:
[oracle@db-21 ~]$ xinfo desc 'X$KCCCP'
+-----+------------+------------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-------------+
| cno | nam_ptr | nam | siz | dty | typ | max | lsz | lof | off | idx | ipo | kqfcop_indx |
+-----+------------+------------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-------------+
| 1 | 0x16e6959c | ADDR | 8 | 23 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | 0x15d7d660 | INDX | 4 | 2 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | 0x160f96b0 | INST_ID | 4 | 2 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4 | 0x16e78d5c | CON_ID | 2 | 2 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 5 | 0x16e9826c | CPTNO | 4 | 2 | 0 | 0 | 0 | 0 | 524 | 1 | 0 | 0 |
| 6 | 0x16e98274 | CPSTA | 4 | 2 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7 | 0x16e9827c | CPFLG | 4 | 2 | 11 | 0 | 0 | 0 | 4 | 0 | 0 | 0 |
| 8 | 0x16e98284 | CPDRT | 4 | 2 | 11 | 0 | 0 | 0 | 8 | 0 | 0 | 0 |
| 9 | 0x16e9828c | CPRDB | 4 | 2 | 11 | 0 | 0 | 0 | 548 | 0 | 0 | 0 |
| 10 | 0x16e98294 | CPLRBA_SEQ | 4 | 2 | 11 | 0 | 0 | 0 | 12 | 0 | 0 | 0 |
| 11 | 0x16e982a0 | CPLRBA_BNO | 4 | 2 | 11 | 0 | 0 | 0 | 16 | 0 | 0 | 0 |
| 12 | 0x16e982ac | CPLRBA_BOF | 2 | 2 | 11 | 0 | 0 | 0 | 20 | 0 | 0 | 0 |
| 13 | 0x16e982b8 | CPODR_SEQ | 4 | 2 | 11 | 0 | 0 | 0 | 24 | 0 | 0 | 0 |
| 14 | 0x16e982c4 | CPODR_BNO | 4 | 2 | 11 | 0 | 0 | 0 | 28 | 0 | 0 | 0 |
| 15 | 0x16e982d0 | CPODR_BOF | 2 | 2 | 11 | 0 | 0 | 0 | 32 | 0 | 0 | 0 |
| 16 | 0x16e982dc | CPODS | 20 | 1 | 5 | 0 | 0 | 0 | 484 | 0 | 0 | 0 |
| 17 | 0x16e982e4 | CPODT | 20 | 1 | 5 | 0 | 0 | 0 | 504 | 0 | 0 | 0 |
| 18 | 0x16e982ec | CPODT_I | 4 | 2 | 11 | 0 | 0 | 0 | 44 | 0 | 0 | 0 |
| 19 | 0x16e982f4 | CPHBT | 4 | 2 | 11 | 0 | 0 | 0 | 60 | 0 | 0 | 0 |
| 20 | 0x16e982fc | CPRLS | 20 | 1 | 5 | 0 | 0 | 0 | 528 | 0 | 0 | 0 |
| 21 | 0x16e98304 | CPRLC | 4 | 2 | 11 | 0 | 0 | 0 | 48 | 0 | 0 | 0 |
| 22 | 0x16e9830c | CPMID | 4 | 2 | 11 | 0 | 0 | 0 | 64 | 0 | 0 | 0 |
| 23 | 0x16e98314 | CPSDR_SEQ | 4 | 2 | 11 | 0 | 0 | 0 | 104 | 0 | 0 | 0 |
| 24 | 0x16e98320 | CPSDR_BNO | 4 | 2 | 11 | 0 | 0 | 0 | 108 | 0 | 0 | 0 |
| 25 | 0x16e9832c | CPSDR_ADB | 2 | 2 | 11 | 0 | 0 | 0 | 112 | 0 | 0 | 0 |
+-----+------------+------------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-------------+