cursor handle heap0 subheap

SELECT * FROM x$kglob t WHERE t.KGLHDNSP=0;--cursor

--3 B7F20884 4 1 804DF308 804DF3EC 4 select count(*) from snap$ s where bitand(s.flag, 8192) = 8192 and s.sowner not in ('SYS', 'SYSTEM', 'SH') 2247622696 a03d50151f420947b377a00e85f80028 2010-12-17 23:50:54 0 0 0 268501248 7F24A62C 2 0 1 0 0 1 0 1 1 0 0 3420 0 0 0 0 0 8136 0 7A4E9B90 00 00 00 00 00 77E7BA68 00 0 0 00 -32496 0 3 b6xx01u2zh018 1 1 1 7600 7600 2248 0 2236 524 1 0 10 1 1150 0 0 0 0 0 0 0 0 0 0 0 6 1643116674 0 0 1 0 0 0 0 0 0 0 0 26539 74 2253021012 5.36970970674674E18 1.61604921967402E19 165959219 0 0 4 SYS$BACKGROUND 2010-12-25 0:56:00 E289FB89A4E49800CE001000AEF9C3E2CFFA331056414655519521105555551545545558591555449665851D5511058555155515152552455580588055A1454A8E09508020000020000000000100001000000004002000017D000000806200000032001010000000033F19000030B3130000403100404A8E0950364046262040262320030020003020A000A5A000 2419788552 2010-12-25 0:56:00 0 1 SYS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
--4 B7F21890 5 1 804DF3EC 804DF3EC 4 select count(*) from snap$ s where bitand(s.flag, 8192) = 8192 and s.sowner not in ('SYS', 'SYSTEM', 'SH') 2247622696 a03d50151f420947b377a00e85f80028 2010-12-17 23:50:54 0 0 0 1342243024 77E7B73C 3 0 0 0 0 1 1 1 1 0 1 1539 0 0 0 0 0 0 0 858AC4A0 00 00 00 00 00 00 00 0 0 00 0 0 3 b6xx01u2zh018 0 0 0 0 0 0 65535 0 0 0 0 0 0 0 2147483644 2147483644 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26539 74 2253021012 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

--- 父cursor handle 804DF3EC handlepar 804DF3EC heap0 ---77E7B73C hd0--858AC4A0

-- handle 804DF3EC

