table/procedure handle heap0 subheap

SELECT * FROM x$kglob t WHERE t.KGLHDNSP=1 AND t.kglhdadr='80BB2574';--table/procedure t.kglhdadr = t.kglhdpar
g_noap.CLT_CM_HWV3R8_BTSPWRC

--1 B7F70694 1 1 80BB2574 80BB2574 5 G_NOAP CLT_CM_HWV3R8_BTSPWRC 1758986246 3325057b884121249d976d5468d80006 2010-10-28 14:23:16 1 0 0 33554432 74358D70 4 0 0 0 0 1857 0 5 1 2 0 1436 0 0 0 0 0 18696 0 7AFA99FC 00 00 00 00 00 74359048 00 0 0 00 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 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

--- 父cursor handle 80BB2574 handlepar 80BB2574 heap0 ---74358D70 hd0--7AFA99FC hd6-74359048

-- handle 80BB2574

--父cursor 所在chunck 类型
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('80BB25%');--80BB2574
--1 B7E7BDE8 256764 1 1 2 KGL handles 80BB2558 344 recr 24 00
SELECT upper(to_char(to_number('80BB2558','xxxxxxxxxxxxx')+344,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 80BB2558 -- 80BB26B0
SELECT to_number('80BB2574','xxxxxxxxxxxxx')-to_number('80BB2558','xxxxxxxxxxxxx') FROM dual;--在chunck的28位

--heap0 74358D70
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('74358D%');--74358D70
--1 B775C09C 121061 1 1 3 CCursor 74358D3C 1072 recr 4095 7AFA99FC
SELECT upper(to_char(to_number('74358D3C','xxxxxxxxxxxxx')+1072,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 74358D3C -- 7435916C
SELECT to_number('74358D70','xxxxxxxxxxxxx')-to_number('74358D3C','xxxxxxxxxxxxx') FROM dual;--在chunck的52位

--hd0 7AFA99FC

SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('7AFA99%');--7AFA99FC
--1 B7C0FC90 213023 1 1 2 library cache 7AFA99F0 96 freeabl 0 00
SELECT upper(to_char(to_number('7AFA99F0','xxxxxxxxxxxxx')+96,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 7AFA99F0 -- 7AFA9A50
SELECT to_number('7AFA99FC','xxxxxxxxxxxxx')-to_number('7AFA99F0','xxxxxxxxxxxxx') FROM dual;--在chunck的12位

--subheap 内信息 hd0 7AFA99FC
SELECT * FROM x$ksmhp t WHERE t.ksmchds=hextoraw('7AFA99FC'); -- child sub
/*
1 B7F9F098 0 1 7AFA99FC free memory 74359130 60 free 0 00 74358D70
2 B7F9F060 1 1 7AFA99FC permanent memor 74358D60 976 perm 0 00 74358D70
3 B7F9F028 2 1 7AFA99FC permanent memor 743599E0 1052 perm 0 00 74358D70
*/

SELECT t.*,upper(to_char(to_number(t.ksmchptr,'xxxxxxxxxxxxx')+ksmchsiz,'xxxxxxxxxxxxxxxxxxxxx'))"endadr" FROM x$ksmsp t WHERE t.ksmchpar='7AFA99FC';
--1 B775C144 121058 1 1 3 CCursor 743599CC 1072 freeabl 0 7AFA99FC 74359DFC
--2 B775C09C 121061 1 1 3 CCursor 74358D3C 1072 recr 4095 7AFA99FC 7435916C

--hd6 74359048
SELECT * FROM x$ksmsp t WHERE t.ksmchptr LIKE upper('74358%');--74359048
--1 B775C09C 121061 1 1 3 CCursor 74358D3C 1072 recr 4095 7AFA99FC
SELECT upper(to_char(to_number('74358D3C','xxxxxxxxxxxxx')+1072,'xxxxxxxxxxxxxxxxxxxxx')) FROM dual;-- 74358D3C --7435916C
SELECT to_number('74359048','xxxxxxxxxxxxx')-to_number('74358D3C','xxxxxxxxxxxxx') FROM dual;--在chunck的780位

--subheap 内信息 74359048
SELECT * FROM x$ksmhp t WHERE t.ksmchds=hextoraw('74359048'); -- child sub
/*
1 B7F9F610 0 1 74359048 free memory 6D7AD250 44 free 0 00 74358D70
2 B7F9F5D8 1 1 74359048 permanent memor 6D7ACF30 800 perm 0 00 74358D70
3 B7F9F5A0 2 1 74359048 permanent memor 6D7A8CF8 960 perm 0 00 74358D70
4 B7F9F568 3 1 74359048 free memory 6D7A188C 184 free 0 00 74358D70
5 B7F9F530 4 1 74359048 permanent memor 6D7A1528 868 perm 0 00 74358D70
6 B7F9F4F8 5 1 74359048 free memory 6D7A145C 184 free 0 00 74358D70
7 B7F9F4C0 6 1 74359048 permanent memor 6D7A10F8 868 perm 0 00 74358D70
8 B7F9F488 7 1 74359048 free memory 6D7A1044 160 free 0 00 74358D70
9 B7F9F450 8 1 74359048 permanent memor 6D7A102C 24 perm 0 00 74358D70
10 B7F9F418 9 1 74359048 permanent memor 6D7A0CC8 868 perm 0 00 74358D70
11 B7F9F3E0 10 1 74359048 permanent memor 6D7A0958 860 perm 0 00 74358D70
12 B7F9F3A8 11 1 74359048 free memory 6D7A8524 184 free 0 00 74358D70
13 B7F9F370 12 1 74359048 permanent memor 6D7A81C0 868 perm 0 00 74358D70
14 B7F9F338 13 1 74359048 free memory 6D7A80F4 184 free 0 00 74358D70
15 B7F9F300 14 1 74359048 permanent memor 6D7A7D90 868 perm 0 00 74358D70
16 B7F9F2C8 15 1 74359048 free memory 6D7A7CC4 184 free 0 00 74358D70
17 B7F9F290 16 1 74359048 permanent memor 6D7A7960 868 perm 0 00 74358D70
18 B7F9F258 17 1 74359048 free memory 6D7A7894 184 free 0 00 74358D70
19 B7F9F220 18 1 74359048 permanent memor 6D7A7530 868 perm 0 00 74358D70
20 B7F9F1E8 19 1 74359048 free memory 6D7A7464 184 free 0 00 74358D70
21 B7F9F1B0 20 1 74359048 permanent memor 6D7A7100 868 perm 0 00 74358D70
22 B7F9F178 21 1 74359048 free memory 6D7A7034 184 free 0 00 74358D70
23 B7F9F140 22 1 74359048 permanent memor 6D7A6CD0 868 perm 0 00 74358D70
24 B7F9F108 23 1 74359048 free memory 6D7A6C04 184 free 0 00 74358D70
25 B7F9F0D0 24 1 74359048 permanent memor 6D7A68A0 868 perm 0 00 74358D70
26 B7F9F098 25 1 74359048 pacdHds_kkpaco 6D7A659C 752 recr 4095 6D7AD0E0 74358D70
27 B7F9F060 26 1 74359048 permanent memor 6D7A6470 300 perm 0 00 74358D70
28 B7F9F028 27 1 74359048 pacdHds_kkpaco 6D79DBC4 4144 freeabl 0 6D7AD0E0 74358D70
*/
SELECT t.*,upper(to_char(to_number(t.ksmchptr,'xxxxxxxxxxxxx')+ksmchsiz,'xxxxxxxxxxxxxxxxxxxxx'))"endadr" FROM x$ksmsp t WHERE t.ksmchpar='74359048';
/*--1 B69190E8 21555 1 1 4 partitioning d 6D7ACF0C 880 recr 4095 74359048 6D7AD27C
2 B691ADDC 21568 1 1 4 partitioning d 6D7A8CE4 980 freeabl 0 74359048 6D7A90B8
3 B691AD34 21571 1 1 4 partitioning d 6D7A81AC 1072 freeabl 0 74359048 6D7A85DC
4 B691ACFC 21572 1 1 4 partitioning d 6D7A7D7C 1072 freeabl 0 74359048 6D7A81AC
5 B691ACC4 21573 1 1 4 partitioning d 6D7A794C 1072 freeabl 0 74359048 6D7A7D7C
6 B691AC8C 21574 1 1 4 partitioning d 6D7A751C 1072 freeabl 0 74359048 6D7A794C
7 B691AC54 21575 1 1 4 partitioning d 6D7A70EC 1072 freeabl 0 74359048 6D7A751C
8 B691AC1C 21576 1 1 4 partitioning d 6D7A6CBC 1072 freeabl 0 74359048 6D7A70EC
9 B691ABE4 21577 1 1 4 partitioning d 6D7A688C 1072 freeabl 0 74359048 6D7A6CBC
10 B691ABAC 21578 1 1 4 partitioning d 6D7A645C 1072 freeabl 0 74359048 6D7A688C
11 B691A8D4 21591 1 1 4 partitioning d 6D7A1514 1072 freeabl 0 74359048 6D7A1944
12 B691A89C 21592 1 1 4 partitioning d 6D7A10E4 1072 freeabl 0 74359048 6D7A1514
13 B691A864 21593 1 1 4 partitioning d 6D7A0CB4 1072 freeabl 0 74359048 6D7A10E4
14 B691A82C 21594 1 1 4 partitioning d 6D7A0944 880 freeabl 0 74359048 6D7A0CB4
15 B691A66C 21602 1 1 4 partitioning d 6D79DBB0 4164 freeabl 0 74359048 6D79EBF4
*/

[@more@]

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

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