如何定位SQL语句在共享池里用到了哪些chunks(3)

---通过指向子游标handle地址的指针07000001B84F85E8能够关联出子游标heap 0的描述符地址
col KGLNAOBJ format a80
set linesize 190 pagesize 20
select kglhdadr,kglnaobj,kglobhd0 from x$kglob where kglhdadr='07000001B84F85E8';
KGLHDADR        KGLNAOBJ                                                                        KGLOBHD0
---------------- -------------------------------------------------------------------------------- ----------------
07000001B84F85E8 select * from scott.t1 where username='SYS'                                      07000001B84F8530  <---子游标heap 0的描述符(Descriptor)所在chunk起始地址

***在tstdb1_ora_15270042_level2050dmp.txt文件中可以找到包含07000001B84F8530和07000001B84F85E8地址所在的段落:
  Chunk  7000001b84f84c8 sz=      240    freeable  "KGLDA          "        <---子游标heap 0描述符的地址所在chunk起始地址
Dump of memory from 0x07000001B84F84C8 to 0x07000001B84F85B8
7000001B84F84C0                  00B38F00 000000F1          [........]
7000001B84F84D0 07000001 B84F83D8 00000001 09B01958  [.....O.........X]
7000001B84F84E0 07000001 B84F8530 07000001 95D400B0  [.....O.0........]
7000001B84F84F0 00000000 01000300 07000001 A885E598  [................]
7000001B84F8500 00000FE8 00000A60 07000001 95D40010  [.......`........]
7000001B84F8510 07000001 95D3FF90 00000000 00000000  [................]
7000001B84F8520 00000003 0C1F2D58 07000001 B54C6120  [......-X.....La ]
7000001B84F8530 07000000 00000198 00000FE8 00000000  [................]
7000001B84F8540 07000001 B84F84E0 07000001 95D3FF90  [.....O..........]
7000001B84F8550 07000001 95D3FFF0 00000000 00000000  [................]
7000001B84F8560 00000000 00000000 09020100 00000000  [................]
7000001B84F8570 00000000 00000000 00000FD0 4B474C48  [............KGLH]
7000001B84F8580 305E6636 34333962 31300026 7FFF0038  [0^f6439b10.&...8]
7000001B84F8590 00307FFF 00000000 01030000 00000000  [.0..............]
7000001B84F85A0 00000000 00000000 07000001 95D3FFD0  [................]
7000001B84F85B0 07000001 95D40A10                    [........]
  Chunk  7000001b84f85b8 sz=      352    recreate  "KGLHD          "  latch=0  <---指向子游标handle地址的指针,它和上面的描述符恰巧在相邻的两个chunk内
Dump of memory from 0x07000001B84F85B8 to 0x07000001B84F8718
7000001B84F85B0                  80B38F00 00000161          [.......a]
7000001B84F85C0 07000001 B84F84C8 00000000 00000000  [.....O..........]
7000001B84F85D0 00000000 00000000 00000000 00000000  [................]
7000001B84F85E0 00000000 00500800 07000001 B84F85E8  [.....P.......O..]
7000001B84F85F0 07000001 B84F85E8 07000001 95D40010  [.....O..........]
7000001B84F8600 00000000 00000000 00000000 10012111  [..............!.]
7000001B84F8610 00010000 00010000 00010001 00000001  [................]
7000001B84F8620 00000000 00000001 00000100 00000000  [................]
7000001B84F8630 00000000 00000000 00000000 00000000  [................]
7000001B84F8640 00000000 00000000 07000001 B84F8648  [.............O.H]
7000001B84F8650 07000001 B84F8648 07000001 B84F8658  [.....O.H.....O.X]
7000001B84F8660 07000001 B84F8658 07000001 B84F8668  [.....O.X.....O.h]
7000001B84F8670 07000001 B84F8668 07000001 B84F8678  [.....O.h.....O.x]
7000001B84F8680 07000001 B84F8678 07000001 95D41918  [.....O.x........]
7000001B84F8690 07000001 95D41918 00000000 00000000  [................]
7000001B84F86A0 00000000 00000000 00000000 00000000  [................]
7000001B84F86B0 00000000 00000000 07000001 B8670550  [.............g.P]
7000001B84F86C0 07000001 B84F86C0 07000001 B84F86C0  [.....O.......O..]
7000001B84F86D0 07000001 B84F86D0 07000001 B84F86D0  [.....O.......O..]
7000001B84F86E0 00000000 00000000 07000001 B0EA1A60  [...............`]
7000001B84F86F0 00000000 00000000 00000000 00000000  [................]
7000001B84F8700 00000001 00000002 00000000 00000000  [................]
7000001B84F8710 00000000 00000000                    [........]

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/08fb1730e9b4f49b36f7ab5ea92d70fd.html