--父cursor 所在chunck 类型
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('77E7B7%');--2CF1C7E0
--1 B7E9969C 268503 1 1 2 KGL handles 804DF3D0 540 recr 24 00
SELECT upper(to_char(to_number('804DF3D0','xxxxxxxxxxxxx')+540,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 804DF3EC --804DF5EC
SELECT to_number('804DF3EC','xxxxxxxxxxxxx')-to_number('804DF3D0','xxxxxxxxxxxxx') FROM dual;--在chunck的28位

--heap0 77E7B73C
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('77E7B73C%');--77E7B73C
--1 B785931C 99038 1 1 3 PCursor 77E7B708 1072 recr 4095 858AC4A0
SELECT upper(to_char(to_number('77E7B708','xxxxxxxxxxxxx')+1072,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 77E7B73C -- 77E7BB38
SELECT to_number('77E7B73C','xxxxxxxxxxxxx')-to_number('77E7B708','xxxxxxxxxxxxx') FROM dual;--在chunck的52位

--hd0 858AC4A0

SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('858AC4%');--858AC4A0
--2 B79421B0 186026 1 1 2 library cache 858AC494 96 freeabl 0 00
SELECT upper(to_char(to_number('858AC494','xxxxxxxxxxxxx')+96,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 858AC4A0 -- 858AC4F4
SELECT to_number('858AC4A0','xxxxxxxxxxxxx')-to_number('858AC494','xxxxxxxxxxxxx') FROM dual;--在chunck的12位

--subheap 内信息 hd0 858AC4A0
SELECT * FROM x$ksmhp t WHERE t.ksmchds=hextoraw('858AC4A0'); -- child sub
SELECT SUM(ksmchsiz)-1072*2 FROM x$ksmhp t WHERE t.ksmchds=hextoraw('2CF1C770'); -- child sub
/*
6 B7DC9634 5 1 858AC4A0 permanent memor 77E7A22C 612 perm 0 00 77E7B73C
5 B7DC966C 4 1 858AC4A0 free memory 77E7A490 348 free 0 00 77E7B73C
4 B7DC96A4 3 1 858AC4A0 kksfbc:hash1 77E7A5EC 16 freeabl 0 00 77E7B73C
3 B7DC96DC 2 1 858AC4A0 kgltbtab 77E7A5FC 76 freeabl 0 00 77E7B73C
2 B7DC9714 1 1 858AC4A0 permanent memor 77E7B72C 1016 perm 0 00 77E7B73C
1 B7DC974C 0 1 858AC4A0 free memory 77E7BB24 20 free 0 00 77E7B73C
*/

SELECT t.*,upper(to_char(to_number(t.ksmchptr,'xxxxxxxxxxxxx')+ksmchsiz,'xxxxxxxxxxxxxxxxxxxxx'))"endadr" FROM x$ksmsp t WHERE t.ksmchpar='858AC4A0';
--1 B7857534 99069 1 1 3 PCursor 77E7B708 1072 recr 4095 858AC4A0 77E7BB38
--2 B785741C 99074 1 1 3 PCursor 77E7A218 1072 freeabl 0 858AC4A0 77E7A648

-- 子cursor handle 804DF308 hdpar 804DF3EC heap 0 7F24A62C hd0 7A4E9B90 hd6 77E7BA68

---子handle 804DF308
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('804DF2EC%');--804DF308
--1 B7EB7684 268551 1 1 2 KGL handles 804DF2EC 228 recr 24 00
SELECT upper(to_char(to_number('804DF2EC','xxxxxxxxxxxxx')+228,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 804DF2EC -- 804DF3D0
SELECT to_number('804DF308','xxxxxxxxxxxxx')-to_number('804DF2EC','xxxxxxxxxxxxx') FROM dual;--在chunck的28位

---heap0 7F24A62C
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('7F24A5F8%');--7F24A62C
--1 B710D104 85334 1 1 3 CCursor 7F24A5F8 1072 recr 4095 7A4E9B90
SELECT upper(to_char(to_number('7F24A5F8','xxxxxxxxxxxxx')+1072,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 7F24A5F8 -- 7F24AA28
SELECT to_number('7F24A62C','xxxxxxxxxxxxx')-to_number('7F24A5F8','xxxxxxxxxxxxx') FROM dual;--在chunck的52位

--hd0 7A4E9B90
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('7A4E9B%');--7A4E9B90
--2 B7D52488 236879 1 1 2 library cache 7A4E9B84 96 freeabl 0 00
SELECT upper(to_char(to_number('7A4E9B84','xxxxxxxxxxxxx')+96,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 2CF1C7C4 --2CF1C9E0
SELECT to_number('7A4E9B90','xxxxxxxxxxxxx')-to_number('7A4E9B84','xxxxxxxxxxxxx') FROM dual;--在chunck的12位

--subheap 内信息 hd0 7A4E9B90
SELECT * FROM x$ksmhp t WHERE t.ksmchds=hextoraw('7A4E9B90'); -- child sub
/*
7 B7DC5F38 6 1 7A4E9B90 permanent memor 7F249DAC 1052 perm 0 00 7F24A62C
6 B7DC5F70 5 1 7A4E9B90 permanent memor 7F24A1DC 824 perm 0 00 7F24A62C
5 B7DC5FA8 4 1 7A4E9B90 kgltbtab 7F24A514 76 freeabl 0 00 7F24A62C
4 B7DC5FE0 3 1 7A4E9B90 kgltbtab 7F24A560 76 freeabl 0 00 7F24A62C
3 B7DC6018 2 1 7A4E9B90 kgltbtab 7F24A5AC 76 freeabl 0 00 7F24A62C
2 B7DC6050 1 1 7A4E9B90 permanent memor 7F24A61C 700 perm 0 00 7F24A62C
1 B7DC6088 0 1 7A4E9B90 free memory 7F24A8D8 336 free 0 00 7F24A62C
*/
SELECT t.*,upper(to_char(to_number(t.ksmchptr,'xxxxxxxxxxxxx')+ksmchsiz,'xxxxxxxxxxxxxxxxxxxxx'))"endadr" FROM x$ksmsp t WHERE t.ksmchpar='7A4E9B90';
----1 B710C0F8 85334 1 1 3 CCursor 7F24A5F8 1072 recr 4095 7A4E9B90 7F24AA28
--2 B710C0C0 85335 1 1 3 CCursor 7F24A1C8 1072 freeabl 0 7A4E9B90 7F24A5F8
--3 B710C088 85336 1 1 3 CCursor 7F249D98 1072 freeabl 0 7A4E9B90 7F24A1C8

--hd6 77E7BA68
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('77E7B%');--77E7BA68
--2 B7858540 99069 1 1 3 PCursor 77E7B708 1072 recr 4095 858AC4A0
SELECT upper(to_char(to_number('77E7B708','xxxxxxxxxxxxx')+1072,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 77E7B708 -- 77E7BB38
SELECT to_number('77E7BA68','xxxxxxxxxxxxx')-to_number('77E7B708','xxxxxxxxxxxxx') FROM dual;--在chunck的860位

--subheap 内信息 77E7BA68
SELECT * FROM x$ksmhp t WHERE t.ksmchds=hextoraw('77E7BA68'); -- child sub
/*
75 B7DC5F38 74 1 77E7BA68 free memory 69897EE8 2360 free 0 00 77E7B9D8
74 B7DC5F70 73 1 77E7BA68 kggsmInitCompac 69898820 32 freeabl 0 00 77E7B9D8
73 B7DC5FA8 72 1 77E7BA68 kggsmInitCompac 69898840 20 freeabl 0 00 77E7B9D8
72 B7DC5FE0 71 1 77E7BA68 kggsmInitCompac 69898854 16 freeabl 0 00 77E7B9D8
71 B7DC6018 70 1 77E7BA68 kggsmInitCompac 69898864 20 freeabl 0 00 77E7B9D8
70 B7DC6050 69 1 77E7BA68 kggsmInitCompac 69898878 16 freeabl 0 00 77E7B9D8
69 B7DC6088 68 1 77E7BA68 kggsmCommonInit 69898888 92 freeabl 0 00 77E7B9D8
68 B7DC60C0 67 1 77E7BA68 kggsmInit:sm 698988E4 48 freeabl 0 00 77E7B9D8
67 B7DC60F8 66 1 77E7BA68 idndef : qcuAll 69898914 28 freeabl 0 00 77E7B9D8
66 B7DC6130 65 1 77E7BA68 qeSel: qkxrXfor 69898930 24 freeabl 0 00 77E7B9D8
65 B7DC6168 64 1 77E7BA68 kggac: kggacCre 69898948 24 freeabl 0 00 77E7B9D8
64 B7DC61A0 63 1 77E7BA68 kksoff : opitca 69898960 20 freeabl 0 00 77E7B9D8
63 B7DC61D8 62 1 77E7BA68 opiprwd : opitc 69898974 40 freeabl 0 00 77E7B9D8
62 B7DC6210 61 1 77E7BA68 KGHSC_ALLOC_BUF 6989899C 80 freeabl 0 00 77E7B9D8
61 B7DC6248 60 1 77E7BA68 qeeRwo: qeeCrea 698989EC 20 freeabl 0 00 77E7B9D8
60 B7DC6280 59 1 77E7BA68 qeeOpt: qeesCre 69898A00 80 freeabl 0 00 77E7B9D8
59 B7DC62B8 58 1 77E7BA68 qeeRwo: qeeCrea 69898A50 20 freeabl 0 00 77E7B9D8
58 B7DC62F0 57 1 77E7BA68 qergss:qergsAll 69898A64 104 freeabl 0 00 77E7B9D8
57 B7DC6328 56 1 77E7BA68 ub1[]: qkexrXfo 69898ACC 16 freeabl 0 00 77E7B9D8
56 B7DC6360 55 1 77E7BA68 opn: qkexrInitO 69898ADC 60 freeabl 0 00 77E7B9D8
55 B7DC6398 54 1 77E7BA68 qeeOpt: qeesCre 69898B18 84 freeabl 0 00 77E7B9D8
54 B7DC63D0 53 1 77E7BA68 ub1[]: qkexrXfo 69898B6C 20 freeabl 0 00 77E7B9D8
53 B7DC6408 52 1 77E7BA68 opn: qkexrInitO 69898B80 60 freeabl 0 00 77E7B9D8
52 B7DC6440 51 1 77E7BA68 qeeOpt: qeesCre 69898BBC 84 freeabl 0 00 77E7B9D8
51 B7DC6478 50 1 77E7BA68 ub1[]: qkexrXfo 69898C10 16 freeabl 0 00 77E7B9D8
50 B7DC64B0 49 1 77E7BA68 opn: qkexrInitO 69898C20 60 freeabl 0 00 77E7B9D8
49 B7DC64E8 48 1 77E7BA68 idndef : qcuAll 69898C5C 28 freeabl 0 00 77E7B9D8
48 B7DC6520 47 1 77E7BA68 idndef : qcuAll 69898C78 24 freeabl 0 00 77E7B9D8
47 B7DC6558 46 1 77E7BA68 idndef*[]: qkex 69898C90 28 freeabl 0 00 77E7B9D8
46 B7DC6590 45 1 77E7BA68 opn: qkexrInitO 69898CAC 72 freeabl 0 00 77E7B9D8
45 B7DC65C8 44 1 77E7BA68 qeeOpt: qeesCre 69898CF4 84 freeabl 0 00 77E7B9D8
44 B7DC6600 43 1 77E7BA68 ub1[]: qkexrXfo 69898D48 16 freeabl 0 00 77E7B9D8
43 B7DC6638 42 1 77E7BA68 opn: qkexrInitO 69898D58 60 freeabl 0 00 77E7B9D8
42 B7DC6670 41 1 77E7BA68 ub1[]: qkexrXfo 69898D94 16 freeabl 0 00 77E7B9D8
41 B7DC66A8 40 1 77E7BA68 opn: qkexrInitO 69898DA4 60 freeabl 0 00 77E7B9D8
40 B7DC66E0 39 1 77E7BA68 idndef : qcuAll 69898DE0 24 freeabl 0 00 77E7B9D8
39 B7DC6718 38 1 77E7BA68 idndef : qcuAll 69898DF8 24 freeabl 0 00 77E7B9D8
38 B7DC6750 37 1 77E7BA68 idndef*[]: qkex 69898E10 28 freeabl 0 00 77E7B9D8
37 B7DC6788 36 1 77E7BA68 qeeOpt: qeesCre 69898E2C 84 freeabl 0 00 77E7B9D8
36 B7DC67C0 35 1 77E7BA68 qeeOpt: qeesCre 69898E80 84 freeabl 0 00 77E7B9D8
35 B7DC67F8 34 1 77E7BA68 opn: qkexrInitO 69898EF8 72 freeabl 0 00 77E7B9D8
34 B7DC6830 33 1 77E7BA68 qeeOpt: qeesCre 69898F40 92 freeabl 0 00 77E7B9D8
33 B7DC6868 32 1 77E7BA68 qeeRwo: qeeCrea 69898F9C 20 freeabl 0 00 77E7B9D8
32 B7DC68A0 31 1 77E7BA68 qertbs:qertbIAl 69898FB0 212 freeabl 0 00 77E7B9D8
31 B7DC68D8 30 1 77E7BA68 qksmm: qksmmCs 69899084 44 freeabl 0 00 77E7B9D8
30 B7DC6910 29 1 77E7BA68 qkaReorderAggs. 698990B0 20 freeabl 0 00 77E7B9D8
29 B7DC6948 28 1 77E7BA68 qertbAllocatePa 698990C4 60 freeabl 0 00 77E7B9D8
28 B7DC6980 27 1 77E7BA68 qkaapd : qkaqkn 69899100 48 freeabl 0 00 77E7B9D8
27 B7DC69B8 26 1 77E7BA68 kccdef: qkxrMem 69899130 116 freeabl 0 00 77E7B9D8
26 B7DC69F0 25 1 77E7BA68 kccdef: qkxrMem 698991A4 116 freeabl 0 00 77E7B9D8
25 B7DC6A28 24 1 77E7BA68 kksol : kksnsg 69899218 40 freeabl 0 00 77E7B9D8
24 B7DC6A60 23 1 77E7BA68 kafco : qkacol 69899240 68 freeabl 0 00 77E7B9D8
23 B7DC6A98 22 1 77E7BA68 execution fro i 69899284 16 freeabl 0 00 77E7B9D8
22 B7DC6AD0 21 1 77E7BA68 chedef : qcuatc 69899294 20 freeabl 0 00 77E7B9D8
21 B7DC6B08 20 1 77E7BA68 kobjn : kkdcchs 698992A8 16 freeabl 0 00 77E7B9D8
20 B7DC6B40 19 1 77E7BA68 cxach : opiSem 698992B8 32 freeabl 0 00 77E7B9D8
19 B7DC6B78 18 1 77E7BA68 ktamd : ktagmd 698992D8 28 freeabl 0 00 77E7B9D8
18 B7DC6BB0 17 1 77E7BA68 ckydef : kkdlck 698992F4 468 freeabl 0 00 77E7B9D8
17 B7DC6BE8 16 1 77E7BA68 ckydef : kkdlck 698994C8 468 freeabl 0 00 77E7B9D8
16 B7DC6C20 15 1 77E7BA68 ckydef : kkdlck 6989969C 468 freeabl 0 00 77E7B9D8
15 B7DC6C58 14 1 77E7BA68 ckydef : kkdlck 69899870 468 freeabl 0 00 77E7B9D8
14 B7DC6C90 13 1 77E7BA68 kksil : kkscmi 69899A44 32 freeabl 0 00 77E7B9D8
13 B7DC6CC8 12 1 77E7BA68 kksol : kksnsg 69899A64 40 freeabl 0 00 77E7B9D8
12 B7DC6D00 11 1 77E7BA68 idndef : qcuAll 69899A8C 24 freeabl 0 00 77E7B9D8
11 B7DC6D38 10 1 77E7BA68 kctdef : qcdlgo 69899AA4 288 freeabl 0 00 77E7B9D8
10 B7DC6D70 9 1 77E7BA68 unmdef in opipr 69899BC4 48 freeabl 0 00 77E7B9D8
9 B7DC6DA8 8 1 77E7BA68 qctctx: kkmqccr 69899BF4 24 freeabl 0 00 77E7B9D8
8 B7DC6DE0 7 1 77E7BA68 qcsctx: kkmqccr 69899C0C 32 freeabl 0 00 77E7B9D8
7 B7DC6E18 6 1 77E7BA68 qcptgc: kkmqccr 69899C2C 20 freeabl 0 00 77E7B9D8
6 B7DC6E50 5 1 77E7BA68 qcpctx: kkmqccr 69899C40 40 freeabl 0 00 77E7B9D8
5 B7DC6E88 4 1 77E7BA68 qcmemctx : kkmq 69899C68 28 freeabl 0 00 77E7B9D8
4 B7DC6EC0 3 1 77E7BA68 qcctx : kkmqccr 69899C84 80 freeabl 0 00 77E7B9D8
3 B7F23894 2 1 77E7BA68 kksol : kkscuf 69899CD4 40 freeabl 0 00 77E7B9D8
2 B7F238CC 1 1 77E7BA68 kksol : kkscuf 69899CFC 40 freeabl 0 00 77E7B9D8
1 B7F23904 0 1 77E7BA68 ctxdef: kksLoad 69899D24 432 freeabl 0 00 77E7B9D8
*/
SELECT t.*,upper(to_char(to_number(t.ksmchptr,'xxxxxxxxxxxxx')+ksmchsiz,'xxxxxxxxxxxxxxxxxxxxx'))"endadr" FROM x$ksmsp t WHERE t.ksmchpar='77E7BA68';
--1 B737EA08 43317 1 1 4 sql area 69898ED4 4096 recr 4095 77E7BA68 69899ED4
--2 B737E9D0 43318 1 1 4 sql area 69897ED4 4096 freeabl 0 77E7BA68 69898ED4

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25093763/viewspace-1043856/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25093763/viewspace-1043856/