• 欢迎访问搞代码网站,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站!
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏搞代码吧

关于shared pool的深入探讨(四)_sqlserver

sqlserver 搞代码 3年前 (2018-06-17) 132次浏览 已收录 0个评论

关于shared pool的深入探讨(四)

link:

http://www.gaodaima.com/?p=36268关于shared pool的深入探讨(四)_sqlserver

http://www.eygle.com/internal/shared_pool-4.htm    
 

我们进一步来讨论一下shared pool的处理:

先进行相应查询,获得测试数据:

 

[oracle@jumper 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 [i..@……..h…]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 [….@..R….SQL*]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 [i..@……..h…]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 [….@..R….SQL*]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 [….@+.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 […@……..]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 [y..@.*.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 [y..@.*.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 [….@+.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 […@……..]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,.N@….]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 […R@%.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 [.*.R..N@……..]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 [..N@…………]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 [……N@…….R]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 [..T@….d…….]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 [,..R……N@….]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 [….,..R…R..N@]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 [,..R…R..N@….]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 [….@”.R….,..R]52D81D80 52D81FAC 404EE794 00000000 00000000 […R..N@……..]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 [..N@………..R]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 [….,..R…R..N@]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 [,..R…R..N@….]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 [t..R..N@……..]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 [..N@………..R]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 [……N@..N@..N@]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 [4………..@”.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 […………..@.]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,.N@….]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 […R@%.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 [.*.R..N@……..]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 [..N@…………]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 [……N@…….R]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 [..T@….d…….]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 [,..R……N@….]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 [….,..R…R..N@]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 [,..R…R..N@….]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 [….@”.R….,..R]52D81D80 52D81FAC 404EE794 00000000 00000000 […R..N@……..]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 [..N@………..R]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 [….,..R…R..N@]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 [,..R…R..N@….]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 [t..R..N@……..]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 [..N@………..R]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 [……N@..N@..N@]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 [4………..@”.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 […………..@.]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 […@……..]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 [—-……@…..]52D81690 00000000 00000000 00000000 00000000 […………….] Repeat 3 times52D816D0 00000000 0001280A 000000FF 00000000 […..(……….]52D816E0 40548000 00000001 00000064 00000000 [..T@….d…….]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 […@……..]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 [—-……@…..]52D81690 00000000 00000000 00000000 00000000 […………….] Repeat 3 times52D816D0 00000000 0001280A 000000FF 00000000 […..(……….]52D816E0 40548000 00000001 00000064 00000000 [..T@….d…….]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 [i..@……..h…]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 [….@..R….SQL*]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 [i..@……..h…]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 [….@..R….SQL*]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 [….@+.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 […@……..]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 [y..@.*.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 [y..@.*.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 [….@+.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 […@……..]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,.N@….]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 […R@%.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 [.*.R..N@……..]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 [..N@…………]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 [……N@…….R]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 [..T@….d…….]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 [,..R……N@….]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 [….,..R…R..N@]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 [,..R…R..N@….]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 [….@”.R….,..R]52D81D80 52D81FAC 404EE794 00000000 00000000 […R..N@……..]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 [..N@………..R]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 [….,..R…R..N@]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 [,..R…R..N@….]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 [t..R..N@……..]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 [..N@………..R]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 [……N@..N@..N@]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 [4………..@”.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 […………..@.]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,.N@….]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 […R@%.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 [.*.R..N@……..]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 [..N@…………]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 [……N@…….R]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 [..T@….d…….]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 [,..R……N@….]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 [….,..R…R..N@]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 [,..R…R..N@….]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 [….@”.R….,..R]52D81D80 52D81FAC 404EE794 00000000 00000000 […R..N@……..]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 [..N@………..R]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 [….,..R…R..N@]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 [,..R…R..N@….]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 [t..R..N@……..]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 [..N@………..R]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 [……N@..N@..N@]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 [4………..@”.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 […………..@.]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 […@……..]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 [—-……@…..]52D81690 00000000 00000000 00000000 00000000 […………….] Repeat 3 times52D816D0 00000000 0001280A 000000FF 00000000 […..(……….]52D816E0 40548000 00000001 00000064 00000000 [..T@….d…….]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 […@……..]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 [—-……@…..]52D81690 00000000 00000000 00000000 00000000 […………….] Repeat 3 times52D816D0 00000000 0001280A 000000FF 00000000 […..(……….]52D816E0 40548000 00000001 00000064 00000000 [..T@….d…….]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

 

 

欢迎大家阅读《关于shared pool的深入探讨(四)_sqlserver,跪求各位点评,若觉得好的话请收藏本文,by 搞代码


喜欢 (0)
[搞代码]
分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址