关于shared pool的深入探讨(四)
link:
http://www.eygle.com/internal/shared_pool-4.htm
我们进一步来讨论一下shared pool的处理:
先进行相应查询，获得测试数据:
[[email protected] udump]$ sqlplus "/ as sysdba"sql*plus: release 9.2.0.3.0 - production on thu aug 26 10:21:54 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.3.0 - productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.3.0 - productionsql> connect eygle/eygleconnected.sql> create table emp as select * from scott.emp;table created.sql> sql> connect / as sysdbaconnected.sql> startup force;oracle instance started.total system global area 47256168 bytesfixed size 451176 bytesvariable size 29360128 bytesdatabase buffers 16777216 bytesredo buffers 667648 bytesdatabase mounted.database opened.sql> set linesize 120sql> connect scott/tigerconnected.sql> select * from emp; empno ename job mgr hiredate sal comm deptno---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 smith clerk 7902 17-dec-80 800 20 8888 eygle manager 11-aug-04 9999 10 10 7566 jones manager 7839 02-apr-81 2975 20 7698 blake manager 7839 01-may-81 2850 30 7782 clark manager 7839 09-jun-81 2450 10 7788 scott analyst 7566 19-apr-87 3000 20 7839 king president 17-nov-81 5000 10 7876 adams clerk 7788 23-may-87 1100 20 7900 james clerk 7698 03-dec-81 950 30 7902 ford analyst 7566 03-dec-81 3000 20 7934 miller clerk 7782 23-jan-82 1300 1011 rows selected.sql> connect eygle/eygleconnected.sql> select * from emp; empno ename job mgr hiredate sal comm deptno---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 smith clerk 7902 17-dec-80 800 20 8888 eygle manager 11-aug-04 9999 10 10 7566 jones manager 7839 02-apr-81 2975 20 7698 blake manager 7839 01-may-81 2850 30 7782 clark manager 7839 09-jun-81 2450 10 7788 scott analyst 7566 19-apr-87 3000 20 7839 king president 17-nov-81 5000 10 7876 adams clerk 7788 23-may-87 1100 20 7900 james clerk 7698 03-dec-81 950 30 7902 ford analyst 7566 03-dec-81 3000 20 7934 miller clerk 7782 23-jan-82 1300 1011 rows selected.sql> select sql_text,version_count,hash_value,to_char(hash_value,'xxxxxxxxxx') hex,address 2 from v$sqlarea where sql_text like 'select * from emp%';sql_text version_count hash_value hex address-------------------- ------------- ---------- ----------- --------select * from emp 2 2648707557 9de011e5 52d9ea28sql> select sql_text,username,address,hash_value,to_char(hash_value,'xxxxxxxxxx') hex_hash_value,child_number,child_latch 2 from v$sql a,dba_users b where a.parsing_user_id = b.user_id and sql_text like 'select * from emp%';sql_text username address hash_value hex_hash_va child_number child_latch-------------------- ------------------------------ -------- ---------- ----------- ------------ -----------select * from emp scott 52d9ea28 2648707557 9de011e5 0 1select * from emp eygle 52d9ea28 2648707557 9de011e5 1 1注意:这里我们可以看出v$sqlarea和v$sql两个视图的不同之处v$sql中为每一条sql保留一个条目，而v$sqlarea中根据sql_text进行group by,通过version_count计算子指针的个数.我们注意到,这两条sql语句因为其代码完全相同,所以其address,hash_value也完全相同.这就意味着,这两条sql语句在shared pool中的存储位置是相同的(尽管其执行计划可能不同),代码得以共享.在此过程中oracle完成sql解析的第一个步骤:语法解析oracle进行语法检查时遵循自右向左,自下向上的原则,如果发现语法错误就马上返回错误.语法检查通过以后,oracle将sql文本转换为相应的ascii数值,然后根据数值通过hash函数计算其hash_value在shared pool中寻找是否存在相同的sql语句,如果存在,则进入下一步骤;如果不存在则尝试获取shared pool latch请求内存,存储该sql代码在这里有一个问题需要说明一下:因为大小写字母的ascii值是不同的,所以oracle会把大小写不同的代码作为不同的sql来处理,我们看一下测试:sql> select * from scott.dept; deptno dname loc---------- -------------- ------------- 10 accounting new york 20 research dallas 30 sales chicago 40 operations bostonsql> select * from scott.dept; deptno dname loc---------- -------------- ------------- 10 accounting new york 20 research dallas 30 sales chicago 40 operations bostonsql> col sql_text for a30sql> select sql_text,hash_value from v$sql where sql_text like 'select * from scott%';sql_text hash_value------------------------------ ----------select * from scott.dept 4096614922select * from scott.dept 2089404358我们注意到,仅只大小写的不同使得原本相同的sql语句变成了两条"不同的代码"所以从这里我们可以看出,sql的规范编写非常重要.完成这一个步骤以后,oracle需要进行的是语义分析:在此步骤中,oracle需要验证对象是否存在,相关用户是否具有权限,引用的是否是相同的对象...对于我们第一个查询,实际上emp表来自不同的用户,那么sql的执行计划也就不同了当然影响sql执行计划的因素还有很多,包括优化器模式等sql> select a.*,to_char(to_hash,'xxxxxxxxxx') hex_hash_value 2 from v$object_dependency a where to_name='emp';from_add from_hash to_owner to_name to_addre to_hash to_type hex_hash_va-------- ---------- -------------------- -------------------- -------- ---------- ---------- -----------52d9ea28 2648707557 scott emp 52d9debc 828228010 2 315dc1aa52d9ea28 2648707557 eygle emp 52d82e58 1930491453 2 7310f63dsql> alter session set events 'immediate trace name library_cache level 1';session altered.sql> alter session set events 'immediate trace name library_cache level 2';session altered.sql> alter session set events 'immediate trace name library_cache level 4';session altered.sql> alter session set events 'immediate trace name library_cache level 8';session altered.sql> alter session set events 'immediate trace name library_cache level 16';session altered.sql> alter session set events 'immediate trace name library_cache level 32';session altered.sql> alter session set events 'immediate trace name library_cache level 100';session altered.
此处在不同级别对shared pool进行转储.
在转向trace文件之前,我们通过下图来看一下library cache的结构:
library cache handle指向library cache object,含对象名,namespace,时间戳,引用列表,锁定对象及pin对象列表等.
我们从dump文件中看看具体的信息,由以上v$sql视图我们得到以上查询的hash_value为9de011e5，address为52d9ea28
在bucket 4851中,我们找到了select * from emp 这条sql语句.
bucket 4581: library object handle: handle=52d9ea28 name=select * from emp hash=9de011e5 timestamp=08-26-2004 10:24:43 ==>这个hash正是v$sql中该sql语句的hash_value值 namespace=crsr flags=ron/tim/pn0/sml/[12010000] kkkk-dddd-llll=0000-0001-0001 lock=0 pin=0 latch#=1 lwt=0x52d9ea40[0x52d9ea40,0x52d9ea40] ltm=0x52d9ea48[0x52d9ea48,0x52d9ea48] pwt=0x52d9ea58[0x52d9ea58,0x52d9ea58] ptm=0x52d9eab0[0x52d9eab0,0x52d9eab0] ref=0x52d9ea30[0x52d9ea30, 0x52d9ea30] lnd=0x52d9eabc[0x52d9eabc,0x52d9eabc] library object: object=52d9e7b0 type=crsr flags=exs[0001] pflags= [00] status=vald load=0 children: size=16 child# table reference handle ------ -------- --------- -------- 0 52d9e96c 52d9e6cc 52d9e4ac 1 52d9e96c 52d9e70c 52d885cc==>这就是我们前边提到过的子指针,每个都指向了一个不同的handle data blocks: data# heap pointer status pins change alloc(k) size(k) ----- -------- -------- ------ ---- ------ -------- -------- 0 52d9e9b8 52d9e838 i/-/a 0 none 0.86 1.09 ==>此处的heap就是指内存地址. ==>这里存放的就是sql代码及用户连接信息 heap dump of data block 0:******************************************************heap dump heap name="library cache" desc=0x52d9e9b8 extent sz=0x224 alt=32767 het=16 rec=9 flg=2 opc=0 parent=0x5000002c owner=0x52d9e7b0 nex=(nil) xsz=0x224extent 0 addr=0x52d9e558 chunk 52d9e560 sz= 540 perm "perm " alo=44852d9e560 5000021d 00000000 52d9e7a0 000001c0 [...p.......r....]52d9e570 52d9e704 52d9e660 00020002 52d9e57c [...r`..r....|..r]52d9e580 52d9e57c 00000000 52d9e588 52d9e588 [|..r.......r...r]52d9e590 00000000 52d9e594 52d9e594 00000000 [.......r...r....]52d9e5a0 52d9e5a0 52d9e5a0 00000000 52d9e5ac [...r...r.......r]52d9e5b0 52d9e5ac 00000000 52d9e5b8 52d9e5b8 [...r.......r...r]52d9e5c0 00000000 52d9e5c4 52d9e5c4 00000000 [.......r...r....]52d9e5d0 52d9e5d0 52d9e5d0 00000000 52d9e5dc [...r...r.......r]52d9e5e0 52d9e5dc 00000000 52d9e5e8 52d9e5e8 [...r.......r...r]52d9e5f0 00000000 52d9e5f4 52d9e5f4 00000000 [.......r...r....]52d9e600 52d9e600 52d9e600 00000000 52d9e60c [...r...r.......r]52d9e610 52d9e60c 00000000 52d9e618 52d9e618 [...r.......r...r]52d9e620 00000000 52d9e624 52d9e624 00000000 [....$..r$..r....]52d9e630 52d9e630 52d9e630 00040004 00000000 [0..r0..r........]52d9e640 52d9e6e4 00000018 00000000 00000000 [...r............]52d9e650 00000000 00000000 52d9e63c 00000000 [........<..r....]52d9e660 52d9e570 52d9e704 00000000 00000000 [p..r...r........]52d9e670 00000000 52d9e6bc 00000010 00000004 [.......r........]52d9e680 00000000 00000000 00000000 00000000 [................] repeat 2 times52d9e6b0 00000000 00000000 00000000 52d9e96c [............l..r]52d9e6c0 00000000 00000000 00000000 52d9e4b4 [...............r]52d9e6d0 52d9e4b4 52d9e4ac 00000000 00000002 [...r...r........]52d9e6e0 00000000 00000000 00010018 00000001 [................]52d9e6f0 00000000 00000000 00000000 52d9e6e0 [...............r]52d9e700 00000000 52d9e660 52d9e570 52d885d4 [....`..rp..r...r]52d9e710 52d885d4 52d885cc 00000000 00000002 [...r...r........]52d9e720 00000000 00000000 00000000 00000000 [................] repeat 4 times52d9e770 00000000 00000000 00000000 [............] extent 1 addr=0x52d9e798 chunk 52d9e7a0 sz= 360 perm "perm " alo=36052d9e7a0 40000169 00000000 00000000 00000168 [[email protected]]52d9e7b0 52d9ea28 52d9e7b4 52d9e7b4 52d9e7bc [(..r...r...r...r]52d9e7c0 52d9e7bc 52d9e668 00000000 00010001 [...rh..r........]52d9e7d0 00000000 00000000 00000000 00000000 [................]52d9e7e0 52d9e824 00000000 00000000 00000000 [$..r............]52d9e7f0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d9e820 00000000 52d9e9b8 00000000 52d9e838 [.......r....8..r]52d9e830 00000000 52ff79a4 00080304 00000000 [.....y.r........]52d9e840 00000100 00000000 00000000 00000010 [................]52d9e850 00000004 00000000 00000000 00000000 [................]52d9e860 00000000 52d9e640 00000002 2a4c5153 [[email protected]*]52d9e870 73756c50 706d756a 682e7265 61727275 [plusjumper.hurra]52d9e880 6f632e79 6e632e6d 4e542820 31562053 [y.com.cn (tns v1]52d9e890 2933562d 00000000 00000000 00000008 [-v3)............]52d9e8a0 dabefa60 00000000 00000000 00000000 [`...............]52d9e8b0 00000000 00000000 00000000 00000000 [................]52d9e8c0 00000000 00000000 f0318558 52d9e8d8 [........x.1....r]52d9e8d0 52d9e630 00000000 52d9e570 00000000 [0..r....p..r....]52d9e8e0 00000000 00000000 00000000 00000000 [................]52d9e8f0 00000000 00000000 00000002 0000000d [................]52d9e900 00000001 00000000 [........] chunk 52d9e908 sz= 88 free " "52d9e900 c0000059 52d9e7a0 [y......r]52d9e910 52d9ea00 52d9ea00 00000000 00000000 [...r...r........]52d9e920 00000000 00000000 00000000 00000000 [................] repeat 3 times chunk 52d9e960 sz= 76 freeable "kgltbtab "52d9e960 1000004d 52d9e908 0a857928 52d9e6cc [m......r(y.....r]52d9e970 52d9e70c 00000000 00000000 00000000 [...r............]52d9e980 00000000 00000000 00000000 00000000 [................] repeat 1 times52d9e9a0 00000000 00000000 00000000 [............] total heap size = 1064free lists: bucket 0 size=0 chunk 52d9e908 sz= 88 free " "52d9e900 c0000059 52d9e7a0 [y......r]52d9e910 52d9ea00 52d9ea00 00000000 00000000 [...r...r........]52d9e920 00000000 00000000 00000000 00000000 [................] repeat 3 timestotal free space = 88unpinned recreatable chunks (lru first):permanent chunks: chunk 52d9e560 sz= 540 perm "perm " alo=44852d9e560 5000021d 00000000 52d9e7a0 000001c0 [...p.......r....]52d9e570 52d9e704 52d9e660 00020002 52d9e57c [...r`..r....|..r]52d9e580 52d9e57c 00000000 52d9e588 52d9e588 [|..r.......r...r]52d9e590 00000000 52d9e594 52d9e594 00000000 [.......r...r....]52d9e5a0 52d9e5a0 52d9e5a0 00000000 52d9e5ac [...r...r.......r]52d9e5b0 52d9e5ac 00000000 52d9e5b8 52d9e5b8 [...r.......r...r]52d9e5c0 00000000 52d9e5c4 52d9e5c4 00000000 [.......r...r....]52d9e5d0 52d9e5d0 52d9e5d0 00000000 52d9e5dc [...r...r.......r]52d9e5e0 52d9e5dc 00000000 52d9e5e8 52d9e5e8 [...r.......r...r]52d9e5f0 00000000 52d9e5f4 52d9e5f4 00000000 [.......r...r....]52d9e600 52d9e600 52d9e600 00000000 52d9e60c [...r...r.......r]52d9e610 52d9e60c 00000000 52d9e618 52d9e618 [...r.......r...r]52d9e620 00000000 52d9e624 52d9e624 00000000 [....$..r$..r....]52d9e630 52d9e630 52d9e630 00040004 00000000 [0..r0..r........]52d9e640 52d9e6e4 00000018 00000000 00000000 [...r............]52d9e650 00000000 00000000 52d9e63c 00000000 [........<..r....]52d9e660 52d9e570 52d9e704 00000000 00000000 [p..r...r........]52d9e670 00000000 52d9e6bc 00000010 00000004 [.......r........]52d9e680 00000000 00000000 00000000 00000000 [................] repeat 2 times52d9e6b0 00000000 00000000 00000000 52d9e96c [............l..r]52d9e6c0 00000000 00000000 00000000 52d9e4b4 [...............r]52d9e6d0 52d9e4b4 52d9e4ac 00000000 00000002 [...r...r........]52d9e6e0 00000000 00000000 00010018 00000001 [................]52d9e6f0 00000000 00000000 00000000 52d9e6e0 [...............r]52d9e700 00000000 52d9e660 52d9e570 52d885d4 [....`..rp..r...r]52d9e710 52d885d4 52d885cc 00000000 00000002 [...r...r........]52d9e720 00000000 00000000 00000000 00000000 [................] repeat 4 times52d9e770 00000000 00000000 00000000 [............] chunk 52d9e7a0 sz= 360 perm "perm " alo=36052d9e7a0 40000169 00000000 00000000 00000168 [[email protected]]52d9e7b0 52d9ea28 52d9e7b4 52d9e7b4 52d9e7bc [(..r...r...r...r]52d9e7c0 52d9e7bc 52d9e668 00000000 00010001 [...rh..r........]52d9e7d0 00000000 00000000 00000000 00000000 [................]52d9e7e0 52d9e824 00000000 00000000 00000000 [$..r............]52d9e7f0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d9e820 00000000 52d9e9b8 00000000 52d9e838 [.......r....8..r]52d9e830 00000000 52ff79a4 00080304 00000000 [.....y.r........]52d9e840 00000100 00000000 00000000 00000010 [................]52d9e850 00000004 00000000 00000000 00000000 [................]52d9e860 00000000 52d9e640 00000002 2a4c5153 [[email protected]*]52d9e870 73756c50 706d756a 682e7265 61727275 [plusjumper.hurra]52d9e880 6f632e79 6e632e6d 4e542820 31562053 [y.com.cn (tns v1]52d9e890 2933562d 00000000 00000000 00000008 [-v3)............]52d9e8a0 dabefa60 00000000 00000000 00000000 [`...............]52d9e8b0 00000000 00000000 00000000 00000000 [................]52d9e8c0 00000000 00000000 f0318558 52d9e8d8 [........x.1....r]52d9e8d0 52d9e630 00000000 52d9e570 00000000 [0..r....p..r....]52d9e8e0 00000000 00000000 00000000 00000000 [................]52d9e8f0 00000000 00000000 00000002 0000000d [................]52d9e900 00000001 00000000 [........] permanent space = 900****************************************************** bucket 4581 total object count=1 我们以handle:52d885cc为例看一下library cache object的结构:****************************************************** library object handle: handle=52d885cc namespace=crsr flags=ron/kghp/pn0/[10010000] kkkk-dddd-llll=0000-0041-0041 lock=0 pin=0 latch#=1 lwt=0x52d885e4[0x52d885e4,0x52d885e4] ltm=0x52d885ec[0x52d885ec,0x52d885ec] pwt=0x52d885fc[0x52d885fc,0x52d885fc] ptm=0x52d88654[0x52d88654,0x52d88654] ref=0x52d885d4[0x52d9e70c, 0x52d9e70c] lnd=0x52d88660[0x52d88660,0x52d88660] library object: object=52d82a24 type=crsr flags=exs[0001] pflags= [00] status=vald load=0 dependencies: count=1 size=16 dependency# table reference handle position flags ----------- -------- --------- -------- -------- ------------------- 0 52d82be0 52d82b20 52d82e58 14 dep[01] ==>在dependency部分我们看到,这个cursor依赖的对象handle: 52d82e58==>这个handle指向的就是eygle.emp表，如果以上两个crsr访问的是同一个对象,那么==>这两个sql才会是真的共享.这里我们的sql虽然是相同的，访问的却是不同用户的数据表==>子指针的概念就出来了.==>在这里我们看到52d82e58指向的是eygle.emp这个对象,也就是eygle所查询的数据表. accesses: count=1 size=16 dependency# types ----------- ----- 0 0009 translations: count=1 size=16 original final -------- -------- 52d82e58 52d82e58 data blocks: data# heap pointer status pins change alloc(k) size(k) ----- -------- -------- ------ ---- ------ -------- -------- 0 52d8c244 52d827e4 i/-/a 0 none 1.09 1.64 6 52d82ac0 52d817c4 i/-/a 0 none 3.70 3.73 ==>这里的data blocks是个重要的部分==>每个控制块包含一个heap descriptor,指向相应的heap memory,这个heap memory包含的就是==>diana tree,p-code,source code,shared cursor context area等重要数据,也就是我们通常==>所说的，解析过的sql及执行计划树,真正到这里以后,sql才得以共享.也就真正的避免了硬==>解析 heap dump of data block 0:****************************************************** heap dump heap name="library cache" desc=0x52d8c244 extent sz=0x224 alt=32767 het=16 rec=9 flg=2 opc=0 parent=0x5000002c owner=0x52d82a24 nex=(nil) xsz=0x224extent 0 addr=0x52d80ff0 chunk 52d80ff8 sz= 464 free " "52d80ff0 c00001d1 00000000 [........]52d81000 52d8c28c 52d8c28c 00000000 00000000 [...r...r........]52d81010 00000000 00000000 00000000 00000000 [................] repeat 26 times52d811c0 00000000 00000000 [........] chunk 52d811c8 sz= 76 freeable "kgltbtab "52d811c0 1000004d 52d80ff8 [m......r]52d811d0 0a857928 52d82b68 00000000 00000000 [(y..h+.r........]52d811e0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d81210 00000000 [....] extent 1 addr=0x52d827cc chunk 52d827d4 sz= 540 perm "perm " alo=53252d827d0 5000021d 00000000 52d82a14 [...p.....*.r]52d827e0 00000214 00000000 0000001a 00000069 [............i...]52d827f0 00000110 00000000 00000000 00000006 [................]52d82800 00000850 00000010 00000008 00000005 [p...............]52d82810 00000005 4c475945 00000045 00000000 [....eygle.......]52d82820 00000000 00000000 00000000 00000000 [................]52d82830 00050000 52d82970 00000000 00000000 [....p).r........]52d82840 00000069 4c475945 00000045 00000000 [i...eygle.......]52d82850 00000000 00000000 00000000 00000000 [................]52d82860 00050000 00000001 00000004 00000019 [................]52d82870 0000000b 00000000 00000002 00000001 [................]52d82880 00002dc7 00000000 000030a4 00000000 [.-.......0......]52d82890 00000000 04000000 00000000 00650000 [..............e.]52d828a0 00100000 00050001 01050100 00000001 [................]52d828b0 000007d0 00640000 00010000 01000000 [......d.........]52d828c0 00000404 00000000 01010101 01010001 [................]52d828d0 01010101 00010001 01010101 00000000 [................]52d828e0 00000202 02010000 01010100 01010101 [................]52d828f0 00000000 01000001 00000000 00000000 [................]52d82900 00000000 00000000 00000000 1a086878 [............xh..]52d82910 0036190b 00000000 000001c4 00000000 [..6.............]52d82920 00000000 00000000 00000000 00000000 [................] repeat 1 times52d82940 00022000 00000000 0000ffff ffffffff [. ..............]52d82950 00000000 00000000 00000000 1a086878 [............xh..]52d82960 0036190b 00000000 00000000 00000000 [..6.............]52d82970 00000001 00000069 00000077 00000002 [....i...w.......]52d82980 00000003 52d829d8 00010010 00000004 [.....).r........]52d82990 00000000 00000000 00000000 00000000 [................]52d829a0 00000000 00000000 52d82b58 00010010 [........x+.r....]52d829b0 00000004 52d82b40 00010010 00000004 [[email protected]+.r........]52d829c0 00000000 00000000 00000000 00000000 [................]52d829d0 00000000 00000000 52d82be0 00000000 [.........+.r....]52d829e0 00000000 00000000 00000000 00000000 [................]extent 2 addr=0x52d82a0c chunk 52d82a14 sz= 252 perm "perm " alo=25252d82a10 400000fd 00000000 00000000 [[email protected]]52d82a20 000000fc 52d885cc 52d82a28 52d82a28 [.......r(*.r(*.r]52d82a30 52d82a30 52d82a30 52d82984 00000000 [0*.r0*.r.).r....]52d82a40 00010001 00000000 00000000 00000000 [................]52d82a50 00000000 52d82a98 00000000 00000000 [.....*.r........]52d82a60 00000000 00000000 00000000 52d82aac [.............*.r]52d82a70 00000000 00000000 00000000 00000000 [................] repeat 1 times52d82a90 00000000 00000000 52d8c244 00000000 [........d..r....]52d82aa0 52d827e4 00000000 52ff5b74 52d82ac0 [.'.r....t[.r.*.r]52d82ab0 00000000 52d817c4 00040000 52ff5b9c [.......r.....[.r]52d82ac0 5000002c 00001024 52d82a24 52d817ac [,..p$...$*.r...r]52d82ad0 52d817b4 00000000 52d8237c 05010200 [...r....|#.r....]52d82ae0 00000000 00000000 206c7173 61657261 [........sql area]52d82af0 00000000 00000000 00107fff 7fff7fff [................]52d82b00 00000401 00000000 52d82b08 52d82b08 [.........+.r.+.r] chunk 52d82b10 sz= 120 perm "perm " alo=10452d82b10 40000079 52d82a14 52d827d4 00000068 [[email protected]*.r.'.rh...]52d82b20 52b2d470 52b2d470 52d82e58 00000000 [p..rp..rx..r....]52d82b30 00000001 52d82a24 0000000e 00000001 [....$*.r........]52d82b40 52d82b94 00000000 00000000 00000000 [.+.r............]52d82b50 52d82e58 52d82e58 52d811d4 00000000 [x..rx..r...r....]52d82b60 00000000 00000000 00000000 00000000 [................]52d82b70 02000000 00000000 00000000 00000000 [................]52d82b80 00000000 00000000 [........] chunk 52d82b88 sz= 76 freeable "kgltbtab "52d82b80 0000004d 52d82b10 [m....+.r]52d82b90 0a857928 52d82b50 00000000 00000000 [(y..p+.r........]52d82ba0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82bd0 00000000 [....] chunk 52d82bd4 sz= 76 freeable "kgltbtab "52d82bd0 1000004d 52d82b88 0a857928 [m....+.r(y..]52d82be0 52d82b20 00000000 00000000 00000000 [ +.r............]52d82bf0 00000000 00000000 00000000 00000000 [................] repeat 2 timestotal heap size = 1604free lists: bucket 0 size=0 chunk 52d80ff8 sz= 464 free " "52d80ff0 c00001d1 00000000 [........]52d81000 52d8c28c 52d8c28c 00000000 00000000 [...r...r........]52d81010 00000000 00000000 00000000 00000000 [................] repeat 26 times52d811c0 00000000 00000000 [........] total free space = 464unpinned recreatable chunks (lru first):permanent chunks: chunk 52d82b10 sz= 120 perm "perm " alo=10452d82b10 40000079 52d82a14 52d827d4 00000068 [[email protected]*.r.'.rh...]52d82b20 52b2d470 52b2d470 52d82e58 00000000 [p..rp..rx..r....]52d82b30 00000001 52d82a24 0000000e 00000001 [....$*.r........]52d82b40 52d82b94 00000000 00000000 00000000 [.+.r............]52d82b50 52d82e58 52d82e58 52d811d4 00000000 [x..rx..r...r....]52d82b60 00000000 00000000 00000000 00000000 [................]52d82b70 02000000 00000000 00000000 00000000 [................]52d82b80 00000000 00000000 [........] chunk 52d827d4 sz= 540 perm "perm " alo=53252d827d0 5000021d 00000000 52d82a14 [...p.....*.r]52d827e0 00000214 00000000 0000001a 00000069 [............i...]52d827f0 00000110 00000000 00000000 00000006 [................]52d82800 00000850 00000010 00000008 00000005 [p...............]52d82810 00000005 4c475945 00000045 00000000 [....eygle.......]52d82820 00000000 00000000 00000000 00000000 [................]52d82830 00050000 52d82970 00000000 00000000 [....p).r........]52d82840 00000069 4c475945 00000045 00000000 [i...eygle.......]52d82850 00000000 00000000 00000000 00000000 [................]52d82860 00050000 00000001 00000004 00000019 [................]52d82870 0000000b 00000000 00000002 00000001 [................]52d82880 00002dc7 00000000 000030a4 00000000 [.-.......0......]52d82890 00000000 04000000 00000000 00650000 [..............e.]52d828a0 00100000 00050001 01050100 00000001 [................]52d828b0 000007d0 00640000 00010000 01000000 [......d.........]52d828c0 00000404 00000000 01010101 01010001 [................]52d828d0 01010101 00010001 01010101 00000000 [................]52d828e0 00000202 02010000 01010100 01010101 [................]52d828f0 00000000 01000001 00000000 00000000 [................]52d82900 00000000 00000000 00000000 1a086878 [............xh..]52d82910 0036190b 00000000 000001c4 00000000 [..6.............]52d82920 00000000 00000000 00000000 00000000 [................] repeat 1 times52d82940 00022000 00000000 0000ffff ffffffff [. ..............]52d82950 00000000 00000000 00000000 1a086878 [............xh..]52d82960 0036190b 00000000 00000000 00000000 [..6.............]52d82970 00000001 00000069 00000077 00000002 [....i...w.......]52d82980 00000003 52d829d8 00010010 00000004 [.....).r........]52d82990 00000000 00000000 00000000 00000000 [................]52d829a0 00000000 00000000 52d82b58 00010010 [........x+.r....]52d829b0 00000004 52d82b40 00010010 00000004 [[email protected]+.r........]52d829c0 00000000 00000000 00000000 00000000 [................]52d829d0 00000000 00000000 52d82be0 00000000 [.........+.r....]52d829e0 00000000 00000000 00000000 00000000 [................] chunk 52d82a14 sz= 252 perm "perm " alo=25252d82a10 400000fd 00000000 00000000 [[email protected]]52d82a20 000000fc 52d885cc 52d82a28 52d82a28 [.......r(*.r(*.r]52d82a30 52d82a30 52d82a30 52d82984 00000000 [0*.r0*.r.).r....]52d82a40 00010001 00000000 00000000 00000000 [................]52d82a50 00000000 52d82a98 00000000 00000000 [.....*.r........]52d82a60 00000000 00000000 00000000 52d82aac [.............*.r]52d82a70 00000000 00000000 00000000 00000000 [................] repeat 1 times52d82a90 00000000 00000000 52d8c244 00000000 [........d..r....]52d82aa0 52d827e4 00000000 52ff5b74 52d82ac0 [.'.r....t[.r.*.r]52d82ab0 00000000 52d817c4 00040000 52ff5b9c [.......r.....[.r]52d82ac0 5000002c 00001024 52d82a24 52d817ac [,..p$...$*.r...r]52d82ad0 52d817b4 00000000 52d8237c 05010200 [...r....|#.r....]52d82ae0 00000000 00000000 206c7173 61657261 [........sql area]52d82af0 00000000 00000000 00107fff 7fff7fff [................]52d82b00 00000401 00000000 52d82b08 52d82b08 [.........+.r.+.r]permanent space = 912****************************************************** heap dump of data block 6:******************************************************heap dump heap name="sql area" desc=0x52d82ac0 extent sz=0x1024 alt=32767 het=16 rec=0 flg=2 opc=5 parent=0x5000002c owner=0x52d82a24 nex=(nil) xsz=0x0extent 0 addr=0x52d817ac chunk 52d817b4 sz= 3784 perm "perm " alo=378452d817b0 50000ec9 00000000 00000000 [...p........]52d817c0 00000ec8 00000010 00000004 00000010 [................]52d817d0 00000004 00000000 00000000 00000000 [................]52d817e0 00000000 00000000 00000008 00000000 [................]52d817f0 00000000 52d81f5c 404eeb2c 00000000 [..../..r,[email protected]]52d81800 00000000 00000000 00000000 52d81a08 [...............r]52d81810 00000000 00000000 00000110 00000003 [................]52d81820 00000000 00000000 00000000 1a086878 [............xh..]52d81830 0029180b 00000000 00000000 00000000 [..).............]52d81840 52d81c10 52d82540 00000000 52d824d4 [[email protected]%.r.....$.r]52d81850 00000000 00000000 00000000 52d81b7c [............|..r]52d81860 00000000 00000000 00000001 52d81bfc [...............r]52d81870 52d82360 00000000 00000000 52d82894 [`#.r.........(.r]52d81880 00000000 00000000 00000000 00000000 [................] repeat 1 times52d818a0 00000000 00000000 08000000 52d823ac [.............#.r]52d818b0 00000001 00000000 00000000 00000000 [................]52d818c0 00000024 00000000 00000000 00000000 [$...............]52d818d0 00000000 00000000 00000000 52d81c1c [...............r]52d818e0 00000000 00000000 00000000 52d82620 [............ &.r]52d818f0 00000000 00000000 00000000 52d81958 [............x..r]52d81900 00000000 00000000 00000000 00000000 [................]52d81910 00000000 00000000 52d8252c 00010001 [........,%.r....]52d81920 ebce39a4 00000000 00000000 00000000 [.9..............]52d81930 00000000 00000000 00000000 00000001 [................]52d81940 00000001 00000794 00000000 00000001 [................]52d81950 00000001 00000008 00000000 52d817c4 [...............r]52d81960 00000000 00000000 00000202 00000000 [................]52d81970 52d819b8 52d819a0 52d81990 5001a874 [...r...r...rt..p]52d81980 00000000 00000000 52d819fc 52d819cc [...........r...r]52d81990 52d82ac0 404efb80 00000000 00000000 [.*[email protected]]52d819a0 00000000 00000000 52d81958 00000000 [........x..r....]52d819b0 00000000 00000000 00000000 52d81958 [............x..r]52d819c0 00000002 52d885cc 00000000 52d819e4 [.......r.......r]52d819d0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d819f0 00000001 00000000 00000000 52d81958 [............x..r]52d81a00 00000000 00000000 4c475945 00000045 [........eygle...]52d81a10 00000000 00000000 00000000 00000000 [................]52d81a20 00000000 00050000 00000069 0000000e [........i.......]52d81a30 4d450003 00000050 00000000 00000500 [..emp...........]52d81a40 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81a60 404ee794 00000000 00000000 00000014 [[email protected]]52d81a70 00000004 00000000 00000000 00000000 [................]52d81a80 00000000 00000000 00000000 00000000 [................]52d81a90 00000000 00000000 00000000 00003f09 [.............?..]52d81aa0 00000001 00000000 00000000 00000000 [................]52d81ab0 00000000 00000069 00080008 00000000 [....i...........]52d81ac0 08687800 29180b1a 1a086878 7829180b [.xh....)xh....)x]52d81ad0 0b1a0868 00002918 00000000 00000000 [h....)..........]52d81ae0 00000000 00000000 00000000 00000000 [................]52d81af0 00000000 00000001 00000000 000002e0 [................]52d81b00 00000000 00000008 00000000 00000000 [................]52d81b10 00000000 404eec04 00000000 52d81b9c [[email protected]]52d81b20 52d81b9c 00000000 00000000 00000000 [...r............]52d81b30 00000000 00000000 00000000 00000000 [................]52d81b40 00000000 00000000 00000000 20000000 [............... ]52d81b50 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81b70 00000000 00000000 00000000 52d81948 [............h..r]52d81b80 00000000 00000002 00000008 0000000e [................]52d81b90 59450005 00454c47 00000000 00000000 [..eygle.........]52d81ba0 40548000 00000001 00000064 00000000 [[email protected]]52d81bb0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81bd0 00000000 00002000 00000000 00000000 [..... ..........]52d81be0 00000000 00000000 00000000 00000000 [................]52d81bf0 00000000 00000000 00003f09 00000000 [.........?......]52d81c00 00000014 00000004 00000001 00000000 [................]52d81c10 00000000 00003f09 00010000 52d81fd4 [.....?.........r]52d81c20 52d81f08 52d81f64 00000000 00000010 [...rd..r........]52d81c30 00000007 00000100 00000000 00000000 [................]52d81c40 00000000 00000000 00000000 00000010 [................]52d81c50 00000104 00000000 00000000 00000000 [................]52d81c60 00000000 00000000 00000000 00000000 [................]52d81c70 52d81a2c 00000000 404ee794 00000000 [,[email protected]]52d81c80 00000000 00000007 00000102 00000000 [................]52d81c90 00010041 00000000 00000014 00000004 [a...............]52d81ca0 00000010 000001a0 00000016 00000000 [................]52d81cb0 52d824b4 00040000 00000000 52d82300 [.$.r.........#.r]52d81cc0 00000000 52d81a2c 52d81fc4 404ee794 [....,[email protected]]52d81cd0 00000000 00000000 00000000 52d81c84 [...............r]52d81ce0 00000007 00000102 00000000 00010041 [............a...]52d81cf0 00000000 00000014 0000001c 00000010 [................]52d81d00 00000194 00000016 00000000 52d82494 [.............$.r]52d81d10 00040000 00000000 52d822a0 00000000 [.........".r....]52d81d20 52d81a2c 52d81fb8 404ee794 00000000 [,[email protected]]52d81d30 00000000 52d81cd8 52d81ce0 00000007 [.......r...r....]52d81d40 00000102 00000000 00010041 00000000 [........a.......]52d81d50 00000014 00000034 00000010 00000188 [....4...........]52d81d60 00000016 00000000 52d82474 00040000 [........t$.r....]52d81d70 00000000 52d82240 00000000 52d81a2c [[email protected]".r....,..r]52d81d80 52d81fac 404ee794 00000000 00000000 [[email protected]]52d81d90 52d81d34 52d81d3c 00000007 0000010c [4..r<..r........]52d81da0 00000000 00010041 00000000 00000014 [....a...........]52d81db0 0000004c 00000010 0000017c 00000007 [l.......|.......]52d81dc0 00000000 52d82454 00040000 00000000 [....t$.r........]52d81dd0 52d821e0 00000000 52d81a2c 52d81f9c [.!.r....,..r...r]52d81de0 404ee794 00000000 00000000 52d81d90 [[email protected]]52d81df0 52d81d98 00000007 00000102 00000000 [...r............]52d81e00 00010041 00000000 00000014 00000054 [a...........t...]52d81e10 00000010 00000170 00000016 00000000 [....p...........]52d81e20 52d82434 00040000 00000000 52d82180 [4$.r.........!.r]52d81e30 00000000 52d81a2c 52d81f90 404ee794 [....,[email protected]]52d81e40 00000000 00000000 52d81dec 52d81df4 [...........r...r]52d81e50 00000007 00000101 00010354 00010041 [........t...a...]52d81e60 00040000 00000014 0000006c 00000010 [........l.......]52d81e70 00000164 00090009 00000000 52d82414 [d............$.r]52d81e80 00040000 00000000 52d82120 00000000 [........ !.r....]52d81e90 52d81a2c 52d81f84 404ee794 00000000 [,[email protected]]52d81ea0 00000000 52d81e48 52d81e50 00000007 [....h..rp..r....]52d81eb0 00000101 00010354 00010041 00040000 [....t...a.......]52d81ec0 00000014 00000078 00000010 00000158 [....x.......x...]52d81ed0 000a000a 00000000 52d823f4 00040000 [.........#.r....]52d81ee0 00000000 52d820c0 00000000 52d81a2c [..... .r....,..r]52d81ef0 52d81f74 404ee794 00000000 00000000 [[email protected]]52d81f00 52d81ea4 52d81eac 00000007 00000102 [...r...r........]52d81f10 00000000 00010041 00000000 00000014 [....a...........]52d81f20 00000084 00000010 0000014c 00000016 [........l.......]52d81f30 00000000 52d823d4 00040000 00000000 [.....#.r........]52d81f40 52d82060 00000000 52d81a2c 52d81f64 [` .r....,..rd..r]52d81f50 404ee794 00000000 00000000 52d81f00 [[email protected]]52d81f60 52d81f08 00000007 4d450005 004f4e50 [...r......empno.]52d81f70 00000000 00000007 4e450005 00454d41 [..........ename.]52d81f80 00000000 00000007 4f4a0003 00000042 [..........job...]52d81f90 00000007 474d0003 00000052 00000007 [......mgr.......]52d81fa0 49480008 41444552 00004554 00000007 [..hiredate......]52d81fb0 41530003 0000004c 00000007 4f430004 [..sal.........co]52d81fc0 00004d4d 00000007 45440006 4f4e5450 [mm........deptno]52d81fd0 00000000 52d81fe8 52d81eac 52d81f74 [.......r...rt..r]52d81fe0 00000000 00000010 52d81ffc 52d81e50 [...........rp..r]52d81ff0 52d81f84 00000000 00000010 52d82010 [...r......... .r]52d82000 52d81df4 52d81f90 00000000 00000010 [...r...r........]52d82010 52d82024 52d81d98 52d81f9c 00000000 [$ .r...r...r....]52d82020 00000010 52d82038 52d81d3c 52d81fac [....8 .r<..r...r]52d82030 00000000 00000010 52d8204c 52d81ce0 [........l .r...r]52d82040 52d81fb8 00000000 00000010 00000000 [...r............]52d82050 52d81c84 52d81fc4 00000000 00000010 [...r...r........]52d82060 00000000 00010001 00020001 00000016 [................]52d82070 00000004 00000000 00000000 00000000 [................]52d82080 00000000 00000000 00000000 00000000 [................] repeat 2 times52d820b0 00000000 00000000 00000000 00003f09 [.............?..]52d820c0 00000000 00020002 00010002 000a000a [................]52d820d0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82100 00010354 00000000 00000000 00000000 [t...............]52d82110 00000000 00000000 00000000 00003f09 [.............?..]52d82120 00000000 00030003 00010003 00090009 [................]52d82130 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82160 00010354 00000000 00000000 00000000 [t...............]52d82170 00000000 00000000 00000000 00003f09 [.............?..]52d82180 00000000 00040004 00020004 00000016 [................]52d82190 00000004 00000000 00000000 00000000 [................]52d821a0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d821d0 00000000 00000000 00000000 00003f09 [.............?..]52d821e0 00000000 00050005 000c0005 00000007 [................]52d821f0 00000000 00000000 00000000 00000000 [................] repeat 3 times52d82230 00000000 00000000 00000000 00003f09 [.............?..]52d82240 00000000 00060006 00020006 00000016 [................]52d82250 00000207 00000000 00000000 00000000 [................]52d82260 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82290 00000000 00000000 00000000 00003f09 [.............?..]52d822a0 00000000 00070007 00020007 00000016 [................]52d822b0 00000207 00000000 00000000 00000000 [................]52d822c0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d822f0 00000000 00000000 00000000 00003f09 [.............?..]52d82300 00000000 00080008 00020008 00000016 [................]52d82310 00000002 00000000 00000000 00000000 [................]52d82320 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82350 00000000 00000000 00000000 00003f09 [.............?..]52d82360 00000000 00000000 00000000 52d82374 [............t#.r]52d82370 00003f09 00000000 52d82370 3eeeeeee [.?......p#.r...>]52d82380 00000000 52d817b4 52d82388 52d82388 [.......r.#.r.#.r]52d82390 00000000 404eecb8 404eecb8 404eecb8 [[email protected]@[email protected]]52d823a0 00000000 00000000 00000000 52d81a6c [............l..r]52d823b0 00000008 52d81f08 52d81eac 52d81e50 [.......r...rp..r]52d823c0 52d81df4 52d81d98 52d81d3c 52d81ce0 [...r...r<..r...r]52d823d0 52d81c84 00000010 0000014c 00000014 [...r....l.......]52d823e0 00000084 00000016 00000001 52d82060 [............` .r]52d823f0 00000001 00000010 00000158 00000014 [........x.......]52d82400 00000078 0000000a 00000002 52d820c0 [x............ .r]52d82410 00000001 00000010 00000164 00000014 [........d.......]52d82420 0000006c 00000009 00000003 52d82120 [l........... !.r]52d82430 00000001 00000010 00000170 00000014 [........p.......]52d82440 00000054 00000016 00000004 52d82180 [t............!.r]52d82450 00000001 00000010 0000017c 00000014 [........|.......]52d82460 0000004c 00000007 00000005 52d821e0 [l............!.r]52d82470 00000001 00000010 00000188 00000014 [................]52d82480 00000034 00000016 00000006 52d82240 [[email protected]".r]52d82490 00000001 00000010 00000194 00000014 [................]52d824a0 0000001c 00000016 00000007 52d822a0 [.............".r]52d824b0 00000001 00000010 000001a0 00000014 [................]52d824c0 00000004 00000016 00000008 52d82300 [.............#.r]52d824d0 00000001 52d81938 00000004 00000002 [....8..r........]52d824e0 000000bc 00000000 52d81c1c 00000008 [...........r....]52d824f0 00000000 00000000 00000000 00000000 [................]52d82500 00000000 00000000 00000012 02400791 [[email protected]]52d82510 00003f09 00003f09 00030000 00001fe8 [.?...?..........]52d82520 00000000 00000100 3f091826 00000001 [........&..?....]52d82530 00000010 000001ac 00000000 00000000 [................]52d82540 00000000 00000000 00000000 00000000 [................]52d82550 52d823b0 00000010 000001d0 00000017 [.#.r............]52d82560 52d82524 00000001 00003f09 00000000 [$%.r.....?......]52d82570 00000881 00000000 00000000 00000000 [................]52d82580 00000000 00000000 00000000 00000000 [................]52d82590 00000000 00000000 52d823d4 00080000 [.........#.r....]52d825a0 00000008 00000000 00000000 52d82508 [.............%.r]52d825b0 00000000 00000000 00000010 00000270 [............p...]52d825c0 52d823d4 00000008 00000014 0000009c [.#.r............]52d825d0 00000000 00000000 00000000 52d81acf [...............r]52d825e0 00000000 00000000 00000000 00000000 [................] repeat 3 times52d82620 52d8263c 00000010 000006d4 00000010 [<&.r............]52d82630 000006f4 00000010 000006f8 00000010 [................]52d82640 000006fc 00000010 00000714 00000010 [................]52d82650 00000720 00000010 0000072c 00000010 [ .......,.......]52d82660 00000744 00000010 0000074c 00000010 [d.......l.......]52d82670 00000764 00000010 0000077c [d.......|...] total heap size = 3784free lists: bucket 0 size=0total free space = 0unpinned recreatable chunks (lru first):permanent chunks: chunk 52d817b4 sz= 3784 perm "perm " alo=378452d817b0 50000ec9 00000000 00000000 [...p........]52d817c0 00000ec8 00000010 00000004 00000010 [................]52d817d0 00000004 00000000 00000000 00000000 [................]52d817e0 00000000 00000000 00000008 00000000 [................]52d817f0 00000000 52d81f5c 404eeb2c 00000000 [..../..r,[email protected]]52d81800 00000000 00000000 00000000 52d81a08 [...............r]52d81810 00000000 00000000 00000110 00000003 [................]52d81820 00000000 00000000 00000000 1a086878 [............xh..]52d81830 0029180b 00000000 00000000 00000000 [..).............]52d81840 52d81c10 52d82540 00000000 52d824d4 [[email protected]%.r.....$.r]52d81850 00000000 00000000 00000000 52d81b7c [............|..r]52d81860 00000000 00000000 00000001 52d81bfc [...............r]52d81870 52d82360 00000000 00000000 52d82894 [`#.r.........(.r]52d81880 00000000 00000000 00000000 00000000 [................] repeat 1 times52d818a0 00000000 00000000 08000000 52d823ac [.............#.r]52d818b0 00000001 00000000 00000000 00000000 [................]52d818c0 00000024 00000000 00000000 00000000 [$...............]52d818d0 00000000 00000000 00000000 52d81c1c [...............r]52d818e0 00000000 00000000 00000000 52d82620 [............ &.r]52d818f0 00000000 00000000 00000000 52d81958 [............x..r]52d81900 00000000 00000000 00000000 00000000 [................]52d81910 00000000 00000000 52d8252c 00010001 [........,%.r....]52d81920 ebce39a4 00000000 00000000 00000000 [.9..............]52d81930 00000000 00000000 00000000 00000001 [................]52d81940 00000001 00000794 00000000 00000001 [................]52d81950 00000001 00000008 00000000 52d817c4 [...............r]52d81960 00000000 00000000 00000202 00000000 [................]52d81970 52d819b8 52d819a0 52d81990 5001a874 [...r...r...rt..p]52d81980 00000000 00000000 52d819fc 52d819cc [...........r...r]52d81990 52d82ac0 404efb80 00000000 00000000 [.*[email protected]]52d819a0 00000000 00000000 52d81958 00000000 [........x..r....]52d819b0 00000000 00000000 00000000 52d81958 [............x..r]52d819c0 00000002 52d885cc 00000000 52d819e4 [.......r.......r]52d819d0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d819f0 00000001 00000000 00000000 52d81958 [............x..r]52d81a00 00000000 00000000 4c475945 00000045 [........eygle...]52d81a10 00000000 00000000 00000000 00000000 [................]52d81a20 00000000 00050000 00000069 0000000e [........i.......]52d81a30 4d450003 00000050 00000000 00000500 [..emp...........]52d81a40 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81a60 404ee794 00000000 00000000 00000014 [[email protected]]52d81a70 00000004 00000000 00000000 00000000 [................]52d81a80 00000000 00000000 00000000 00000000 [................]52d81a90 00000000 00000000 00000000 00003f09 [.............?..]52d81aa0 00000001 00000000 00000000 00000000 [................]52d81ab0 00000000 00000069 00080008 00000000 [....i...........]52d81ac0 08687800 29180b1a 1a086878 7829180b [.xh....)xh....)x]52d81ad0 0b1a0868 00002918 00000000 00000000 [h....)..........]52d81ae0 00000000 00000000 00000000 00000000 [................]52d81af0 00000000 00000001 00000000 000002e0 [................]52d81b00 00000000 00000008 00000000 00000000 [................]52d81b10 00000000 404eec04 00000000 52d81b9c [[email protected]]52d81b20 52d81b9c 00000000 00000000 00000000 [...r............]52d81b30 00000000 00000000 00000000 00000000 [................]52d81b40 00000000 00000000 00000000 20000000 [............... ]52d81b50 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81b70 00000000 00000000 00000000 52d81948 [............h..r]52d81b80 00000000 00000002 00000008 0000000e [................]52d81b90 59450005 00454c47 00000000 00000000 [..eygle.........]52d81ba0 40548000 00000001 00000064 00000000 [[email protected]]52d81bb0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81bd0 00000000 00002000 00000000 00000000 [..... ..........]52d81be0 00000000 00000000 00000000 00000000 [................]52d81bf0 00000000 00000000 00003f09 00000000 [.........?......]52d81c00 00000014 00000004 00000001 00000000 [................]52d81c10 00000000 00003f09 00010000 52d81fd4 [.....?.........r]52d81c20 52d81f08 52d81f64 00000000 00000010 [...rd..r........]52d81c30 00000007 00000100 00000000 00000000 [................]52d81c40 00000000 00000000 00000000 00000010 [................]52d81c50 00000104 00000000 00000000 00000000 [................]52d81c60 00000000 00000000 00000000 00000000 [................]52d81c70 52d81a2c 00000000 404ee794 00000000 [,[email protected]]52d81c80 00000000 00000007 00000102 00000000 [................]52d81c90 00010041 00000000 00000014 00000004 [a...............]52d81ca0 00000010 000001a0 00000016 00000000 [................]52d81cb0 52d824b4 00040000 00000000 52d82300 [.$.r.........#.r]52d81cc0 00000000 52d81a2c 52d81fc4 404ee794 [....,[email protected]]52d81cd0 00000000 00000000 00000000 52d81c84 [...............r]52d81ce0 00000007 00000102 00000000 00010041 [............a...]52d81cf0 00000000 00000014 0000001c 00000010 [................]52d81d00 00000194 00000016 00000000 52d82494 [.............$.r]52d81d10 00040000 00000000 52d822a0 00000000 [.........".r....]52d81d20 52d81a2c 52d81fb8 404ee794 00000000 [,[email protected]]52d81d30 00000000 52d81cd8 52d81ce0 00000007 [.......r...r....]52d81d40 00000102 00000000 00010041 00000000 [........a.......]52d81d50 00000014 00000034 00000010 00000188 [....4...........]52d81d60 00000016 00000000 52d82474 00040000 [........t$.r....]52d81d70 00000000 52d82240 00000000 52d81a2c [[email protected]".r....,..r]52d81d80 52d81fac 404ee794 00000000 00000000 [[email protected]]52d81d90 52d81d34 52d81d3c 00000007 0000010c [4..r<..r........]52d81da0 00000000 00010041 00000000 00000014 [....a...........]52d81db0 0000004c 00000010 0000017c 00000007 [l.......|.......]52d81dc0 00000000 52d82454 00040000 00000000 [....t$.r........]52d81dd0 52d821e0 00000000 52d81a2c 52d81f9c [.!.r....,..r...r]52d81de0 404ee794 00000000 00000000 52d81d90 [[email protected]]52d81df0 52d81d98 00000007 00000102 00000000 [...r............]52d81e00 00010041 00000000 00000014 00000054 [a...........t...]52d81e10 00000010 00000170 00000016 00000000 [....p...........]52d81e20 52d82434 00040000 00000000 52d82180 [4$.r.........!.r]52d81e30 00000000 52d81a2c 52d81f90 404ee794 [....,[email protected]]52d81e40 00000000 00000000 52d81dec 52d81df4 [...........r...r]52d81e50 00000007 00000101 00010354 00010041 [........t...a...]52d81e60 00040000 00000014 0000006c 00000010 [........l.......]52d81e70 00000164 00090009 00000000 52d82414 [d............$.r]52d81e80 00040000 00000000 52d82120 00000000 [........ !.r....]52d81e90 52d81a2c 52d81f84 404ee794 00000000 [,[email protected]]52d81ea0 00000000 52d81e48 52d81e50 00000007 [....h..rp..r....]52d81eb0 00000101 00010354 00010041 00040000 [....t...a.......]52d81ec0 00000014 00000078 00000010 00000158 [....x.......x...]52d81ed0 000a000a 00000000 52d823f4 00040000 [.........#.r....]52d81ee0 00000000 52d820c0 00000000 52d81a2c [..... .r....,..r]52d81ef0 52d81f74 404ee794 00000000 00000000 [[email protected]]52d81f00 52d81ea4 52d81eac 00000007 00000102 [...r...r........]52d81f10 00000000 00010041 00000000 00000014 [....a...........]52d81f20 00000084 00000010 0000014c 00000016 [........l.......]52d81f30 00000000 52d823d4 00040000 00000000 [.....#.r........]52d81f40 52d82060 00000000 52d81a2c 52d81f64 [` .r....,..rd..r]52d81f50 404ee794 00000000 00000000 52d81f00 [[email protected]]52d81f60 52d81f08 00000007 4d450005 004f4e50 [...r......empno.]52d81f70 00000000 00000007 4e450005 00454d41 [..........ename.]52d81f80 00000000 00000007 4f4a0003 00000042 [..........job...]52d81f90 00000007 474d0003 00000052 00000007 [......mgr.......]52d81fa0 49480008 41444552 00004554 00000007 [..hiredate......]52d81fb0 41530003 0000004c 00000007 4f430004 [..sal.........co]52d81fc0 00004d4d 00000007 45440006 4f4e5450 [mm........deptno]52d81fd0 00000000 52d81fe8 52d81eac 52d81f74 [.......r...rt..r]52d81fe0 00000000 00000010 52d81ffc 52d81e50 [...........rp..r]52d81ff0 52d81f84 00000000 00000010 52d82010 [...r......... .r]52d82000 52d81df4 52d81f90 00000000 00000010 [...r...r........]52d82010 52d82024 52d81d98 52d81f9c 00000000 [$ .r...r...r....]52d82020 00000010 52d82038 52d81d3c 52d81fac [....8 .r<..r...r]52d82030 00000000 00000010 52d8204c 52d81ce0 [........l .r...r]52d82040 52d81fb8 00000000 00000010 00000000 [...r............]52d82050 52d81c84 52d81fc4 00000000 00000010 [...r...r........]52d82060 00000000 00010001 00020001 00000016 [................]52d82070 00000004 00000000 00000000 00000000 [................]52d82080 00000000 00000000 00000000 00000000 [................] repeat 2 times52d820b0 00000000 00000000 00000000 00003f09 [.............?..]52d820c0 00000000 00020002 00010002 000a000a [................]52d820d0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82100 00010354 00000000 00000000 00000000 [t...............]52d82110 00000000 00000000 00000000 00003f09 [.............?..]52d82120 00000000 00030003 00010003 00090009 [................]52d82130 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82160 00010354 00000000 00000000 00000000 [t...............]52d82170 00000000 00000000 00000000 00003f09 [.............?..]52d82180 00000000 00040004 00020004 00000016 [................]52d82190 00000004 00000000 00000000 00000000 [................]52d821a0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d821d0 00000000 00000000 00000000 00003f09 [.............?..]52d821e0 00000000 00050005 000c0005 00000007 [................]52d821f0 00000000 00000000 00000000 00000000 [................] repeat 3 times52d82230 00000000 00000000 00000000 00003f09 [.............?..]52d82240 00000000 00060006 00020006 00000016 [................]52d82250 00000207 00000000 00000000 00000000 [................]52d82260 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82290 00000000 00000000 00000000 00003f09 [.............?..]52d822a0 00000000 00070007 00020007 00000016 [................]52d822b0 00000207 00000000 00000000 00000000 [................]52d822c0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d822f0 00000000 00000000 00000000 00003f09 [.............?..]52d82300 00000000 00080008 00020008 00000016 [................]52d82310 00000002 00000000 00000000 00000000 [................]52d82320 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82350 00000000 00000000 00000000 00003f09 [.............?..]52d82360 00000000 00000000 00000000 52d82374 [............t#.r]52d82370 00003f09 00000000 52d82370 3eeeeeee [.?......p#.r...>]52d82380 00000000 52d817b4 52d82388 52d82388 [.......r.#.r.#.r]52d82390 00000000 404eecb8 404eecb8 404eecb8 [[email protected]@[email protected]]52d823a0 00000000 00000000 00000000 52d81a6c [............l..r]52d823b0 00000008 52d81f08 52d81eac 52d81e50 [.......r...rp..r]52d823c0 52d81df4 52d81d98 52d81d3c 52d81ce0 [...r...r<..r...r]52d823d0 52d81c84 00000010 0000014c 00000014 [...r....l.......]52d823e0 00000084 00000016 00000001 52d82060 [............` .r]52d823f0 00000001 00000010 00000158 00000014 [........x.......]52d82400 00000078 0000000a 00000002 52d820c0 [x............ .r]52d82410 00000001 00000010 00000164 00000014 [........d.......]52d82420 0000006c 00000009 00000003 52d82120 [l........... !.r]52d82430 00000001 00000010 00000170 00000014 [........p.......]52d82440 00000054 00000016 00000004 52d82180 [t............!.r]52d82450 00000001 00000010 0000017c 00000014 [........|.......]52d82460 0000004c 00000007 00000005 52d821e0 [l............!.r]52d82470 00000001 00000010 00000188 00000014 [................]52d82480 00000034 00000016 00000006 52d82240 [[email protected]".r]52d82490 00000001 00000010 00000194 00000014 [................]52d824a0 0000001c 00000016 00000007 52d822a0 [.............".r]52d824b0 00000001 00000010 000001a0 00000014 [................]52d824c0 00000004 00000016 00000008 52d82300 [.............#.r]52d824d0 00000001 52d81938 00000004 00000002 [....8..r........]52d824e0 000000bc 00000000 52d81c1c 00000008 [...........r....]52d824f0 00000000 00000000 00000000 00000000 [................]52d82500 00000000 00000000 00000012 02400791 [[email protected]]52d82510 00003f09 00003f09 00030000 00001fe8 [.?...?..........]52d82520 00000000 00000100 3f091826 00000001 [........&..?....]52d82530 00000010 000001ac 00000000 00000000 [................]52d82540 00000000 00000000 00000000 00000000 [................]52d82550 52d823b0 00000010 000001d0 00000017 [.#.r............]52d82560 52d82524 00000001 00003f09 00000000 [$%.r.....?......]52d82570 00000881 00000000 00000000 00000000 [................]52d82580 00000000 00000000 00000000 00000000 [................]52d82590 00000000 00000000 52d823d4 00080000 [.........#.r....]52d825a0 00000008 00000000 00000000 52d82508 [.............%.r]52d825b0 00000000 00000000 00000010 00000270 [............p...]52d825c0 52d823d4 00000008 00000014 0000009c [.#.r............]52d825d0 00000000 00000000 00000000 52d81acf [...............r]52d825e0 00000000 00000000 00000000 00000000 [................] repeat 3 times52d82620 52d8263c 00000010 000006d4 00000010 [<&.r............]52d82630 000006f4 00000010 000006f8 00000010 [................]52d82640 000006fc 00000010 00000714 00000010 [................]52d82650 00000720 00000010 0000072c 00000010 [ .......,.......]52d82660 00000744 00000010 0000074c 00000010 [d.......l.......]52d82670 00000764 00000010 0000077c [d.......|...] permanent space = 3784marks: mark 0x52d8237c******************************************************这里的handle=52d82e58就是sql依赖的对象信息:bucket 63037: library object handle: handle=52d82e58 name=eygle.emp hash=7310f63d timestamp=08-26-2004 10:23:40 namespace=tabl/prcd/type flags=kghp/tim/sml/[02000000] kkkk-dddd-llll=0000-0501-0501 lock=0 pin=0 latch#=1 lwt=0x52d82e70[0x52d82e70,0x52d82e70] ltm=0x52d82e78[0x52d82e78,0x52d82e78] pwt=0x52d82e88[0x52d82e88,0x52d82e88] ptm=0x52d82ee0[0x52d82ee0,0x52d82ee0] ref=0x52d82e60[0x52d82e60, 0x52d82e60] lnd=0x52d82eec[0x52d7dcf0,0x52d89fc8] library object: object=52d81594 type=tabl flags=exs/loc[0005] pflags= [00] status=vald load=0==>type:对象类型,这里是一张表 ==>flags:代表对象状态 data blocks: data# heap pointer status pins change alloc(k) size(k) ----- -------- -------- ------ ---- ------ -------- -------- 0 52d8c1e4 52d8161c i/-/a 0 none 0.66 1.09 8 52d81238 52d80a18 i/-/a 0 none 1.10 1.13 10 52d8129c 52d80ea0 i/-/a 0 none 0.12 0.37 heap dump of data block 0:******************************************************heap dump heap name="library cache" desc=0x52d8c1e4 extent sz=0x224 alt=32767 het=16 rec=9 flg=2 opc=0 parent=0x5000002c owner=0x52d81594 nex=(nil) xsz=0x224 ==>每个heap descriptor 都包含一个owner部分，指向所有者，这里的 52d81594 也就是eygle.emp==>指向的library对象: library object: object=52d81594extent 0 addr=0x52d81220 chunk 52d81228 sz= 540 perm "perm " alo=19652d81220 5000021d 00000000 [...p....]52d81230 52d81584 000000c4 5000002c 00000824 [...r....,..p$...]52d81240 52d81594 52d80a00 52d80a08 00000000 [...r...r...r....]52d81250 00000000 05010200 00000000 00000000 [................]52d81260 534c474b 61656820 00000070 00000000 [kgls heap.......]52d81270 00107fff 7fff7fff 00000401 00000000 [................]52d81280 52d81280 52d81280 52d8129c 00000000 [...r...r...r....]52d81290 52d80ea0 00040000 52ff5c14 5000002c [...r...../.r,..p]52d812a0 00000824 52d81594 52d80e88 52d80e90 [$......r...r...r]52d812b0 00000000 00000000 05010200 00000000 [................]52d812c0 0000015c 534c474b 61656820 00000070 [/...kgls heap...]52d812d0 00000000 00107fff 7fff7fff 00000401 [................]52d812e0 00000000 52d812e4 52d812e4 00000000 [.......r...r....]52d812f0 00000000 00000000 00000000 00000000 [................] repeat 20 times52d81440 00000000 [....] extent 1 addr=0x52d8157c chunk 52d81584 sz= 484 perm "perm " alo=48452d81580 400001e5 00000000 00000000 [[email protected]]52d81590 000001e4 52d82e58 52d81598 52d81598 [....x..r...r...r]52d815a0 52d815a0 52d815a0 00000000 00000000 [...r...r........]52d815b0 00010005 00000000 00000000 00000000 [................]52d815c0 02000000 52d81608 00000000 00000000 [.......r........]52d815d0 00000000 00000000 00000000 00000000 [................]52d815e0 00000000 52d81754 00000000 52d81288 [....t..r.......r]52d815f0 00000000 00000000 00000000 00000000 [................]52d81600 00000000 00000000 52d8c1e4 00000000 [...........r....]52d81610 52d8161c 00000000 52ff5bc4 00000006 [...r.....[.r....]52d81620 00000000 52d81650 00000000 00000000 [....p..r........]52d81630 00003f09 00003f09 00000000 00000000 [.?...?..........]52d81640 00000000 00000000 00000069 00000000 [........i.......]52d81650 20000000 00000001 00080008 00000008 [... ............]52d81660 00000000 2d2d2d2d 2d2d2d2d 2d2d2d2d [....------------]52d81670 2d2d2d2d 2d2d2d2d 2d2d2d2d 2d2d2d2d [----------------]52d81680 2d2d2d2d 00000012 02400791 00000000 [[email protected]]52d81690 00000000 00000000 00000000 00000000 [................] repeat 3 times52d816d0 00000000 0001280a 000000ff 00000000 [.....(..........]52d816e0 40548000 00000001 00000064 00000000 [[email protected]]52d816f0 00000000 00000000 00000000 00000000 [................]52d81700 00000000 00000000 00000000 00000001 [................]52d81710 00000000 00000000 00000001 00000001 [................]52d81720 00000000 00000000 000002e0 00000000 [................]52d81730 00000000 00000000 00000000 00000000 [................]52d81740 ffffffff ffffffff 68780000 180b1a08 [..........xh....]52d81750 00000029 52d81238 00000000 52d80a18 [)...8..r.......r]52d81760 00040000 52ff5bec [.....[.r] chunk 52d81768 sz= 40 free " "52d81760 d0000029 52d81584 [)......r]52d81770 52d8c22c 52d8c22c 00000000 00000000 [,..r,..r........]52d81780 00000000 00000000 00000000 00000000 [................]total heap size = 1064free lists: bucket 0 size=0 chunk 52d81768 sz= 40 free " "52d81760 d0000029 52d81584 [)......r]52d81770 52d8c22c 52d8c22c 00000000 00000000 [,..r,..r........]52d81780 00000000 00000000 00000000 00000000 [................]total free space = 40unpinned recreatable chunks (lru first):permanent chunks: chunk 52d81228 sz= 540 perm "perm " alo=19652d81220 5000021d 00000000 [...p....]52d81230 52d81584 000000c4 5000002c 00000824 [...r....,..p$...]52d81240 52d81594 52d80a00 52d80a08 00000000 [...r...r...r....]52d81250 00000000 05010200 00000000 00000000 [................]52d81260 534c474b 61656820 00000070 00000000 [kgls heap.......]52d81270 00107fff 7fff7fff 00000401 00000000 [................]52d81280 52d81280 52d81280 52d8129c 00000000 [...r...r...r....]52d81290 52d80ea0 00040000 52ff5c14 5000002c [...r...../.r,..p]52d812a0 00000824 52d81594 52d80e88 52d80e90 [$......r...r...r]52d812b0 00000000 00000000 05010200 00000000 [................]52d812c0 0000015c 534c474b 61656820 00000070 [/...kgls heap...]52d812d0 00000000 00107fff 7fff7fff 00000401 [................]52d812e0 00000000 52d812e4 52d812e4 00000000 [.......r...r....]52d812f0 00000000 00000000 00000000 00000000 [................] repeat 20 times52d81440 00000000 [....] chunk 52d81584 sz= 484 perm "perm " alo=48452d81580 400001e5 00000000 00000000 [[email protected]]52d81590 000001e4 52d82e58 52d81598 52d81598 [....x..r...r...r]52d815a0 52d815a0 52d815a0 00000000 00000000 [...r...r........]52d815b0 00010005 00000000 00000000 00000000 [................]52d815c0 02000000 52d81608 00000000 00000000 [.......r........]52d815d0 00000000 00000000 00000000 00000000 [................]52d815e0 00000000 52d81754 00000000 52d81288 [....t..r.......r]52d815f0 00000000 00000000 00000000 00000000 [................]52d81600 00000000 00000000 52d8c1e4 00000000 [...........r....]52d81610 52d8161c 00000000 52ff5bc4 00000006 [...r.....[.r....]52d81620 00000000 52d81650 00000000 00000000 [....p..r........]52d81630 00003f09 00003f09 00000000 00000000 [.?...?..........]52d81640 00000000 00000000 00000069 00000000 [........i.......]52d81650 20000000 00000001 00080008 00000008 [... ............]52d81660 00000000 2d2d2d2d 2d2d2d2d 2d2d2d2d [....------------]52d81670 2d2d2d2d 2d2d2d2d 2d2d2d2d 2d2d2d2d [----------------]52d81680 2d2d2d2d 00000012 02400791 00000000 [[email protected]]52d81690 00000000 00000000 00000000 00000000 [................] repeat 3 times52d816d0 00000000 0001280a 000000ff 00000000 [.....(..........]52d816e0 40548000 00000001 00000064 00000000 [[email protected]]52d816f0 00000000 00000000 00000000 00000000 [................]52d81700 00000000 00000000 00000000 00000001 [................]52d81710 00000000 00000000 00000001 00000001 [................]52d81720 00000000 00000000 000002e0 00000000 [................]52d81730 00000000 00000000 00000000 00000000 [................]52d81740 ffffffff ffffffff 68780000 180b1a08 [..........xh....]52d81750 00000029 52d81238 00000000 52d80a18 [)...8..r.......r]52d81760 00040000 52ff5bec [.....[.r] permanent space = 1024****************************************************** heap dump of data block 8:******************************************************heap dump heap name="kgls heap" desc=0x52d81238 extent sz=0x824 alt=32767 het=16 rec=0 flg=2 opc=5 parent=0x5000002c owner=0x52d81594 nex=(nil) xsz=0x0extent 0 addr=0x52d80a00 chunk 52d80a08 sz= 1124 perm "perm " alo=112452d80a00 50000465 00000000 [e..p....]52d80a10 00000000 00000464 00000000 00000007 [....d...........]52d80a20 00000454 00000000 52d80e00 52d80b0c [t..........r...r]52d80a30 52d80a30 52d80a30 00000000 00000008 [0..r0..r........]52d80a40 00000003 52d80a44 52d80a44 52d80a4c [....d..rd..rl..r]52d80a50 52d80a4c 00000000 00000000 00000023 [l..r........#...]52d80a60 52d80a60 52d80a60 52d80a68 52d80a68 [`..r`..rh..rh..r]52d80a70 00000000 00000000 00000032 52d80a7c [........2...|..r]52d80a80 52d80a7c 52d80a84 52d80a84 00000000 [|..r...r...r....]52d80a90 00000000 00000033 52d80a98 52d80a98 [....3......r...r]52d80aa0 52d80aa0 52d80aa0 00000000 00000000 [...r...r........]52d80ab0 0000002c 52d80ab4 52d80ab4 52d80abc [,......r...r...r]52d80ac0 52d80abc 00000000 00000000 00000035 [...r........5...]52d80ad0 52d80ad0 52d80ad0 52d80ad8 52d80ad8 [...r...r...r...r]52d80ae0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80b00 00000000 00000000 00000000 52d80a28 [............(..r]52d80b10 52d80b78 00000000 45440006 4f4e5450 [x..r......deptno]52d80b20 00000000 00000000 00000000 00000000 [................]52d80b30 00000000 00000000 00080008 00160002 [................]52d80b40 00000200 00000008 00000000 00000000 [................]52d80b50 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80b70 00000000 00000000 52d80b0c 52d80be4 [...........r...r]52d80b80 00000000 4f430004 00004d4d 00000000 [......comm......]52d80b90 00000000 00000000 00000000 00000000 [................]52d80ba0 00000000 00070007 00160002 00020700 [................]52d80bb0 00000007 00000000 00000000 00000000 [................]52d80bc0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80be0 00000000 52d80b78 52d80c50 00000000 [....x..rp..r....]52d80bf0 41530003 0000004c 00000000 00000000 [..sal...........]52d80c00 00000000 00000000 00000000 00000000 [................]52d80c10 00060006 00160002 00020700 00000006 [................]52d80c20 00000000 00000000 00000000 00000000 [................] repeat 2 times52d80c50 52d80be4 52d80cbc 00000000 49480008 [...r...r......hi]52d80c60 41444552 00004554 00000000 00000000 [redate..........]52d80c70 00000000 00000000 00000000 00050005 [................]52d80c80 0007000c 00000000 00000005 00000000 [................]52d80c90 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80cb0 00000000 00000000 00000000 52d80c50 [............p..r]52d80cc0 52d80d28 00000000 474d0003 00000052 [(..r......mgr...]52d80cd0 00000000 00000000 00000000 00000000 [................]52d80ce0 00000000 00000000 00040004 00160002 [................]52d80cf0 00000400 00000004 00000000 00000000 [................]52d80d00 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80d20 00000000 00000000 52d80cbc 52d80d94 [...........r...r]52d80d30 00000000 4f4a0003 00000042 00000000 [......job.......]52d80d40 00000000 00000000 00000000 00000000 [................]52d80d50 00000000 00030003 00090001 00000000 [................]52d80d60 00000003 00000000 00010354 00090000 [........t.......]52d80d70 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80d90 00000000 52d80d28 52d80e00 00000000 [....(..r...r....]52d80da0 4e450005 00454d41 00000000 00000000 [..ename.........]52d80db0 00000000 00000000 00000000 00000000 [................]52d80dc0 00020002 000a0001 00000000 00000002 [................]52d80dd0 00000000 00010354 000a0000 00000000 [....t...........]52d80de0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80e00 52d80d94 52d80a28 00000000 4d450005 [...r(..r......em]52d80e10 004f4e50 00000000 00000000 00000000 [pno.............]52d80e20 00000000 00000000 00000000 00010001 [................]52d80e30 00160002 00000400 00000001 00000000 [................]52d80e40 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80e60 00000000 00000000 00000000 [............] total heap size = 1124free lists: bucket 0 size=0total free space = 0unpinned recreatable chunks (lru first):permanent chunks: chunk 52d80a08 sz= 1124 perm "perm " alo=112452d80a00 50000465 00000000 [e..p....]52d80a10 00000000 00000464 00000000 00000007 [....d...........]52d80a20 00000454 00000000 52d80e00 52d80b0c [t..........r...r]52d80a30 52d80a30 52d80a30 00000000 00000008 [0..r0..r........]52d80a40 00000003 52d80a44 52d80a44 52d80a4c [....d..rd..rl..r]52d80a50 52d80a4c 00000000 00000000 00000023 [l..r........#...]52d80a60 52d80a60 52d80a60 52d80a68 52d80a68 [`..r`..rh..rh..r]52d80a70 00000000 00000000 00000032 52d80a7c [........2...|..r]52d80a80 52d80a7c 52d80a84 52d80a84 00000000 [|..r...r...r....]52d80a90 00000000 00000033 52d80a98 52d80a98 [....3......r...r]52d80aa0 52d80aa0 52d80aa0 00000000 00000000 [...r...r........]52d80ab0 0000002c 52d80ab4 52d80ab4 52d80abc [,......r...r...r]52d80ac0 52d80abc 00000000 00000000 00000035 [...r........5...]52d80ad0 52d80ad0 52d80ad0 52d80ad8 52d80ad8 [...r...r...r...r]52d80ae0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80b00 00000000 00000000 00000000 52d80a28 [............(..r]52d80b10 52d80b78 00000000 45440006 4f4e5450 [x..r......deptno]52d80b20 00000000 00000000 00000000 00000000 [................]52d80b30 00000000 00000000 00080008 00160002 [................]52d80b40 00000200 00000008 00000000 00000000 [................]52d80b50 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80b70 00000000 00000000 52d80b0c 52d80be4 [...........r...r]52d80b80 00000000 4f430004 00004d4d 00000000 [......comm......]52d80b90 00000000 00000000 00000000 00000000 [................]52d80ba0 00000000 00070007 00160002 00020700 [................]52d80bb0 00000007 00000000 00000000 00000000 [................]52d80bc0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80be0 00000000 52d80b78 52d80c50 00000000 [....x..rp..r....]52d80bf0 41530003 0000004c 00000000 00000000 [..sal...........]52d80c00 00000000 00000000 00000000 00000000 [................]52d80c10 00060006 00160002 00020700 00000006 [................]52d80c20 00000000 00000000 00000000 00000000 [................] repeat 2 times52d80c50 52d80be4 52d80cbc 00000000 49480008 [...r...r......hi]52d80c60 41444552 00004554 00000000 00000000 [redate..........]52d80c70 00000000 00000000 00000000 00050005 [................]52d80c80 0007000c 00000000 00000005 00000000 [................]52d80c90 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80cb0 00000000 00000000 00000000 52d80c50 [............p..r]52d80cc0 52d80d28 00000000 474d0003 00000052 [(..r......mgr...]52d80cd0 00000000 00000000 00000000 00000000 [................]52d80ce0 00000000 00000000 00040004 00160002 [................]52d80cf0 00000400 00000004 00000000 00000000 [................]52d80d00 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80d20 00000000 00000000 52d80cbc 52d80d94 [...........r...r]52d80d30 00000000 4f4a0003 00000042 00000000 [......job.......]52d80d40 00000000 00000000 00000000 00000000 [................]52d80d50 00000000 00030003 00090001 00000000 [................]52d80d60 00000003 00000000 00010354 00090000 [........t.......]52d80d70 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80d90 00000000 52d80d28 52d80e00 00000000 [....(..r...r....]52d80da0 4e450005 00454d41 00000000 00000000 [..ename.........]52d80db0 00000000 00000000 00000000 00000000 [................]52d80dc0 00020002 000a0001 00000000 00000002 [................]52d80dd0 00000000 00010354 000a0000 00000000 [....t...........]52d80de0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80e00 52d80d94 52d80a28 00000000 4d450005 [...r(..r......em]52d80e10 004f4e50 00000000 00000000 00000000 [pno.............]52d80e20 00000000 00000000 00000000 00010001 [................]52d80e30 00160002 00000400 00000001 00000000 [................]52d80e40 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80e60 00000000 00000000 00000000 [............] permanent space = 1124****************************************************** heap dump of data block 10:******************************************************heap dump heap name="kgls heap" desc=0x52d8129c extent sz=0x824 alt=32767 het=16 rec=0 flg=2 opc=5 parent=0x5000002c owner=0x52d81594 nex=(nil) xsz=0x15cextent 0 addr=0x52d80e88 chunk 52d80e90 sz= 340 perm "perm " alo=12052d80e90 50000155 00000000 00000000 00000078 [u..p........x...]52d80ea0 00000000 00000002 00000068 00000004 [........h.......]52d80eb0 52d80eb0 52d80eb0 52d80eb8 52d80eb8 [...r...r...r...r]52d80ec0 00000000 00000000 00000005 52d80ecc [...............r]52d80ed0 52d80ecc 52d80ed4 52d80ed4 00000000 [...r...r...r....]52d80ee0 00000000 00000000 00000000 00000000 [................] repeat 15 times52d80fe0 00000000 [....] total heap size = 340free lists: bucket 0 size=0total free space = 0unpinned recreatable chunks (lru first):permanent chunks: chunk 52d80e90 sz= 340 perm "perm " alo=12052d80e90 50000155 00000000 00000000 00000078 [u..p........x...]52d80ea0 00000000 00000002 00000068 00000004 [........h.......]52d80eb0 52d80eb0 52d80eb0 52d80eb8 52d80eb8 [...r...r...r...r]52d80ec0 00000000 00000000 00000005 52d80ecc [...............r]52d80ed0 52d80ecc 52d80ed4 52d80ed4 00000000 [...r...r...r....]52d80ee0 00000000 00000000 00000000 00000000 [................] repeat 15 times52d80fe0 00000000 [....] permanent space = 340****************************************************** bucket 63037 total object count=1
thursday, 2004-09-02 23:33 eygle
我们进一步来讨论一下shared pool的处理:
先进行相应查询，获得测试数据:
[[email protected] udump]$ sqlplus "/ as sysdba"sql*plus: release 9.2.0.3.0 - production on thu aug 26 10:21:54 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.3.0 - productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.3.0 - productionsql> connect eygle/eygleconnected.sql> create table emp as select * from scott.emp;table created.sql> sql> connect / as sysdbaconnected.sql> startup force;oracle instance started.total system global area 47256168 bytesfixed size 451176 bytesvariable size 29360128 bytesdatabase buffers 16777216 bytesredo buffers 667648 bytesdatabase mounted.database opened.sql> set linesize 120sql> connect scott/tigerconnected.sql> select * from emp; empno ename job mgr hiredate sal comm deptno---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 smith clerk 7902 17-dec-80 800 20 8888 eygle manager 11-aug-04 9999 10 10 7566 jones manager 7839 02-apr-81 2975 20 7698 blake manager 7839 01-may-81 2850 30 7782 clark manager 7839 09-jun-81 2450 10 7788 scott analyst 7566 19-apr-87 3000 20 7839 king president 17-nov-81 5000 10 7876 adams clerk 7788 23-may-87 1100 20 7900 james clerk 7698 03-dec-81 950 30 7902 ford analyst 7566 03-dec-81 3000 20 7934 miller clerk 7782 23-jan-82 1300 1011 rows selected.sql> connect eygle/eygleconnected.sql> select * from emp; empno ename job mgr hiredate sal comm deptno---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 smith clerk 7902 17-dec-80 800 20 8888 eygle manager 11-aug-04 9999 10 10 7566 jones manager 7839 02-apr-81 2975 20 7698 blake manager 7839 01-may-81 2850 30 7782 clark manager 7839 09-jun-81 2450 10 7788 scott analyst 7566 19-apr-87 3000 20 7839 king president 17-nov-81 5000 10 7876 adams clerk 7788 23-may-87 1100 20 7900 james clerk 7698 03-dec-81 950 30 7902 ford analyst 7566 03-dec-81 3000 20 7934 miller clerk 7782 23-jan-82 1300 1011 rows selected.sql> select sql_text,version_count,hash_value,to_char(hash_value,'xxxxxxxxxx') hex,address 2 from v$sqlarea where sql_text like 'select * from emp%';sql_text version_count hash_value hex address-------------------- ------------- ---------- ----------- --------select * from emp 2 2648707557 9de011e5 52d9ea28sql> select sql_text,username,address,hash_value,to_char(hash_value,'xxxxxxxxxx') hex_hash_value,child_number,child_latch 2 from v$sql a,dba_users b where a.parsing_user_id = b.user_id and sql_text like 'select * from emp%';sql_text username address hash_value hex_hash_va child_number child_latch-------------------- ------------------------------ -------- ---------- ----------- ------------ -----------select * from emp scott 52d9ea28 2648707557 9de011e5 0 1select * from emp eygle 52d9ea28 2648707557 9de011e5 1 1注意:这里我们可以看出v$sqlarea和v$sql两个视图的不同之处v$sql中为每一条sql保留一个条目，而v$sqlarea中根据sql_text进行group by,通过version_count计算子指针的个数.我们注意到,这两条sql语句因为其代码完全相同,所以其address,hash_value也完全相同.这就意味着,这两条sql语句在shared pool中的存储位置是相同的(尽管其执行计划可能不同),代码得以共享.在此过程中oracle完成sql解析的第一个步骤:语法解析oracle进行语法检查时遵循自右向左,自下向上的原则,如果发现语法错误就马上返回错误.语法检查通过以后,oracle将sql文本转换为相应的ascii数值,然后根据数值通过hash函数计算其hash_value在shared pool中寻找是否存在相同的sql语句,如果存在,则进入下一步骤;如果不存在则尝试获取shared pool latch请求内存,存储该sql代码在这里有一个问题需要说明一下:因为大小写字母的ascii值是不同的,所以oracle会把大小写不同的代码作为不同的sql来处理,我们看一下测试:sql> select * from scott.dept; deptno dname loc---------- -------------- ------------- 10 accounting new york 20 research dallas 30 sales chicago 40 operations bostonsql> select * from scott.dept; deptno dname loc---------- -------------- ------------- 10 accounting new york 20 research dallas 30 sales chicago 40 operations bostonsql> col sql_text for a30sql> select sql_text,hash_value from v$sql where sql_text like 'select * from scott%';sql_text hash_value------------------------------ ----------select * from scott.dept 4096614922select * from scott.dept 2089404358我们注意到,仅只大小写的不同使得原本相同的sql语句变成了两条"不同的代码"所以从这里我们可以看出,sql的规范编写非常重要.完成这一个步骤以后,oracle需要进行的是语义分析:在此步骤中,oracle需要验证对象是否存在,相关用户是否具有权限,引用的是否是相同的对象...对于我们第一个查询,实际上emp表来自不同的用户,那么sql的执行计划也就不同了当然影响sql执行计划的因素还有很多,包括优化器模式等sql> select a.*,to_char(to_hash,'xxxxxxxxxx') hex_hash_value 2 from v$object_dependency a where to_name='emp';from_add from_hash to_owner to_name to_addre to_hash to_type hex_hash_va-------- ---------- -------------------- -------------------- -------- ---------- ---------- -----------52d9ea28 2648707557 scott emp 52d9debc 828228010 2 315dc1aa52d9ea28 2648707557 eygle emp 52d82e58 1930491453 2 7310f63dsql> alter session set events 'immediate trace name library_cache level 1';session altered.sql> alter session set events 'immediate trace name library_cache level 2';session altered.sql> alter session set events 'immediate trace name library_cache level 4';session altered.sql> alter session set events 'immediate trace name library_cache level 8';session altered.sql> alter session set events 'immediate trace name library_cache level 16';session altered.sql> alter session set events 'immediate trace name library_cache level 32';session altered.sql> alter session set events 'immediate trace name library_cache level 100';session altered.
此处在不同级别对shared pool进行转储.
在转向trace文件之前,我们通过下图来看一下library cache的结构:
library cache handle指向library cache object,含对象名,namespace,时间戳,引用列表,锁定对象及pin对象列表等.
我们从dump文件中看看具体的信息,由以上v$sql视图我们得到以上查询的hash_value为9de011e5，address为52d9ea28
在bucket 4851中,我们找到了select * from emp 这条sql语句.
bucket 4581: library object handle: handle=52d9ea28 name=select * from emp hash=9de011e5 timestamp=08-26-2004 10:24:43 ==>这个hash正是v$sql中该sql语句的hash_value值 namespace=crsr flags=ron/tim/pn0/sml/[12010000] kkkk-dddd-llll=0000-0001-0001 lock=0 pin=0 latch#=1 lwt=0x52d9ea40[0x52d9ea40,0x52d9ea40] ltm=0x52d9ea48[0x52d9ea48,0x52d9ea48] pwt=0x52d9ea58[0x52d9ea58,0x52d9ea58] ptm=0x52d9eab0[0x52d9eab0,0x52d9eab0] ref=0x52d9ea30[0x52d9ea30, 0x52d9ea30] lnd=0x52d9eabc[0x52d9eabc,0x52d9eabc] library object: object=52d9e7b0 type=crsr flags=exs[0001] pflags= [00] status=vald load=0 children: size=16 child# table reference handle ------ -------- --------- -------- 0 52d9e96c 52d9e6cc 52d9e4ac 1 52d9e96c 52d9e70c 52d885cc==>这就是我们前边提到过的子指针,每个都指向了一个不同的handle data blocks: data# heap pointer status pins change alloc(k) size(k) ----- -------- -------- ------ ---- ------ -------- -------- 0 52d9e9b8 52d9e838 i/-/a 0 none 0.86 1.09 ==>此处的heap就是指内存地址. ==>这里存放的就是sql代码及用户连接信息 heap dump of data block 0:******************************************************heap dump heap name="library cache" desc=0x52d9e9b8 extent sz=0x224 alt=32767 het=16 rec=9 flg=2 opc=0 parent=0x5000002c owner=0x52d9e7b0 nex=(nil) xsz=0x224extent 0 addr=0x52d9e558 chunk 52d9e560 sz= 540 perm "perm " alo=44852d9e560 5000021d 00000000 52d9e7a0 000001c0 [...p.......r....]52d9e570 52d9e704 52d9e660 00020002 52d9e57c [...r`..r....|..r]52d9e580 52d9e57c 00000000 52d9e588 52d9e588 [|..r.......r...r]52d9e590 00000000 52d9e594 52d9e594 00000000 [.......r...r....]52d9e5a0 52d9e5a0 52d9e5a0 00000000 52d9e5ac [...r...r.......r]52d9e5b0 52d9e5ac 00000000 52d9e5b8 52d9e5b8 [...r.......r...r]52d9e5c0 00000000 52d9e5c4 52d9e5c4 00000000 [.......r...r....]52d9e5d0 52d9e5d0 52d9e5d0 00000000 52d9e5dc [...r...r.......r]52d9e5e0 52d9e5dc 00000000 52d9e5e8 52d9e5e8 [...r.......r...r]52d9e5f0 00000000 52d9e5f4 52d9e5f4 00000000 [.......r...r....]52d9e600 52d9e600 52d9e600 00000000 52d9e60c [...r...r.......r]52d9e610 52d9e60c 00000000 52d9e618 52d9e618 [...r.......r...r]52d9e620 00000000 52d9e624 52d9e624 00000000 [....$..r$..r....]52d9e630 52d9e630 52d9e630 00040004 00000000 [0..r0..r........]52d9e640 52d9e6e4 00000018 00000000 00000000 [...r............]52d9e650 00000000 00000000 52d9e63c 00000000 [........<..r....]52d9e660 52d9e570 52d9e704 00000000 00000000 [p..r...r........]52d9e670 00000000 52d9e6bc 00000010 00000004 [.......r........]52d9e680 00000000 00000000 00000000 00000000 [................] repeat 2 times52d9e6b0 00000000 00000000 00000000 52d9e96c [............l..r]52d9e6c0 00000000 00000000 00000000 52d9e4b4 [...............r]52d9e6d0 52d9e4b4 52d9e4ac 00000000 00000002 [...r...r........]52d9e6e0 00000000 00000000 00010018 00000001 [................]52d9e6f0 00000000 00000000 00000000 52d9e6e0 [...............r]52d9e700 00000000 52d9e660 52d9e570 52d885d4 [....`..rp..r...r]52d9e710 52d885d4 52d885cc 00000000 00000002 [...r...r........]52d9e720 00000000 00000000 00000000 00000000 [................] repeat 4 times52d9e770 00000000 00000000 00000000 [............] extent 1 addr=0x52d9e798 chunk 52d9e7a0 sz= 360 perm "perm " alo=36052d9e7a0 40000169 00000000 00000000 00000168 [[email protected]]52d9e7b0 52d9ea28 52d9e7b4 52d9e7b4 52d9e7bc [(..r...r...r...r]52d9e7c0 52d9e7bc 52d9e668 00000000 00010001 [...rh..r........]52d9e7d0 00000000 00000000 00000000 00000000 [................]52d9e7e0 52d9e824 00000000 00000000 00000000 [$..r............]52d9e7f0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d9e820 00000000 52d9e9b8 00000000 52d9e838 [.......r....8..r]52d9e830 00000000 52ff79a4 00080304 00000000 [.....y.r........]52d9e840 00000100 00000000 00000000 00000010 [................]52d9e850 00000004 00000000 00000000 00000000 [................]52d9e860 00000000 52d9e640 00000002 2a4c5153 [[email protected]*]52d9e870 73756c50 706d756a 682e7265 61727275 [plusjumper.hurra]52d9e880 6f632e79 6e632e6d 4e542820 31562053 [y.com.cn (tns v1]52d9e890 2933562d 00000000 00000000 00000008 [-v3)............]52d9e8a0 dabefa60 00000000 00000000 00000000 [`...............]52d9e8b0 00000000 00000000 00000000 00000000 [................]52d9e8c0 00000000 00000000 f0318558 52d9e8d8 [........x.1....r]52d9e8d0 52d9e630 00000000 52d9e570 00000000 [0..r....p..r....]52d9e8e0 00000000 00000000 00000000 00000000 [................]52d9e8f0 00000000 00000000 00000002 0000000d [................]52d9e900 00000001 00000000 [........] chunk 52d9e908 sz= 88 free " "52d9e900 c0000059 52d9e7a0 [y......r]52d9e910 52d9ea00 52d9ea00 00000000 00000000 [...r...r........]52d9e920 00000000 00000000 00000000 00000000 [................] repeat 3 times chunk 52d9e960 sz= 76 freeable "kgltbtab "52d9e960 1000004d 52d9e908 0a857928 52d9e6cc [m......r(y.....r]52d9e970 52d9e70c 00000000 00000000 00000000 [...r............]52d9e980 00000000 00000000 00000000 00000000 [................] repeat 1 times52d9e9a0 00000000 00000000 00000000 [............] total heap size = 1064free lists: bucket 0 size=0 chunk 52d9e908 sz= 88 free " "52d9e900 c0000059 52d9e7a0 [y......r]52d9e910 52d9ea00 52d9ea00 00000000 00000000 [...r...r........]52d9e920 00000000 00000000 00000000 00000000 [................] repeat 3 timestotal free space = 88unpinned recreatable chunks (lru first):permanent chunks: chunk 52d9e560 sz= 540 perm "perm " alo=44852d9e560 5000021d 00000000 52d9e7a0 000001c0 [...p.......r....]52d9e570 52d9e704 52d9e660 00020002 52d9e57c [...r`..r....|..r]52d9e580 52d9e57c 00000000 52d9e588 52d9e588 [|..r.......r...r]52d9e590 00000000 52d9e594 52d9e594 00000000 [.......r...r....]52d9e5a0 52d9e5a0 52d9e5a0 00000000 52d9e5ac [...r...r.......r]52d9e5b0 52d9e5ac 00000000 52d9e5b8 52d9e5b8 [...r.......r...r]52d9e5c0 00000000 52d9e5c4 52d9e5c4 00000000 [.......r...r....]52d9e5d0 52d9e5d0 52d9e5d0 00000000 52d9e5dc [...r...r.......r]52d9e5e0 52d9e5dc 00000000 52d9e5e8 52d9e5e8 [...r.......r...r]52d9e5f0 00000000 52d9e5f4 52d9e5f4 00000000 [.......r...r....]52d9e600 52d9e600 52d9e600 00000000 52d9e60c [...r...r.......r]52d9e610 52d9e60c 00000000 52d9e618 52d9e618 [...r.......r...r]52d9e620 00000000 52d9e624 52d9e624 00000000 [....$..r$..r....]52d9e630 52d9e630 52d9e630 00040004 00000000 [0..r0..r........]52d9e640 52d9e6e4 00000018 00000000 00000000 [...r............]52d9e650 00000000 00000000 52d9e63c 00000000 [........<..r....]52d9e660 52d9e570 52d9e704 00000000 00000000 [p..r...r........]52d9e670 00000000 52d9e6bc 00000010 00000004 [.......r........]52d9e680 00000000 00000000 00000000 00000000 [................] repeat 2 times52d9e6b0 00000000 00000000 00000000 52d9e96c [............l..r]52d9e6c0 00000000 00000000 00000000 52d9e4b4 [...............r]52d9e6d0 52d9e4b4 52d9e4ac 00000000 00000002 [...r...r........]52d9e6e0 00000000 00000000 00010018 00000001 [................]52d9e6f0 00000000 00000000 00000000 52d9e6e0 [...............r]52d9e700 00000000 52d9e660 52d9e570 52d885d4 [....`..rp..r...r]52d9e710 52d885d4 52d885cc 00000000 00000002 [...r...r........]52d9e720 00000000 00000000 00000000 00000000 [................] repeat 4 times52d9e770 00000000 00000000 00000000 [............] chunk 52d9e7a0 sz= 360 perm "perm " alo=36052d9e7a0 40000169 00000000 00000000 00000168 [[email protected]]52d9e7b0 52d9ea28 52d9e7b4 52d9e7b4 52d9e7bc [(..r...r...r...r]52d9e7c0 52d9e7bc 52d9e668 00000000 00010001 [...rh..r........]52d9e7d0 00000000 00000000 00000000 00000000 [................]52d9e7e0 52d9e824 00000000 00000000 00000000 [$..r............]52d9e7f0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d9e820 00000000 52d9e9b8 00000000 52d9e838 [.......r....8..r]52d9e830 00000000 52ff79a4 00080304 00000000 [.....y.r........]52d9e840 00000100 00000000 00000000 00000010 [................]52d9e850 00000004 00000000 00000000 00000000 [................]52d9e860 00000000 52d9e640 00000002 2a4c5153 [[email protected]*]52d9e870 73756c50 706d756a 682e7265 61727275 [plusjumper.hurra]52d9e880 6f632e79 6e632e6d 4e542820 31562053 [y.com.cn (tns v1]52d9e890 2933562d 00000000 00000000 00000008 [-v3)............]52d9e8a0 dabefa60 00000000 00000000 00000000 [`...............]52d9e8b0 00000000 00000000 00000000 00000000 [................]52d9e8c0 00000000 00000000 f0318558 52d9e8d8 [........x.1....r]52d9e8d0 52d9e630 00000000 52d9e570 00000000 [0..r....p..r....]52d9e8e0 00000000 00000000 00000000 00000000 [................]52d9e8f0 00000000 00000000 00000002 0000000d [................]52d9e900 00000001 00000000 [........] permanent space = 900****************************************************** bucket 4581 total object count=1 我们以handle:52d885cc为例看一下library cache object的结构:****************************************************** library object handle: handle=52d885cc namespace=crsr flags=ron/kghp/pn0/[10010000] kkkk-dddd-llll=0000-0041-0041 lock=0 pin=0 latch#=1 lwt=0x52d885e4[0x52d885e4,0x52d885e4] ltm=0x52d885ec[0x52d885ec,0x52d885ec] pwt=0x52d885fc[0x52d885fc,0x52d885fc] ptm=0x52d88654[0x52d88654,0x52d88654] ref=0x52d885d4[0x52d9e70c, 0x52d9e70c] lnd=0x52d88660[0x52d88660,0x52d88660] library object: object=52d82a24 type=crsr flags=exs[0001] pflags= [00] status=vald load=0 dependencies: count=1 size=16 dependency# table reference handle position flags ----------- -------- --------- -------- -------- ------------------- 0 52d82be0 52d82b20 52d82e58 14 dep[01] ==>在dependency部分我们看到,这个cursor依赖的对象handle: 52d82e58==>这个handle指向的就是eygle.emp表，如果以上两个crsr访问的是同一个对象,那么==>这两个sql才会是真的共享.这里我们的sql虽然是相同的，访问的却是不同用户的数据表==>子指针的概念就出来了.==>在这里我们看到52d82e58指向的是eygle.emp这个对象,也就是eygle所查询的数据表. accesses: count=1 size=16 dependency# types ----------- ----- 0 0009 translations: count=1 size=16 original final -------- -------- 52d82e58 52d82e58 data blocks: data# heap pointer status pins change alloc(k) size(k) ----- -------- -------- ------ ---- ------ -------- -------- 0 52d8c244 52d827e4 i/-/a 0 none 1.09 1.64 6 52d82ac0 52d817c4 i/-/a 0 none 3.70 3.73 ==>这里的data blocks是个重要的部分==>每个控制块包含一个heap descriptor,指向相应的heap memory,这个heap memory包含的就是==>diana tree,p-code,source code,shared cursor context area等重要数据,也就是我们通常==>所说的，解析过的sql及执行计划树,真正到这里以后,sql才得以共享.也就真正的避免了硬==>解析 heap dump of data block 0:****************************************************** heap dump heap name="library cache" desc=0x52d8c244 extent sz=0x224 alt=32767 het=16 rec=9 flg=2 opc=0 parent=0x5000002c owner=0x52d82a24 nex=(nil) xsz=0x224extent 0 addr=0x52d80ff0 chunk 52d80ff8 sz= 464 free " "52d80ff0 c00001d1 00000000 [........]52d81000 52d8c28c 52d8c28c 00000000 00000000 [...r...r........]52d81010 00000000 00000000 00000000 00000000 [................] repeat 26 times52d811c0 00000000 00000000 [........] chunk 52d811c8 sz= 76 freeable "kgltbtab "52d811c0 1000004d 52d80ff8 [m......r]52d811d0 0a857928 52d82b68 00000000 00000000 [(y..h+.r........]52d811e0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d81210 00000000 [....] extent 1 addr=0x52d827cc chunk 52d827d4 sz= 540 perm "perm " alo=53252d827d0 5000021d 00000000 52d82a14 [...p.....*.r]52d827e0 00000214 00000000 0000001a 00000069 [............i...]52d827f0 00000110 00000000 00000000 00000006 [................]52d82800 00000850 00000010 00000008 00000005 [p...............]52d82810 00000005 4c475945 00000045 00000000 [....eygle.......]52d82820 00000000 00000000 00000000 00000000 [................]52d82830 00050000 52d82970 00000000 00000000 [....p).r........]52d82840 00000069 4c475945 00000045 00000000 [i...eygle.......]52d82850 00000000 00000000 00000000 00000000 [................]52d82860 00050000 00000001 00000004 00000019 [................]52d82870 0000000b 00000000 00000002 00000001 [................]52d82880 00002dc7 00000000 000030a4 00000000 [.-.......0......]52d82890 00000000 04000000 00000000 00650000 [..............e.]52d828a0 00100000 00050001 01050100 00000001 [................]52d828b0 000007d0 00640000 00010000 01000000 [......d.........]52d828c0 00000404 00000000 01010101 01010001 [................]52d828d0 01010101 00010001 01010101 00000000 [................]52d828e0 00000202 02010000 01010100 01010101 [................]52d828f0 00000000 01000001 00000000 00000000 [................]52d82900 00000000 00000000 00000000 1a086878 [............xh..]52d82910 0036190b 00000000 000001c4 00000000 [..6.............]52d82920 00000000 00000000 00000000 00000000 [................] repeat 1 times52d82940 00022000 00000000 0000ffff ffffffff [. ..............]52d82950 00000000 00000000 00000000 1a086878 [............xh..]52d82960 0036190b 00000000 00000000 00000000 [..6.............]52d82970 00000001 00000069 00000077 00000002 [....i...w.......]52d82980 00000003 52d829d8 00010010 00000004 [.....).r........]52d82990 00000000 00000000 00000000 00000000 [................]52d829a0 00000000 00000000 52d82b58 00010010 [........x+.r....]52d829b0 00000004 52d82b40 00010010 00000004 [[email protected]+.r........]52d829c0 00000000 00000000 00000000 00000000 [................]52d829d0 00000000 00000000 52d82be0 00000000 [.........+.r....]52d829e0 00000000 00000000 00000000 00000000 [................]extent 2 addr=0x52d82a0c chunk 52d82a14 sz= 252 perm "perm " alo=25252d82a10 400000fd 00000000 00000000 [[email protected]]52d82a20 000000fc 52d885cc 52d82a28 52d82a28 [.......r(*.r(*.r]52d82a30 52d82a30 52d82a30 52d82984 00000000 [0*.r0*.r.).r....]52d82a40 00010001 00000000 00000000 00000000 [................]52d82a50 00000000 52d82a98 00000000 00000000 [.....*.r........]52d82a60 00000000 00000000 00000000 52d82aac [.............*.r]52d82a70 00000000 00000000 00000000 00000000 [................] repeat 1 times52d82a90 00000000 00000000 52d8c244 00000000 [........d..r....]52d82aa0 52d827e4 00000000 52ff5b74 52d82ac0 [.'.r....t[.r.*.r]52d82ab0 00000000 52d817c4 00040000 52ff5b9c [.......r.....[.r]52d82ac0 5000002c 00001024 52d82a24 52d817ac [,..p$...$*.r...r]52d82ad0 52d817b4 00000000 52d8237c 05010200 [...r....|#.r....]52d82ae0 00000000 00000000 206c7173 61657261 [........sql area]52d82af0 00000000 00000000 00107fff 7fff7fff [................]52d82b00 00000401 00000000 52d82b08 52d82b08 [.........+.r.+.r] chunk 52d82b10 sz= 120 perm "perm " alo=10452d82b10 40000079 52d82a14 52d827d4 00000068 [[email protected]*.r.'.rh...]52d82b20 52b2d470 52b2d470 52d82e58 00000000 [p..rp..rx..r....]52d82b30 00000001 52d82a24 0000000e 00000001 [....$*.r........]52d82b40 52d82b94 00000000 00000000 00000000 [.+.r............]52d82b50 52d82e58 52d82e58 52d811d4 00000000 [x..rx..r...r....]52d82b60 00000000 00000000 00000000 00000000 [................]52d82b70 02000000 00000000 00000000 00000000 [................]52d82b80 00000000 00000000 [........] chunk 52d82b88 sz= 76 freeable "kgltbtab "52d82b80 0000004d 52d82b10 [m....+.r]52d82b90 0a857928 52d82b50 00000000 00000000 [(y..p+.r........]52d82ba0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82bd0 00000000 [....] chunk 52d82bd4 sz= 76 freeable "kgltbtab "52d82bd0 1000004d 52d82b88 0a857928 [m....+.r(y..]52d82be0 52d82b20 00000000 00000000 00000000 [ +.r............]52d82bf0 00000000 00000000 00000000 00000000 [................] repeat 2 timestotal heap size = 1604free lists: bucket 0 size=0 chunk 52d80ff8 sz= 464 free " "52d80ff0 c00001d1 00000000 [........]52d81000 52d8c28c 52d8c28c 00000000 00000000 [...r...r........]52d81010 00000000 00000000 00000000 00000000 [................] repeat 26 times52d811c0 00000000 00000000 [........] total free space = 464unpinned recreatable chunks (lru first):permanent chunks: chunk 52d82b10 sz= 120 perm "perm " alo=10452d82b10 40000079 52d82a14 52d827d4 00000068 [[email protected]*.r.'.rh...]52d82b20 52b2d470 52b2d470 52d82e58 00000000 [p..rp..rx..r....]52d82b30 00000001 52d82a24 0000000e 00000001 [....$*.r........]52d82b40 52d82b94 00000000 00000000 00000000 [.+.r............]52d82b50 52d82e58 52d82e58 52d811d4 00000000 [x..rx..r...r....]52d82b60 00000000 00000000 00000000 00000000 [................]52d82b70 02000000 00000000 00000000 00000000 [................]52d82b80 00000000 00000000 [........] chunk 52d827d4 sz= 540 perm "perm " alo=53252d827d0 5000021d 00000000 52d82a14 [...p.....*.r]52d827e0 00000214 00000000 0000001a 00000069 [............i...]52d827f0 00000110 00000000 00000000 00000006 [................]52d82800 00000850 00000010 00000008 00000005 [p...............]52d82810 00000005 4c475945 00000045 00000000 [....eygle.......]52d82820 00000000 00000000 00000000 00000000 [................]52d82830 00050000 52d82970 00000000 00000000 [....p).r........]52d82840 00000069 4c475945 00000045 00000000 [i...eygle.......]52d82850 00000000 00000000 00000000 00000000 [................]52d82860 00050000 00000001 00000004 00000019 [................]52d82870 0000000b 00000000 00000002 00000001 [................]52d82880 00002dc7 00000000 000030a4 00000000 [.-.......0......]52d82890 00000000 04000000 00000000 00650000 [..............e.]52d828a0 00100000 00050001 01050100 00000001 [................]52d828b0 000007d0 00640000 00010000 01000000 [......d.........]52d828c0 00000404 00000000 01010101 01010001 [................]52d828d0 01010101 00010001 01010101 00000000 [................]52d828e0 00000202 02010000 01010100 01010101 [................]52d828f0 00000000 01000001 00000000 00000000 [................]52d82900 00000000 00000000 00000000 1a086878 [............xh..]52d82910 0036190b 00000000 000001c4 00000000 [..6.............]52d82920 00000000 00000000 00000000 00000000 [................] repeat 1 times52d82940 00022000 00000000 0000ffff ffffffff [. ..............]52d82950 00000000 00000000 00000000 1a086878 [............xh..]52d82960 0036190b 00000000 00000000 00000000 [..6.............]52d82970 00000001 00000069 00000077 00000002 [....i...w.......]52d82980 00000003 52d829d8 00010010 00000004 [.....).r........]52d82990 00000000 00000000 00000000 00000000 [................]52d829a0 00000000 00000000 52d82b58 00010010 [........x+.r....]52d829b0 00000004 52d82b40 00010010 00000004 [[email protected]+.r........]52d829c0 00000000 00000000 00000000 00000000 [................]52d829d0 00000000 00000000 52d82be0 00000000 [.........+.r....]52d829e0 00000000 00000000 00000000 00000000 [................] chunk 52d82a14 sz= 252 perm "perm " alo=25252d82a10 400000fd 00000000 00000000 [[email protected]]52d82a20 000000fc 52d885cc 52d82a28 52d82a28 [.......r(*.r(*.r]52d82a30 52d82a30 52d82a30 52d82984 00000000 [0*.r0*.r.).r....]52d82a40 00010001 00000000 00000000 00000000 [................]52d82a50 00000000 52d82a98 00000000 00000000 [.....*.r........]52d82a60 00000000 00000000 00000000 52d82aac [.............*.r]52d82a70 00000000 00000000 00000000 00000000 [................] repeat 1 times52d82a90 00000000 00000000 52d8c244 00000000 [........d..r....]52d82aa0 52d827e4 00000000 52ff5b74 52d82ac0 [.'.r....t[.r.*.r]52d82ab0 00000000 52d817c4 00040000 52ff5b9c [.......r.....[.r]52d82ac0 5000002c 00001024 52d82a24 52d817ac [,..p$...$*.r...r]52d82ad0 52d817b4 00000000 52d8237c 05010200 [...r....|#.r....]52d82ae0 00000000 00000000 206c7173 61657261 [........sql area]52d82af0 00000000 00000000 00107fff 7fff7fff [................]52d82b00 00000401 00000000 52d82b08 52d82b08 [.........+.r.+.r]permanent space = 912****************************************************** heap dump of data block 6:******************************************************heap dump heap name="sql area" desc=0x52d82ac0 extent sz=0x1024 alt=32767 het=16 rec=0 flg=2 opc=5 parent=0x5000002c owner=0x52d82a24 nex=(nil) xsz=0x0extent 0 addr=0x52d817ac chunk 52d817b4 sz= 3784 perm "perm " alo=378452d817b0 50000ec9 00000000 00000000 [...p........]52d817c0 00000ec8 00000010 00000004 00000010 [................]52d817d0 00000004 00000000 00000000 00000000 [................]52d817e0 00000000 00000000 00000008 00000000 [................]52d817f0 00000000 52d81f5c 404eeb2c 00000000 [..../..r,[email protected]]52d81800 00000000 00000000 00000000 52d81a08 [...............r]52d81810 00000000 00000000 00000110 00000003 [................]52d81820 00000000 00000000 00000000 1a086878 [............xh..]52d81830 0029180b 00000000 00000000 00000000 [..).............]52d81840 52d81c10 52d82540 00000000 52d824d4 [[email protected]%.r.....$.r]52d81850 00000000 00000000 00000000 52d81b7c [............|..r]52d81860 00000000 00000000 00000001 52d81bfc [...............r]52d81870 52d82360 00000000 00000000 52d82894 [`#.r.........(.r]52d81880 00000000 00000000 00000000 00000000 [................] repeat 1 times52d818a0 00000000 00000000 08000000 52d823ac [.............#.r]52d818b0 00000001 00000000 00000000 00000000 [................]52d818c0 00000024 00000000 00000000 00000000 [$...............]52d818d0 00000000 00000000 00000000 52d81c1c [...............r]52d818e0 00000000 00000000 00000000 52d82620 [............ &.r]52d818f0 00000000 00000000 00000000 52d81958 [............x..r]52d81900 00000000 00000000 00000000 00000000 [................]52d81910 00000000 00000000 52d8252c 00010001 [........,%.r....]52d81920 ebce39a4 00000000 00000000 00000000 [.9..............]52d81930 00000000 00000000 00000000 00000001 [................]52d81940 00000001 00000794 00000000 00000001 [................]52d81950 00000001 00000008 00000000 52d817c4 [...............r]52d81960 00000000 00000000 00000202 00000000 [................]52d81970 52d819b8 52d819a0 52d81990 5001a874 [...r...r...rt..p]52d81980 00000000 00000000 52d819fc 52d819cc [...........r...r]52d81990 52d82ac0 404efb80 00000000 00000000 [.*[email protected]]52d819a0 00000000 00000000 52d81958 00000000 [........x..r....]52d819b0 00000000 00000000 00000000 52d81958 [............x..r]52d819c0 00000002 52d885cc 00000000 52d819e4 [.......r.......r]52d819d0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d819f0 00000001 00000000 00000000 52d81958 [............x..r]52d81a00 00000000 00000000 4c475945 00000045 [........eygle...]52d81a10 00000000 00000000 00000000 00000000 [................]52d81a20 00000000 00050000 00000069 0000000e [........i.......]52d81a30 4d450003 00000050 00000000 00000500 [..emp...........]52d81a40 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81a60 404ee794 00000000 00000000 00000014 [[email protected]]52d81a70 00000004 00000000 00000000 00000000 [................]52d81a80 00000000 00000000 00000000 00000000 [................]52d81a90 00000000 00000000 00000000 00003f09 [.............?..]52d81aa0 00000001 00000000 00000000 00000000 [................]52d81ab0 00000000 00000069 00080008 00000000 [....i...........]52d81ac0 08687800 29180b1a 1a086878 7829180b [.xh....)xh....)x]52d81ad0 0b1a0868 00002918 00000000 00000000 [h....)..........]52d81ae0 00000000 00000000 00000000 00000000 [................]52d81af0 00000000 00000001 00000000 000002e0 [................]52d81b00 00000000 00000008 00000000 00000000 [................]52d81b10 00000000 404eec04 00000000 52d81b9c [[email protected]]52d81b20 52d81b9c 00000000 00000000 00000000 [...r............]52d81b30 00000000 00000000 00000000 00000000 [................]52d81b40 00000000 00000000 00000000 20000000 [............... ]52d81b50 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81b70 00000000 00000000 00000000 52d81948 [............h..r]52d81b80 00000000 00000002 00000008 0000000e [................]52d81b90 59450005 00454c47 00000000 00000000 [..eygle.........]52d81ba0 40548000 00000001 00000064 00000000 [[email protected]]52d81bb0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81bd0 00000000 00002000 00000000 00000000 [..... ..........]52d81be0 00000000 00000000 00000000 00000000 [................]52d81bf0 00000000 00000000 00003f09 00000000 [.........?......]52d81c00 00000014 00000004 00000001 00000000 [................]52d81c10 00000000 00003f09 00010000 52d81fd4 [.....?.........r]52d81c20 52d81f08 52d81f64 00000000 00000010 [...rd..r........]52d81c30 00000007 00000100 00000000 00000000 [................]52d81c40 00000000 00000000 00000000 00000010 [................]52d81c50 00000104 00000000 00000000 00000000 [................]52d81c60 00000000 00000000 00000000 00000000 [................]52d81c70 52d81a2c 00000000 404ee794 00000000 [,[email protected]]52d81c80 00000000 00000007 00000102 00000000 [................]52d81c90 00010041 00000000 00000014 00000004 [a...............]52d81ca0 00000010 000001a0 00000016 00000000 [................]52d81cb0 52d824b4 00040000 00000000 52d82300 [.$.r.........#.r]52d81cc0 00000000 52d81a2c 52d81fc4 404ee794 [....,[email protected]]52d81cd0 00000000 00000000 00000000 52d81c84 [...............r]52d81ce0 00000007 00000102 00000000 00010041 [............a...]52d81cf0 00000000 00000014 0000001c 00000010 [................]52d81d00 00000194 00000016 00000000 52d82494 [.............$.r]52d81d10 00040000 00000000 52d822a0 00000000 [.........".r....]52d81d20 52d81a2c 52d81fb8 404ee794 00000000 [,[email protected]]52d81d30 00000000 52d81cd8 52d81ce0 00000007 [.......r...r....]52d81d40 00000102 00000000 00010041 00000000 [........a.......]52d81d50 00000014 00000034 00000010 00000188 [....4...........]52d81d60 00000016 00000000 52d82474 00040000 [........t$.r....]52d81d70 00000000 52d82240 00000000 52d81a2c [[email protected]".r....,..r]52d81d80 52d81fac 404ee794 00000000 00000000 [[email protected]]52d81d90 52d81d34 52d81d3c 00000007 0000010c [4..r<..r........]52d81da0 00000000 00010041 00000000 00000014 [....a...........]52d81db0 0000004c 00000010 0000017c 00000007 [l.......|.......]52d81dc0 00000000 52d82454 00040000 00000000 [....t$.r........]52d81dd0 52d821e0 00000000 52d81a2c 52d81f9c [.!.r....,..r...r]52d81de0 404ee794 00000000 00000000 52d81d90 [[email protected]]52d81df0 52d81d98 00000007 00000102 00000000 [...r............]52d81e00 00010041 00000000 00000014 00000054 [a...........t...]52d81e10 00000010 00000170 00000016 00000000 [....p...........]52d81e20 52d82434 00040000 00000000 52d82180 [4$.r.........!.r]52d81e30 00000000 52d81a2c 52d81f90 404ee794 [....,[email protected]]52d81e40 00000000 00000000 52d81dec 52d81df4 [...........r...r]52d81e50 00000007 00000101 00010354 00010041 [........t...a...]52d81e60 00040000 00000014 0000006c 00000010 [........l.......]52d81e70 00000164 00090009 00000000 52d82414 [d............$.r]52d81e80 00040000 00000000 52d82120 00000000 [........ !.r....]52d81e90 52d81a2c 52d81f84 404ee794 00000000 [,[email protected]]52d81ea0 00000000 52d81e48 52d81e50 00000007 [....h..rp..r....]52d81eb0 00000101 00010354 00010041 00040000 [....t...a.......]52d81ec0 00000014 00000078 00000010 00000158 [....x.......x...]52d81ed0 000a000a 00000000 52d823f4 00040000 [.........#.r....]52d81ee0 00000000 52d820c0 00000000 52d81a2c [..... .r....,..r]52d81ef0 52d81f74 404ee794 00000000 00000000 [[email protected]]52d81f00 52d81ea4 52d81eac 00000007 00000102 [...r...r........]52d81f10 00000000 00010041 00000000 00000014 [....a...........]52d81f20 00000084 00000010 0000014c 00000016 [........l.......]52d81f30 00000000 52d823d4 00040000 00000000 [.....#.r........]52d81f40 52d82060 00000000 52d81a2c 52d81f64 [` .r....,..rd..r]52d81f50 404ee794 00000000 00000000 52d81f00 [[email protected]]52d81f60 52d81f08 00000007 4d450005 004f4e50 [...r......empno.]52d81f70 00000000 00000007 4e450005 00454d41 [..........ename.]52d81f80 00000000 00000007 4f4a0003 00000042 [..........job...]52d81f90 00000007 474d0003 00000052 00000007 [......mgr.......]52d81fa0 49480008 41444552 00004554 00000007 [..hiredate......]52d81fb0 41530003 0000004c 00000007 4f430004 [..sal.........co]52d81fc0 00004d4d 00000007 45440006 4f4e5450 [mm........deptno]52d81fd0 00000000 52d81fe8 52d81eac 52d81f74 [.......r...rt..r]52d81fe0 00000000 00000010 52d81ffc 52d81e50 [...........rp..r]52d81ff0 52d81f84 00000000 00000010 52d82010 [...r......... .r]52d82000 52d81df4 52d81f90 00000000 00000010 [...r...r........]52d82010 52d82024 52d81d98 52d81f9c 00000000 [$ .r...r...r....]52d82020 00000010 52d82038 52d81d3c 52d81fac [....8 .r<..r...r]52d82030 00000000 00000010 52d8204c 52d81ce0 [........l .r...r]52d82040 52d81fb8 00000000 00000010 00000000 [...r............]52d82050 52d81c84 52d81fc4 00000000 00000010 [...r...r........]52d82060 00000000 00010001 00020001 00000016 [................]52d82070 00000004 00000000 00000000 00000000 [................]52d82080 00000000 00000000 00000000 00000000 [................] repeat 2 times52d820b0 00000000 00000000 00000000 00003f09 [.............?..]52d820c0 00000000 00020002 00010002 000a000a [................]52d820d0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82100 00010354 00000000 00000000 00000000 [t...............]52d82110 00000000 00000000 00000000 00003f09 [.............?..]52d82120 00000000 00030003 00010003 00090009 [................]52d82130 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82160 00010354 00000000 00000000 00000000 [t...............]52d82170 00000000 00000000 00000000 00003f09 [.............?..]52d82180 00000000 00040004 00020004 00000016 [................]52d82190 00000004 00000000 00000000 00000000 [................]52d821a0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d821d0 00000000 00000000 00000000 00003f09 [.............?..]52d821e0 00000000 00050005 000c0005 00000007 [................]52d821f0 00000000 00000000 00000000 00000000 [................] repeat 3 times52d82230 00000000 00000000 00000000 00003f09 [.............?..]52d82240 00000000 00060006 00020006 00000016 [................]52d82250 00000207 00000000 00000000 00000000 [................]52d82260 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82290 00000000 00000000 00000000 00003f09 [.............?..]52d822a0 00000000 00070007 00020007 00000016 [................]52d822b0 00000207 00000000 00000000 00000000 [................]52d822c0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d822f0 00000000 00000000 00000000 00003f09 [.............?..]52d82300 00000000 00080008 00020008 00000016 [................]52d82310 00000002 00000000 00000000 00000000 [................]52d82320 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82350 00000000 00000000 00000000 00003f09 [.............?..]52d82360 00000000 00000000 00000000 52d82374 [............t#.r]52d82370 00003f09 00000000 52d82370 3eeeeeee [.?......p#.r...>]52d82380 00000000 52d817b4 52d82388 52d82388 [.......r.#.r.#.r]52d82390 00000000 404eecb8 404eecb8 404eecb8 [[email protected]@[email protected]]52d823a0 00000000 00000000 00000000 52d81a6c [............l..r]52d823b0 00000008 52d81f08 52d81eac 52d81e50 [.......r...rp..r]52d823c0 52d81df4 52d81d98 52d81d3c 52d81ce0 [...r...r<..r...r]52d823d0 52d81c84 00000010 0000014c 00000014 [...r....l.......]52d823e0 00000084 00000016 00000001 52d82060 [............` .r]52d823f0 00000001 00000010 00000158 00000014 [........x.......]52d82400 00000078 0000000a 00000002 52d820c0 [x............ .r]52d82410 00000001 00000010 00000164 00000014 [........d.......]52d82420 0000006c 00000009 00000003 52d82120 [l........... !.r]52d82430 00000001 00000010 00000170 00000014 [........p.......]52d82440 00000054 00000016 00000004 52d82180 [t............!.r]52d82450 00000001 00000010 0000017c 00000014 [........|.......]52d82460 0000004c 00000007 00000005 52d821e0 [l............!.r]52d82470 00000001 00000010 00000188 00000014 [................]52d82480 00000034 00000016 00000006 52d82240 [[email protected]".r]52d82490 00000001 00000010 00000194 00000014 [................]52d824a0 0000001c 00000016 00000007 52d822a0 [.............".r]52d824b0 00000001 00000010 000001a0 00000014 [................]52d824c0 00000004 00000016 00000008 52d82300 [.............#.r]52d824d0 00000001 52d81938 00000004 00000002 [....8..r........]52d824e0 000000bc 00000000 52d81c1c 00000008 [...........r....]52d824f0 00000000 00000000 00000000 00000000 [................]52d82500 00000000 00000000 00000012 02400791 [[email protected]]52d82510 00003f09 00003f09 00030000 00001fe8 [.?...?..........]52d82520 00000000 00000100 3f091826 00000001 [........&..?....]52d82530 00000010 000001ac 00000000 00000000 [................]52d82540 00000000 00000000 00000000 00000000 [................]52d82550 52d823b0 00000010 000001d0 00000017 [.#.r............]52d82560 52d82524 00000001 00003f09 00000000 [$%.r.....?......]52d82570 00000881 00000000 00000000 00000000 [................]52d82580 00000000 00000000 00000000 00000000 [................]52d82590 00000000 00000000 52d823d4 00080000 [.........#.r....]52d825a0 00000008 00000000 00000000 52d82508 [.............%.r]52d825b0 00000000 00000000 00000010 00000270 [............p...]52d825c0 52d823d4 00000008 00000014 0000009c [.#.r............]52d825d0 00000000 00000000 00000000 52d81acf [...............r]52d825e0 00000000 00000000 00000000 00000000 [................] repeat 3 times52d82620 52d8263c 00000010 000006d4 00000010 [<&.r............]52d82630 000006f4 00000010 000006f8 00000010 [................]52d82640 000006fc 00000010 00000714 00000010 [................]52d82650 00000720 00000010 0000072c 00000010 [ .......,.......]52d82660 00000744 00000010 0000074c 00000010 [d.......l.......]52d82670 00000764 00000010 0000077c [d.......|...] total heap size = 3784free lists: bucket 0 size=0total free space = 0unpinned recreatable chunks (lru first):permanent chunks: chunk 52d817b4 sz= 3784 perm "perm " alo=378452d817b0 50000ec9 00000000 00000000 [...p........]52d817c0 00000ec8 00000010 00000004 00000010 [................]52d817d0 00000004 00000000 00000000 00000000 [................]52d817e0 00000000 00000000 00000008 00000000 [................]52d817f0 00000000 52d81f5c 404eeb2c 00000000 [..../..r,[email protected]]52d81800 00000000 00000000 00000000 52d81a08 [...............r]52d81810 00000000 00000000 00000110 00000003 [................]52d81820 00000000 00000000 00000000 1a086878 [............xh..]52d81830 0029180b 00000000 00000000 00000000 [..).............]52d81840 52d81c10 52d82540 00000000 52d824d4 [[email protected]%.r.....$.r]52d81850 00000000 00000000 00000000 52d81b7c [............|..r]52d81860 00000000 00000000 00000001 52d81bfc [...............r]52d81870 52d82360 00000000 00000000 52d82894 [`#.r.........(.r]52d81880 00000000 00000000 00000000 00000000 [................] repeat 1 times52d818a0 00000000 00000000 08000000 52d823ac [.............#.r]52d818b0 00000001 00000000 00000000 00000000 [................]52d818c0 00000024 00000000 00000000 00000000 [$...............]52d818d0 00000000 00000000 00000000 52d81c1c [...............r]52d818e0 00000000 00000000 00000000 52d82620 [............ &.r]52d818f0 00000000 00000000 00000000 52d81958 [............x..r]52d81900 00000000 00000000 00000000 00000000 [................]52d81910 00000000 00000000 52d8252c 00010001 [........,%.r....]52d81920 ebce39a4 00000000 00000000 00000000 [.9..............]52d81930 00000000 00000000 00000000 00000001 [................]52d81940 00000001 00000794 00000000 00000001 [................]52d81950 00000001 00000008 00000000 52d817c4 [...............r]52d81960 00000000 00000000 00000202 00000000 [................]52d81970 52d819b8 52d819a0 52d81990 5001a874 [...r...r...rt..p]52d81980 00000000 00000000 52d819fc 52d819cc [...........r...r]52d81990 52d82ac0 404efb80 00000000 00000000 [.*[email protected]]52d819a0 00000000 00000000 52d81958 00000000 [........x..r....]52d819b0 00000000 00000000 00000000 52d81958 [............x..r]52d819c0 00000002 52d885cc 00000000 52d819e4 [.......r.......r]52d819d0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d819f0 00000001 00000000 00000000 52d81958 [............x..r]52d81a00 00000000 00000000 4c475945 00000045 [........eygle...]52d81a10 00000000 00000000 00000000 00000000 [................]52d81a20 00000000 00050000 00000069 0000000e [........i.......]52d81a30 4d450003 00000050 00000000 00000500 [..emp...........]52d81a40 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81a60 404ee794 00000000 00000000 00000014 [[email protected]]52d81a70 00000004 00000000 00000000 00000000 [................]52d81a80 00000000 00000000 00000000 00000000 [................]52d81a90 00000000 00000000 00000000 00003f09 [.............?..]52d81aa0 00000001 00000000 00000000 00000000 [................]52d81ab0 00000000 00000069 00080008 00000000 [....i...........]52d81ac0 08687800 29180b1a 1a086878 7829180b [.xh....)xh....)x]52d81ad0 0b1a0868 00002918 00000000 00000000 [h....)..........]52d81ae0 00000000 00000000 00000000 00000000 [................]52d81af0 00000000 00000001 00000000 000002e0 [................]52d81b00 00000000 00000008 00000000 00000000 [................]52d81b10 00000000 404eec04 00000000 52d81b9c [[email protected]]52d81b20 52d81b9c 00000000 00000000 00000000 [...r............]52d81b30 00000000 00000000 00000000 00000000 [................]52d81b40 00000000 00000000 00000000 20000000 [............... ]52d81b50 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81b70 00000000 00000000 00000000 52d81948 [............h..r]52d81b80 00000000 00000002 00000008 0000000e [................]52d81b90 59450005 00454c47 00000000 00000000 [..eygle.........]52d81ba0 40548000 00000001 00000064 00000000 [[email protected]]52d81bb0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d81bd0 00000000 00002000 00000000 00000000 [..... ..........]52d81be0 00000000 00000000 00000000 00000000 [................]52d81bf0 00000000 00000000 00003f09 00000000 [.........?......]52d81c00 00000014 00000004 00000001 00000000 [................]52d81c10 00000000 00003f09 00010000 52d81fd4 [.....?.........r]52d81c20 52d81f08 52d81f64 00000000 00000010 [...rd..r........]52d81c30 00000007 00000100 00000000 00000000 [................]52d81c40 00000000 00000000 00000000 00000010 [................]52d81c50 00000104 00000000 00000000 00000000 [................]52d81c60 00000000 00000000 00000000 00000000 [................]52d81c70 52d81a2c 00000000 404ee794 00000000 [,[email protected]]52d81c80 00000000 00000007 00000102 00000000 [................]52d81c90 00010041 00000000 00000014 00000004 [a...............]52d81ca0 00000010 000001a0 00000016 00000000 [................]52d81cb0 52d824b4 00040000 00000000 52d82300 [.$.r.........#.r]52d81cc0 00000000 52d81a2c 52d81fc4 404ee794 [....,[email protected]]52d81cd0 00000000 00000000 00000000 52d81c84 [...............r]52d81ce0 00000007 00000102 00000000 00010041 [............a...]52d81cf0 00000000 00000014 0000001c 00000010 [................]52d81d00 00000194 00000016 00000000 52d82494 [.............$.r]52d81d10 00040000 00000000 52d822a0 00000000 [.........".r....]52d81d20 52d81a2c 52d81fb8 404ee794 00000000 [,[email protected]]52d81d30 00000000 52d81cd8 52d81ce0 00000007 [.......r...r....]52d81d40 00000102 00000000 00010041 00000000 [........a.......]52d81d50 00000014 00000034 00000010 00000188 [....4...........]52d81d60 00000016 00000000 52d82474 00040000 [........t$.r....]52d81d70 00000000 52d82240 00000000 52d81a2c [[email protected]".r....,..r]52d81d80 52d81fac 404ee794 00000000 00000000 [[email protected]]52d81d90 52d81d34 52d81d3c 00000007 0000010c [4..r<..r........]52d81da0 00000000 00010041 00000000 00000014 [....a...........]52d81db0 0000004c 00000010 0000017c 00000007 [l.......|.......]52d81dc0 00000000 52d82454 00040000 00000000 [....t$.r........]52d81dd0 52d821e0 00000000 52d81a2c 52d81f9c [.!.r....,..r...r]52d81de0 404ee794 00000000 00000000 52d81d90 [[email protected]]52d81df0 52d81d98 00000007 00000102 00000000 [...r............]52d81e00 00010041 00000000 00000014 00000054 [a...........t...]52d81e10 00000010 00000170 00000016 00000000 [....p...........]52d81e20 52d82434 00040000 00000000 52d82180 [4$.r.........!.r]52d81e30 00000000 52d81a2c 52d81f90 404ee794 [....,[email protected]]52d81e40 00000000 00000000 52d81dec 52d81df4 [...........r...r]52d81e50 00000007 00000101 00010354 00010041 [........t...a...]52d81e60 00040000 00000014 0000006c 00000010 [........l.......]52d81e70 00000164 00090009 00000000 52d82414 [d............$.r]52d81e80 00040000 00000000 52d82120 00000000 [........ !.r....]52d81e90 52d81a2c 52d81f84 404ee794 00000000 [,[email protected]]52d81ea0 00000000 52d81e48 52d81e50 00000007 [....h..rp..r....]52d81eb0 00000101 00010354 00010041 00040000 [....t...a.......]52d81ec0 00000014 00000078 00000010 00000158 [....x.......x...]52d81ed0 000a000a 00000000 52d823f4 00040000 [.........#.r....]52d81ee0 00000000 52d820c0 00000000 52d81a2c [..... .r....,..r]52d81ef0 52d81f74 404ee794 00000000 00000000 [[email protected]]52d81f00 52d81ea4 52d81eac 00000007 00000102 [...r...r........]52d81f10 00000000 00010041 00000000 00000014 [....a...........]52d81f20 00000084 00000010 0000014c 00000016 [........l.......]52d81f30 00000000 52d823d4 00040000 00000000 [.....#.r........]52d81f40 52d82060 00000000 52d81a2c 52d81f64 [` .r....,..rd..r]52d81f50 404ee794 00000000 00000000 52d81f00 [[email protected]]52d81f60 52d81f08 00000007 4d450005 004f4e50 [...r......empno.]52d81f70 00000000 00000007 4e450005 00454d41 [..........ename.]52d81f80 00000000 00000007 4f4a0003 00000042 [..........job...]52d81f90 00000007 474d0003 00000052 00000007 [......mgr.......]52d81fa0 49480008 41444552 00004554 00000007 [..hiredate......]52d81fb0 41530003 0000004c 00000007 4f430004 [..sal.........co]52d81fc0 00004d4d 00000007 45440006 4f4e5450 [mm........deptno]52d81fd0 00000000 52d81fe8 52d81eac 52d81f74 [.......r...rt..r]52d81fe0 00000000 00000010 52d81ffc 52d81e50 [...........rp..r]52d81ff0 52d81f84 00000000 00000010 52d82010 [...r......... .r]52d82000 52d81df4 52d81f90 00000000 00000010 [...r...r........]52d82010 52d82024 52d81d98 52d81f9c 00000000 [$ .r...r...r....]52d82020 00000010 52d82038 52d81d3c 52d81fac [....8 .r<..r...r]52d82030 00000000 00000010 52d8204c 52d81ce0 [........l .r...r]52d82040 52d81fb8 00000000 00000010 00000000 [...r............]52d82050 52d81c84 52d81fc4 00000000 00000010 [...r...r........]52d82060 00000000 00010001 00020001 00000016 [................]52d82070 00000004 00000000 00000000 00000000 [................]52d82080 00000000 00000000 00000000 00000000 [................] repeat 2 times52d820b0 00000000 00000000 00000000 00003f09 [.............?..]52d820c0 00000000 00020002 00010002 000a000a [................]52d820d0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82100 00010354 00000000 00000000 00000000 [t...............]52d82110 00000000 00000000 00000000 00003f09 [.............?..]52d82120 00000000 00030003 00010003 00090009 [................]52d82130 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82160 00010354 00000000 00000000 00000000 [t...............]52d82170 00000000 00000000 00000000 00003f09 [.............?..]52d82180 00000000 00040004 00020004 00000016 [................]52d82190 00000004 00000000 00000000 00000000 [................]52d821a0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d821d0 00000000 00000000 00000000 00003f09 [.............?..]52d821e0 00000000 00050005 000c0005 00000007 [................]52d821f0 00000000 00000000 00000000 00000000 [................] repeat 3 times52d82230 00000000 00000000 00000000 00003f09 [.............?..]52d82240 00000000 00060006 00020006 00000016 [................]52d82250 00000207 00000000 00000000 00000000 [................]52d82260 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82290 00000000 00000000 00000000 00003f09 [.............?..]52d822a0 00000000 00070007 00020007 00000016 [................]52d822b0 00000207 00000000 00000000 00000000 [................]52d822c0 00000000 00000000 00000000 00000000 [................] repeat 2 times52d822f0 00000000 00000000 00000000 00003f09 [.............?..]52d82300 00000000 00080008 00020008 00000016 [................]52d82310 00000002 00000000 00000000 00000000 [................]52d82320 00000000 00000000 00000000 00000000 [................] repeat 2 times52d82350 00000000 00000000 00000000 00003f09 [.............?..]52d82360 00000000 00000000 00000000 52d82374 [............t#.r]52d82370 00003f09 00000000 52d82370 3eeeeeee [.?......p#.r...>]52d82380 00000000 52d817b4 52d82388 52d82388 [.......r.#.r.#.r]52d82390 00000000 404eecb8 404eecb8 404eecb8 [[email protected]@[email protected]]52d823a0 00000000 00000000 00000000 52d81a6c [............l..r]52d823b0 00000008 52d81f08 52d81eac 52d81e50 [.......r...rp..r]52d823c0 52d81df4 52d81d98 52d81d3c 52d81ce0 [...r...r<..r...r]52d823d0 52d81c84 00000010 0000014c 00000014 [...r....l.......]52d823e0 00000084 00000016 00000001 52d82060 [............` .r]52d823f0 00000001 00000010 00000158 00000014 [........x.......]52d82400 00000078 0000000a 00000002 52d820c0 [x............ .r]52d82410 00000001 00000010 00000164 00000014 [........d.......]52d82420 0000006c 00000009 00000003 52d82120 [l........... !.r]52d82430 00000001 00000010 00000170 00000014 [........p.......]52d82440 00000054 00000016 00000004 52d82180 [t............!.r]52d82450 00000001 00000010 0000017c 00000014 [........|.......]52d82460 0000004c 00000007 00000005 52d821e0 [l............!.r]52d82470 00000001 00000010 00000188 00000014 [................]52d82480 00000034 00000016 00000006 52d82240 [[email protected]".r]52d82490 00000001 00000010 00000194 00000014 [................]52d824a0 0000001c 00000016 00000007 52d822a0 [.............".r]52d824b0 00000001 00000010 000001a0 00000014 [................]52d824c0 00000004 00000016 00000008 52d82300 [.............#.r]52d824d0 00000001 52d81938 00000004 00000002 [....8..r........]52d824e0 000000bc 00000000 52d81c1c 00000008 [...........r....]52d824f0 00000000 00000000 00000000 00000000 [................]52d82500 00000000 00000000 00000012 02400791 [[email protected]]52d82510 00003f09 00003f09 00030000 00001fe8 [.?...?..........]52d82520 00000000 00000100 3f091826 00000001 [........&..?....]52d82530 00000010 000001ac 00000000 00000000 [................]52d82540 00000000 00000000 00000000 00000000 [................]52d82550 52d823b0 00000010 000001d0 00000017 [.#.r............]52d82560 52d82524 00000001 00003f09 00000000 [$%.r.....?......]52d82570 00000881 00000000 00000000 00000000 [................]52d82580 00000000 00000000 00000000 00000000 [................]52d82590 00000000 00000000 52d823d4 00080000 [.........#.r....]52d825a0 00000008 00000000 00000000 52d82508 [.............%.r]52d825b0 00000000 00000000 00000010 00000270 [............p...]52d825c0 52d823d4 00000008 00000014 0000009c [.#.r............]52d825d0 00000000 00000000 00000000 52d81acf [...............r]52d825e0 00000000 00000000 00000000 00000000 [................] repeat 3 times52d82620 52d8263c 00000010 000006d4 00000010 [<&.r............]52d82630 000006f4 00000010 000006f8 00000010 [................]52d82640 000006fc 00000010 00000714 00000010 [................]52d82650 00000720 00000010 0000072c 00000010 [ .......,.......]52d82660 00000744 00000010 0000074c 00000010 [d.......l.......]52d82670 00000764 00000010 0000077c [d.......|...] permanent space = 3784marks: mark 0x52d8237c******************************************************这里的handle=52d82e58就是sql依赖的对象信息:bucket 63037: library object handle: handle=52d82e58 name=eygle.emp hash=7310f63d timestamp=08-26-2004 10:23:40 namespace=tabl/prcd/type flags=kghp/tim/sml/[02000000] kkkk-dddd-llll=0000-0501-0501 lock=0 pin=0 latch#=1 lwt=0x52d82e70[0x52d82e70,0x52d82e70] ltm=0x52d82e78[0x52d82e78,0x52d82e78] pwt=0x52d82e88[0x52d82e88,0x52d82e88] ptm=0x52d82ee0[0x52d82ee0,0x52d82ee0] ref=0x52d82e60[0x52d82e60, 0x52d82e60] lnd=0x52d82eec[0x52d7dcf0,0x52d89fc8] library object: object=52d81594 type=tabl flags=exs/loc[0005] pflags= [00] status=vald load=0==>type:对象类型,这里是一张表 ==>flags:代表对象状态 data blocks: data# heap pointer status pins change alloc(k) size(k) ----- -------- -------- ------ ---- ------ -------- -------- 0 52d8c1e4 52d8161c i/-/a 0 none 0.66 1.09 8 52d81238 52d80a18 i/-/a 0 none 1.10 1.13 10 52d8129c 52d80ea0 i/-/a 0 none 0.12 0.37 heap dump of data block 0:******************************************************heap dump heap name="library cache" desc=0x52d8c1e4 extent sz=0x224 alt=32767 het=16 rec=9 flg=2 opc=0 parent=0x5000002c owner=0x52d81594 nex=(nil) xsz=0x224 ==>每个heap descriptor 都包含一个owner部分，指向所有者，这里的 52d81594 也就是eygle.emp==>指向的library对象: library object: object=52d81594extent 0 addr=0x52d81220 chunk 52d81228 sz= 540 perm "perm " alo=19652d81220 5000021d 00000000 [...p....]52d81230 52d81584 000000c4 5000002c 00000824 [...r....,..p$...]52d81240 52d81594 52d80a00 52d80a08 00000000 [...r...r...r....]52d81250 00000000 05010200 00000000 00000000 [................]52d81260 534c474b 61656820 00000070 00000000 [kgls heap.......]52d81270 00107fff 7fff7fff 00000401 00000000 [................]52d81280 52d81280 52d81280 52d8129c 00000000 [...r...r...r....]52d81290 52d80ea0 00040000 52ff5c14 5000002c [...r...../.r,..p]52d812a0 00000824 52d81594 52d80e88 52d80e90 [$......r...r...r]52d812b0 00000000 00000000 05010200 00000000 [................]52d812c0 0000015c 534c474b 61656820 00000070 [/...kgls heap...]52d812d0 00000000 00107fff 7fff7fff 00000401 [................]52d812e0 00000000 52d812e4 52d812e4 00000000 [.......r...r....]52d812f0 00000000 00000000 00000000 00000000 [................] repeat 20 times52d81440 00000000 [....] extent 1 addr=0x52d8157c chunk 52d81584 sz= 484 perm "perm " alo=48452d81580 400001e5 00000000 00000000 [[email protected]]52d81590 000001e4 52d82e58 52d81598 52d81598 [....x..r...r...r]52d815a0 52d815a0 52d815a0 00000000 00000000 [...r...r........]52d815b0 00010005 00000000 00000000 00000000 [................]52d815c0 02000000 52d81608 00000000 00000000 [.......r........]52d815d0 00000000 00000000 00000000 00000000 [................]52d815e0 00000000 52d81754 00000000 52d81288 [....t..r.......r]52d815f0 00000000 00000000 00000000 00000000 [................]52d81600 00000000 00000000 52d8c1e4 00000000 [...........r....]52d81610 52d8161c 00000000 52ff5bc4 00000006 [...r.....[.r....]52d81620 00000000 52d81650 00000000 00000000 [....p..r........]52d81630 00003f09 00003f09 00000000 00000000 [.?...?..........]52d81640 00000000 00000000 00000069 00000000 [........i.......]52d81650 20000000 00000001 00080008 00000008 [... ............]52d81660 00000000 2d2d2d2d 2d2d2d2d 2d2d2d2d [....------------]52d81670 2d2d2d2d 2d2d2d2d 2d2d2d2d 2d2d2d2d [----------------]52d81680 2d2d2d2d 00000012 02400791 00000000 [[email protected]]52d81690 00000000 00000000 00000000 00000000 [................] repeat 3 times52d816d0 00000000 0001280a 000000ff 00000000 [.....(..........]52d816e0 40548000 00000001 00000064 00000000 [[email protected]]52d816f0 00000000 00000000 00000000 00000000 [................]52d81700 00000000 00000000 00000000 00000001 [................]52d81710 00000000 00000000 00000001 00000001 [................]52d81720 00000000 00000000 000002e0 00000000 [................]52d81730 00000000 00000000 00000000 00000000 [................]52d81740 ffffffff ffffffff 68780000 180b1a08 [..........xh....]52d81750 00000029 52d81238 00000000 52d80a18 [)...8..r.......r]52d81760 00040000 52ff5bec [.....[.r] chunk 52d81768 sz= 40 free " "52d81760 d0000029 52d81584 [)......r]52d81770 52d8c22c 52d8c22c 00000000 00000000 [,..r,..r........]52d81780 00000000 00000000 00000000 00000000 [................]total heap size = 1064free lists: bucket 0 size=0 chunk 52d81768 sz= 40 free " "52d81760 d0000029 52d81584 [)......r]52d81770 52d8c22c 52d8c22c 00000000 00000000 [,..r,..r........]52d81780 00000000 00000000 00000000 00000000 [................]total free space = 40unpinned recreatable chunks (lru first):permanent chunks: chunk 52d81228 sz= 540 perm "perm " alo=19652d81220 5000021d 00000000 [...p....]52d81230 52d81584 000000c4 5000002c 00000824 [...r....,..p$...]52d81240 52d81594 52d80a00 52d80a08 00000000 [...r...r...r....]52d81250 00000000 05010200 00000000 00000000 [................]52d81260 534c474b 61656820 00000070 00000000 [kgls heap.......]52d81270 00107fff 7fff7fff 00000401 00000000 [................]52d81280 52d81280 52d81280 52d8129c 00000000 [...r...r...r....]52d81290 52d80ea0 00040000 52ff5c14 5000002c [...r...../.r,..p]52d812a0 00000824 52d81594 52d80e88 52d80e90 [$......r...r...r]52d812b0 00000000 00000000 05010200 00000000 [................]52d812c0 0000015c 534c474b 61656820 00000070 [/...kgls heap...]52d812d0 00000000 00107fff 7fff7fff 00000401 [................]52d812e0 00000000 52d812e4 52d812e4 00000000 [.......r...r....]52d812f0 00000000 00000000 00000000 00000000 [................] repeat 20 times52d81440 00000000 [....] chunk 52d81584 sz= 484 perm "perm " alo=48452d81580 400001e5 00000000 00000000 [[email protected]]52d81590 000001e4 52d82e58 52d81598 52d81598 [....x..r...r...r]52d815a0 52d815a0 52d815a0 00000000 00000000 [...r...r........]52d815b0 00010005 00000000 00000000 00000000 [................]52d815c0 02000000 52d81608 00000000 00000000 [.......r........]52d815d0 00000000 00000000 00000000 00000000 [................]52d815e0 00000000 52d81754 00000000 52d81288 [....t..r.......r]52d815f0 00000000 00000000 00000000 00000000 [................]52d81600 00000000 00000000 52d8c1e4 00000000 [...........r....]52d81610 52d8161c 00000000 52ff5bc4 00000006 [...r.....[.r....]52d81620 00000000 52d81650 00000000 00000000 [....p..r........]52d81630 00003f09 00003f09 00000000 00000000 [.?...?..........]52d81640 00000000 00000000 00000069 00000000 [........i.......]52d81650 20000000 00000001 00080008 00000008 [... ............]52d81660 00000000 2d2d2d2d 2d2d2d2d 2d2d2d2d [....------------]52d81670 2d2d2d2d 2d2d2d2d 2d2d2d2d 2d2d2d2d [----------------]52d81680 2d2d2d2d 00000012 02400791 00000000 [[email protected]]52d81690 00000000 00000000 00000000 00000000 [................] repeat 3 times52d816d0 00000000 0001280a 000000ff 00000000 [.....(..........]52d816e0 40548000 00000001 00000064 00000000 [[email protected]]52d816f0 00000000 00000000 00000000 00000000 [................]52d81700 00000000 00000000 00000000 00000001 [................]52d81710 00000000 00000000 00000001 00000001 [................]52d81720 00000000 00000000 000002e0 00000000 [................]52d81730 00000000 00000000 00000000 00000000 [................]52d81740 ffffffff ffffffff 68780000 180b1a08 [..........xh....]52d81750 00000029 52d81238 00000000 52d80a18 [)...8..r.......r]52d81760 00040000 52ff5bec [.....[.r] permanent space = 1024****************************************************** heap dump of data block 8:******************************************************heap dump heap name="kgls heap" desc=0x52d81238 extent sz=0x824 alt=32767 het=16 rec=0 flg=2 opc=5 parent=0x5000002c owner=0x52d81594 nex=(nil) xsz=0x0extent 0 addr=0x52d80a00 chunk 52d80a08 sz= 1124 perm "perm " alo=112452d80a00 50000465 00000000 [e..p....]52d80a10 00000000 00000464 00000000 00000007 [....d...........]52d80a20 00000454 00000000 52d80e00 52d80b0c [t..........r...r]52d80a30 52d80a30 52d80a30 00000000 00000008 [0..r0..r........]52d80a40 00000003 52d80a44 52d80a44 52d80a4c [....d..rd..rl..r]52d80a50 52d80a4c 00000000 00000000 00000023 [l..r........#...]52d80a60 52d80a60 52d80a60 52d80a68 52d80a68 [`..r`..rh..rh..r]52d80a70 00000000 00000000 00000032 52d80a7c [........2...|..r]52d80a80 52d80a7c 52d80a84 52d80a84 00000000 [|..r...r...r....]52d80a90 00000000 00000033 52d80a98 52d80a98 [....3......r...r]52d80aa0 52d80aa0 52d80aa0 00000000 00000000 [...r...r........]52d80ab0 0000002c 52d80ab4 52d80ab4 52d80abc [,......r...r...r]52d80ac0 52d80abc 00000000 00000000 00000035 [...r........5...]52d80ad0 52d80ad0 52d80ad0 52d80ad8 52d80ad8 [...r...r...r...r]52d80ae0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80b00 00000000 00000000 00000000 52d80a28 [............(..r]52d80b10 52d80b78 00000000 45440006 4f4e5450 [x..r......deptno]52d80b20 00000000 00000000 00000000 00000000 [................]52d80b30 00000000 00000000 00080008 00160002 [................]52d80b40 00000200 00000008 00000000 00000000 [................]52d80b50 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80b70 00000000 00000000 52d80b0c 52d80be4 [...........r...r]52d80b80 00000000 4f430004 00004d4d 00000000 [......comm......]52d80b90 00000000 00000000 00000000 00000000 [................]52d80ba0 00000000 00070007 00160002 00020700 [................]52d80bb0 00000007 00000000 00000000 00000000 [................]52d80bc0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80be0 00000000 52d80b78 52d80c50 00000000 [....x..rp..r....]52d80bf0 41530003 0000004c 00000000 00000000 [..sal...........]52d80c00 00000000 00000000 00000000 00000000 [................]52d80c10 00060006 00160002 00020700 00000006 [................]52d80c20 00000000 00000000 00000000 00000000 [................] repeat 2 times52d80c50 52d80be4 52d80cbc 00000000 49480008 [...r...r......hi]52d80c60 41444552 00004554 00000000 00000000 [redate..........]52d80c70 00000000 00000000 00000000 00050005 [................]52d80c80 0007000c 00000000 00000005 00000000 [................]52d80c90 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80cb0 00000000 00000000 00000000 52d80c50 [............p..r]52d80cc0 52d80d28 00000000 474d0003 00000052 [(..r......mgr...]52d80cd0 00000000 00000000 00000000 00000000 [................]52d80ce0 00000000 00000000 00040004 00160002 [................]52d80cf0 00000400 00000004 00000000 00000000 [................]52d80d00 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80d20 00000000 00000000 52d80cbc 52d80d94 [...........r...r]52d80d30 00000000 4f4a0003 00000042 00000000 [......job.......]52d80d40 00000000 00000000 00000000 00000000 [................]52d80d50 00000000 00030003 00090001 00000000 [................]52d80d60 00000003 00000000 00010354 00090000 [........t.......]52d80d70 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80d90 00000000 52d80d28 52d80e00 00000000 [....(..r...r....]52d80da0 4e450005 00454d41 00000000 00000000 [..ename.........]52d80db0 00000000 00000000 00000000 00000000 [................]52d80dc0 00020002 000a0001 00000000 00000002 [................]52d80dd0 00000000 00010354 000a0000 00000000 [....t...........]52d80de0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80e00 52d80d94 52d80a28 00000000 4d450005 [...r(..r......em]52d80e10 004f4e50 00000000 00000000 00000000 [pno.............]52d80e20 00000000 00000000 00000000 00010001 [................]52d80e30 00160002 00000400 00000001 00000000 [................]52d80e40 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80e60 00000000 00000000 00000000 [............] total heap size = 1124free lists: bucket 0 size=0total free space = 0unpinned recreatable chunks (lru first):permanent chunks: chunk 52d80a08 sz= 1124 perm "perm " alo=112452d80a00 50000465 00000000 [e..p....]52d80a10 00000000 00000464 00000000 00000007 [....d...........]52d80a20 00000454 00000000 52d80e00 52d80b0c [t..........r...r]52d80a30 52d80a30 52d80a30 00000000 00000008 [0..r0..r........]52d80a40 00000003 52d80a44 52d80a44 52d80a4c [....d..rd..rl..r]52d80a50 52d80a4c 00000000 00000000 00000023 [l..r........#...]52d80a60 52d80a60 52d80a60 52d80a68 52d80a68 [`..r`..rh..rh..r]52d80a70 00000000 00000000 00000032 52d80a7c [........2...|..r]52d80a80 52d80a7c 52d80a84 52d80a84 00000000 [|..r...r...r....]52d80a90 00000000 00000033 52d80a98 52d80a98 [....3......r...r]52d80aa0 52d80aa0 52d80aa0 00000000 00000000 [...r...r........]52d80ab0 0000002c 52d80ab4 52d80ab4 52d80abc [,......r...r...r]52d80ac0 52d80abc 00000000 00000000 00000035 [...r........5...]52d80ad0 52d80ad0 52d80ad0 52d80ad8 52d80ad8 [...r...r...r...r]52d80ae0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80b00 00000000 00000000 00000000 52d80a28 [............(..r]52d80b10 52d80b78 00000000 45440006 4f4e5450 [x..r......deptno]52d80b20 00000000 00000000 00000000 00000000 [................]52d80b30 00000000 00000000 00080008 00160002 [................]52d80b40 00000200 00000008 00000000 00000000 [................]52d80b50 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80b70 00000000 00000000 52d80b0c 52d80be4 [...........r...r]52d80b80 00000000 4f430004 00004d4d 00000000 [......comm......]52d80b90 00000000 00000000 00000000 00000000 [................]52d80ba0 00000000 00070007 00160002 00020700 [................]52d80bb0 00000007 00000000 00000000 00000000 [................]52d80bc0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80be0 00000000 52d80b78 52d80c50 00000000 [....x..rp..r....]52d80bf0 41530003 0000004c 00000000 00000000 [..sal...........]52d80c00 00000000 00000000 00000000 00000000 [................]52d80c10 00060006 00160002 00020700 00000006 [................]52d80c20 00000000 00000000 00000000 00000000 [................] repeat 2 times52d80c50 52d80be4 52d80cbc 00000000 49480008 [...r...r......hi]52d80c60 41444552 00004554 00000000 00000000 [redate..........]52d80c70 00000000 00000000 00000000 00050005 [................]52d80c80 0007000c 00000000 00000005 00000000 [................]52d80c90 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80cb0 00000000 00000000 00000000 52d80c50 [............p..r]52d80cc0 52d80d28 00000000 474d0003 00000052 [(..r......mgr...]52d80cd0 00000000 00000000 00000000 00000000 [................]52d80ce0 00000000 00000000 00040004 00160002 [................]52d80cf0 00000400 00000004 00000000 00000000 [................]52d80d00 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80d20 00000000 00000000 52d80cbc 52d80d94 [...........r...r]52d80d30 00000000 4f4a0003 00000042 00000000 [......job.......]52d80d40 00000000 00000000 00000000 00000000 [................]52d80d50 00000000 00030003 00090001 00000000 [................]52d80d60 00000003 00000000 00010354 00090000 [........t.......]52d80d70 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80d90 00000000 52d80d28 52d80e00 00000000 [....(..r...r....]52d80da0 4e450005 00454d41 00000000 00000000 [..ename.........]52d80db0 00000000 00000000 00000000 00000000 [................]52d80dc0 00020002 000a0001 00000000 00000002 [................]52d80dd0 00000000 00010354 000a0000 00000000 [....t...........]52d80de0 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80e00 52d80d94 52d80a28 00000000 4d450005 [...r(..r......em]52d80e10 004f4e50 00000000 00000000 00000000 [pno.............]52d80e20 00000000 00000000 00000000 00010001 [................]52d80e30 00160002 00000400 00000001 00000000 [................]52d80e40 00000000 00000000 00000000 00000000 [................] repeat 1 times52d80e60 00000000 00000000 00000000 [............] permanent space = 1124****************************************************** heap dump of data block 10:******************************************************heap dump heap name="kgls heap" desc=0x52d8129c extent sz=0x824 alt=32767 het=16 rec=0 flg=2 opc=5 parent=0x5000002c owner=0x52d81594 nex=(nil) xsz=0x15cextent 0 addr=0x52d80e88 chunk 52d80e90 sz= 340 perm "perm " alo=12052d80e90 50000155 00000000 00000000 00000078 [u..p........x...]52d80ea0 00000000 00000002 00000068 00000004 [........h.......]52d80eb0 52d80eb0 52d80eb0 52d80eb8 52d80eb8 [...r...r...r...r]52d80ec0 00000000 00000000 00000005 52d80ecc [...............r]52d80ed0 52d80ecc 52d80ed4 52d80ed4 00000000 [...r...r...r....]52d80ee0 00000000 00000000 00000000 00000000 [................] repeat 15 times52d80fe0 00000000 [....] total heap size = 340free lists: bucket 0 size=0total free space = 0unpinned recreatable chunks (lru first):permanent chunks: chunk 52d80e90 sz= 340 perm "perm " alo=12052d80e90 50000155 00000000 00000000 00000078 [u..p........x...]52d80ea0 00000000 00000002 00000068 00000004 [........h.......]52d80eb0 52d80eb0 52d80eb0 52d80eb8 52d80eb8 [...r...r...r...r]52d80ec0 00000000 00000000 00000005 52d80ecc [...............r]52d80ed0 52d80ecc 52d80ed4 52d80ed4 00000000 [...r...r...r....]52d80ee0 00000000 00000000 00000000 00000000 [................] repeat 15 times52d80fe0 00000000 [....] permanent space = 340****************************************************** bucket 63037 total object count=1
