MSSQL网页编程之关于shared pool的深切切磋(四)

Archive非常适合存储大量的独立的，作为历史记录的数据。因为它们不经常被读取。Archive拥有高效的插入速度，但其对查询的支持相对较差

关于sharedpool的深切切磋(四)

link:

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



我们进一步来会商一下sharedpool的处置:

先辈行响应查询，取得测试数据:



[oracle@jumperudump]$sqlplus"/assysdba"SQL*Plus:Release9.2.0.3.0-ProductiononThuAug2610:21:542004Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.3.0-ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.3.0-ProductionSQL>connecteygle/eygleConnected.SQL>createtableempasselect*fromscott.emp;Tablecreated.SQL>SQL>connect/assysdbaConnected.SQL>startupforce;ORACLEinstancestarted.TotalSystemGlobalArea47256168bytesFixedSize451176bytesVariableSize29360128bytesDatabaseBuffers16777216bytesRedoBuffers667648bytesDatabasemounted.Databaseopened.SQL>setlinesize120SQL>connectscott/tigerConnected.SQL>select*fromemp;EMPNOENAMEJOBMGRHIREDATESALCOMMDEPTNO------------------------------------------------------------------------------7369SMITHCLERK790217-DEC-80800208888EYGLEMANAGER11-AUG-04999910107566JONESMANAGER783902-APR-812975207698BLAKEMANAGER783901-MAY-812850307782CLARKMANAGER783909-JUN-812450107788SCOTTANALYST756619-APR-873000207839KINGPRESIDENT17-NOV-815000107876ADAMSCLERK778823-MAY-871100207900JAMESCLERK769803-DEC-81950307902FORDANALYST756603-DEC-813000207934MILLERCLERK778223-JAN-8213001011rowsselected.SQL>connecteygle/eygleConnected.SQL>select*fromemp;EMPNOENAMEJOBMGRHIREDATESALCOMMDEPTNO------------------------------------------------------------------------------7369SMITHCLERK790217-DEC-80800208888EYGLEMANAGER11-AUG-04999910107566JONESMANAGER783902-APR-812975207698BLAKEMANAGER783901-MAY-812850307782CLARKMANAGER783909-JUN-812450107788SCOTTANALYST756619-APR-873000207839KINGPRESIDENT17-NOV-815000107876ADAMSCLERK778823-MAY-871100207900JAMESCLERK769803-DEC-81950307902FORDANALYST756603-DEC-813000207934MILLERCLERK778223-JAN-8213001011rowsselected.SQL>selectSQL_TEXT,VERSION_COUNT,HASH_VALUE,to_char(HASH_VALUE,xxxxxxxxxx)HEX,ADDRESS2fromv$sqlareawheresql_textlikeselect*fromemp%;SQL_TEXTVERSION_COUNTHASH_VALUEHEXADDRESS--------------------------------------------------------------select*fromemp226487075579de011e552D9EA28SQL>selectsql_text,username,ADDRESS,HASH_VALUE,to_char(HASH_VALUE,xxxxxxxxxx)HEX_HASH_VALUE,CHILD_NUMBER,CHILD_LATCH2fromv$sqla,dba_usersbwherea.PARSING_USER_ID=b.user_idandsql_textlikeselect*fromemp%;SQL_TEXTUSERNAMEADDRESSHASH_VALUEHEX_HASH_VACHILD_NUMBERCHILD_LATCH------------------------------------------------------------------------------------------------------select*fromempSCOTT52D9EA2826487075579de011e501select*fromempEYGLE52D9EA2826487075579de011e511注重:这里我们能够看出v$sqlarea和v$sql两个视图的分歧的地方v$sql中为每条sql保存一个条目，而v$sqlarea中依据sql_text举行groupby,经由过程version_count盘算子指针的个数.我们注重到,这两条sql语句由于其代码完整不异,以是其ADDRESS,HASH_VALUE也完整不异.这就意味着,这两条sql语句在sharedpool中的存储地位是不异的(只管其实行企图大概分歧),代码得以共享.在此过程当中Oracle完成sql剖析的第一个步骤:语法剖析Oracle举行语法反省时遵守自右向左,自下向上的准绳,假如发明语法毛病就即刻前往毛病.语法反省经由过程今后,Oracle将sql文本转换为响应的ASCII数值,然后依据数值经由过程Hash函数盘算其HASH_VALUE在sharedpool中寻觅是不是存在不异的sql语句,假如存在,则进进下一步骤;假如不存在则实验猎取sharedpoollatch哀求内存,存储该sql代码在这里有一个成绩必要申明一下:由于巨细写字母的ascii值是分歧的,以是Oracle会把巨细写分歧的代码作为分歧的sql来处置,我们看一下测试:SQL>select*fromscott.dept;DEPTNODNAMELOC-------------------------------------10ACCOUNTINGNEWYORK20RESEARCHDALLAS30SALESCHICAGO40OPERATIONSBOSTONSQL>select*fromscott.DEPT;DEPTNODNAMELOC-------------------------------------10ACCOUNTINGNEWYORK20RESEARCHDALLAS30SALESCHICAGO40OPERATIONSBOSTONSQL>colsql_textfora30SQL>selectsql_text,hash_valuefromv$sqlwheresql_textlikeselect*fromscott%;SQL_TEXTHASH_VALUE----------------------------------------select*fromscott.DEPT4096614922select*fromscott.dept2089404358我们注重到,仅只巨细写的分歧使得底本不异的sql语句酿成了两条"分歧的代码"以是从这里我们能够看出,sql的标准编写十分主要.完成这一个步骤今后,Oracle必要举行的是语义剖析:在此步骤中,Oracle必要考证工具是不是存在,相干用户是不是具有权限,援用的是不是是不异的工具...关于我们第一个查询,实践上emp表来自分歧的用户,那末sql的实行企图也就分歧了固然影响sql实行企图的要素另有良多,包含优化器形式等SQL>selecta.*,to_char(to_hash,xxxxxxxxxx)Hex_HASH_VALUE2fromV$OBJECT_DEPENDENCYawhereto_name=EMP;FROM_ADDFROM_HASHTO_OWNERTO_NAMETO_ADDRETO_HASHTO_TYPEHEX_HASH_VA-------------------------------------------------------------------------------------------------52D9EA282648707557SCOTTEMP52D9DEBC8282280102315dc1aa52D9EA282648707557EYGLEEMP52D82E58193049145327310f63dSQL>ALTERSESSIONSETEVENTSimmediatetracenameLIBRARY_CACHElevel1;Sessionaltered.SQL>ALTERSESSIONSETEVENTSimmediatetracenameLIBRARY_CACHElevel2;Sessionaltered.SQL>ALTERSESSIONSETEVENTSimmediatetracenameLIBRARY_CACHElevel4;Sessionaltered.SQL>ALTERSESSIONSETEVENTSimmediatetracenameLIBRARY_CACHElevel8;Sessionaltered.SQL>ALTERSESSIONSETEVENTSimmediatetracenameLIBRARY_CACHElevel16;Sessionaltered.SQL>ALTERSESSIONSETEVENTSimmediatetracenameLIBRARY_CACHElevel32;Sessionaltered.SQL>ALTERSESSIONSETEVENTSimmediatetracenameLIBRARY_CACHElevel100;Sessionaltered.


此处在分歧级别对sharedpool举行转储.

在转向trace文件之前,我们经由过程下图来看一下LibraryCACHE的布局:



LibraryCacheHandle指向LibraryCacheObject,含工具名,namespace,工夫戳,援用列表,锁定工具及pin工具列表等.

我们从dump文件中看看详细的信息,由以上v$sql视图我们失掉以上查询的hash_value为9de011e5，ADDRESS为52D9EA28

在bucket4851中,我们找到了select*fromemp这条sql语句.





BUCKET4581:LIBRARYOBJECTHANDLE:handle=52d9ea28name=select*fromemphash=9de011e5timestamp=08-26-200410:24:43==>这个hash恰是v$sql中该sql语句的hash_value值namespace=CRSRflags=RON/TIM/PN0/SML/[12010000]kkkk-dddd-llll=0000-0001-0001lock=0pin=0latch#=1lwt=0x52d9ea40[0x52d9ea40,0x52d9ea40]ltm=0x52d9ea48[0x52d9ea48,0x52d9ea48]pwt=0x52d9ea58[0x52d9ea58,0x52d9ea58]ptm=0x52d9eab0[0x52d9eab0,0x52d9eab0]ref=0x52d9ea30[0x52d9ea30,0x52d9ea30]lnd=0x52d9eabc[0x52d9eabc,0x52d9eabc]LIBRARYOBJECT:object=52d9e7b0type=CRSRflags=EXS[0001]pflags=[00]status=VALDload=0CHILDREN:size=16child#tablereferencehandle-------------------------------052d9e96c52d9e6cc52d9e4ac152d9e96c52d9e70c52d885cc==>这就是我们前边提到过的子指针,每一个都指向了一个分歧的handleDATABLOCKS:data#heappointerstatuspinschangealloc(K)size(K)-----------------------------------------------------052d9e9b852d9e838I/-/A0NONE0.861.09==>此处的heap就是指内存地点.==>这里寄存的就是SQL代码及用户毗连信息HEAPDUMPOFDATABLOCK0:******************************************************HEAPDUMPheapname="librarycache"desc=0x52d9e9b8extentsz=0x224alt=32767het=16rec=9flg=2opc=0parent=0x5000002cowner=0x52d9e7b0nex=(nil)xsz=0x224EXTENT0addr=0x52d9e558Chunk52d9e560sz=540perm"perm"alo=44852D9E5605000021D0000000052D9E7A0000001C0[...P.......R....]52D9E57052D9E70452D9E6600002000252D9E57C[...R`..R....|..R]52D9E58052D9E57C0000000052D9E58852D9E588[|..R.......R...R]52D9E5900000000052D9E59452D9E59400000000[.......R...R....]52D9E5A052D9E5A052D9E5A00000000052D9E5AC[...R...R.......R]52D9E5B052D9E5AC0000000052D9E5B852D9E5B8[...R.......R...R]52D9E5C00000000052D9E5C452D9E5C400000000[.......R...R....]52D9E5D052D9E5D052D9E5D00000000052D9E5DC[...R...R.......R]52D9E5E052D9E5DC0000000052D9E5E852D9E5E8[...R.......R...R]52D9E5F00000000052D9E5F452D9E5F400000000[.......R...R....]52D9E60052D9E60052D9E6000000000052D9E60C[...R...R.......R]52D9E61052D9E60C0000000052D9E61852D9E618[...R.......R...R]52D9E6200000000052D9E62452D9E62400000000[....$..R$..R....]52D9E63052D9E63052D9E6300004000400000000[0..R0..R........]52D9E64052D9E6E4000000180000000000000000[...R............]52D9E650000000000000000052D9E63C00000000[........<..R....]52D9E66052D9E57052D9E7040000000000000000[p..R...R........]52D9E6700000000052D9E6BC0000001000000004[.......R........]52D9E68000000000000000000000000000000000[................]Repeat2times52D9E6B000000000000000000000000052D9E96C[............l..R]52D9E6C000000000000000000000000052D9E4B4[...............R]52D9E6D052D9E4B452D9E4AC0000000000000002[...R...R........]52D9E6E000000000000000000001001800000001[................]52D9E6F000000000000000000000000052D9E6E0[...............R]52D9E7000000000052D9E66052D9E57052D885D4[....`..Rp..R...R]52D9E71052D885D452D885CC0000000000000002[...R...R........]52D9E72000000000000000000000000000000000[................]Repeat4times52D9E770000000000000000000000000[............]EXTENT1addr=0x52d9e798Chunk52d9e7a0sz=360perm"perm"alo=36052D9E7A040000169000000000000000000000168[i..@........h...]52D9E7B052D9EA2852D9E7B452D9E7B452D9E7BC[(..R...R...R...R]52D9E7C052D9E7BC52D9E6680000000000010001[...Rh..R........]52D9E7D000000000000000000000000000000000[................]52D9E7E052D9E824000000000000000000000000[$..R............]52D9E7F000000000000000000000000000000000[................]Repeat2times52D9E8200000000052D9E9B80000000052D9E838[.......R....8..R]52D9E8300000000052FF79A40008030400000000[.....y.R........]52D9E84000000100000000000000000000000010[................]52D9E85000000004000000000000000000000000[................]52D9E8600000000052D9E640000000022A4C5153[....@..R....SQL*]52D9E87073756C50706D756A682E726561727275[Plusjumper.hurra]52D9E8806F632E796E632E6D4E54282031562053[y.com.cn(TNSV1]52D9E8902933562D000000000000000000000008[-V3)............]52D9E8A0DABEFA60000000000000000000000000[`...............]52D9E8B000000000000000000000000000000000[................]52D9E8C00000000000000000F031855852D9E8D8[........X.1....R]52D9E8D052D9E6300000000052D9E57000000000[0..R....p..R....]52D9E8E000000000000000000000000000000000[................]52D9E8F00000000000000000000000020000000D[................]52D9E9000000000100000000[........]Chunk52d9e908sz=88free""52D9E900C000005952D9E7A0[Y......R]52D9E91052D9EA0052D9EA000000000000000000[...R...R........]52D9E92000000000000000000000000000000000[................]Repeat3timesChunk52d9e960sz=76freeable"kgltbtab"52D9E9601000004D52D9E9080A85792852D9E6CC[M......R(y.....R]52D9E97052D9E70C000000000000000000000000[...R............]52D9E98000000000000000000000000000000000[................]Repeat1times52D9E9A0000000000000000000000000[............]Totalheapsize=1064FREELISTS:Bucket0size=0Chunk52d9e908sz=88free""52D9E900C000005952D9E7A0[Y......R]52D9E91052D9EA0052D9EA000000000000000000[...R...R........]52D9E92000000000000000000000000000000000[................]Repeat3timesTotalfreespace=88UNPINNEDRECREATABLECHUNKS(lrufirst):PERMANENTCHUNKS:Chunk52d9e560sz=540perm"perm"alo=44852D9E5605000021D0000000052D9E7A0000001C0[...P.......R....]52D9E57052D9E70452D9E6600002000252D9E57C[...R`..R....|..R]52D9E58052D9E57C0000000052D9E58852D9E588[|..R.......R...R]52D9E5900000000052D9E59452D9E59400000000[.......R...R....]52D9E5A052D9E5A052D9E5A00000000052D9E5AC[...R...R.......R]52D9E5B052D9E5AC0000000052D9E5B852D9E5B8[...R.......R...R]52D9E5C00000000052D9E5C452D9E5C400000000[.......R...R....]52D9E5D052D9E5D052D9E5D00000000052D9E5DC[...R...R.......R]52D9E5E052D9E5DC0000000052D9E5E852D9E5E8[...R.......R...R]52D9E5F00000000052D9E5F452D9E5F400000000[.......R...R....]52D9E60052D9E60052D9E6000000000052D9E60C[...R...R.......R]52D9E61052D9E60C0000000052D9E61852D9E618[...R.......R...R]52D9E6200000000052D9E62452D9E62400000000[....$..R$..R....]52D9E63052D9E63052D9E6300004000400000000[0..R0..R........]52D9E64052D9E6E4000000180000000000000000[...R............]52D9E650000000000000000052D9E63C00000000[........<..R....]52D9E66052D9E57052D9E7040000000000000000[p..R...R........]52D9E6700000000052D9E6BC0000001000000004[.......R........]52D9E68000000000000000000000000000000000[................]Repeat2times52D9E6B000000000000000000000000052D9E96C[............l..R]52D9E6C000000000000000000000000052D9E4B4[...............R]52D9E6D052D9E4B452D9E4AC0000000000000002[...R...R........]52D9E6E000000000000000000001001800000001[................]52D9E6F000000000000000000000000052D9E6E0[...............R]52D9E7000000000052D9E66052D9E57052D885D4[....`..Rp..R...R]52D9E71052D885D452D885CC0000000000000002[...R...R........]52D9E72000000000000000000000000000000000[................]Repeat4times52D9E770000000000000000000000000[............]Chunk52d9e7a0sz=360perm"perm"alo=36052D9E7A040000169000000000000000000000168[i..@........h...]52D9E7B052D9EA2852D9E7B452D9E7B452D9E7BC[(..R...R...R...R]52D9E7C052D9E7BC52D9E6680000000000010001[...Rh..R........]52D9E7D000000000000000000000000000000000[................]52D9E7E052D9E824000000000000000000000000[$..R............]52D9E7F000000000000000000000000000000000[................]Repeat2times52D9E8200000000052D9E9B80000000052D9E838[.......R....8..R]52D9E8300000000052FF79A40008030400000000[.....y.R........]52D9E84000000100000000000000000000000010[................]52D9E85000000004000000000000000000000000[................]52D9E8600000000052D9E640000000022A4C5153[....@..R....SQL*]52D9E87073756C50706D756A682E726561727275[Plusjumper.hurra]52D9E8806F632E796E632E6D4E54282031562053[y.com.cn(TNSV1]52D9E8902933562D000000000000000000000008[-V3)............]52D9E8A0DABEFA60000000000000000000000000[`...............]52D9E8B000000000000000000000000000000000[................]52D9E8C00000000000000000F031855852D9E8D8[........X.1....R]52D9E8D052D9E6300000000052D9E57000000000[0..R....p..R....]52D9E8E000000000000000000000000000000000[................]52D9E8F00000000000000000000000020000000D[................]52D9E9000000000100000000[........]Permanentspace=900******************************************************BUCKET4581totalobjectcount=1我们以handle:52d885cc为例看一下LibraryCacheObject的布局:******************************************************LIBRARYOBJECTHANDLE:handle=52d885ccnamespace=CRSRflags=RON/KGHP/PN0/[10010000]kkkk-dddd-llll=0000-0041-0041lock=0pin=0latch#=1lwt=0x52d885e4[0x52d885e4,0x52d885e4]ltm=0x52d885ec[0x52d885ec,0x52d885ec]pwt=0x52d885fc[0x52d885fc,0x52d885fc]ptm=0x52d88654[0x52d88654,0x52d88654]ref=0x52d885d4[0x52d9e70c,0x52d9e70c]lnd=0x52d88660[0x52d88660,0x52d88660]LIBRARYOBJECT:object=52d82a24type=CRSRflags=EXS[0001]pflags=[00]status=VALDload=0DEPENDENCIES:count=1size=16dependency#tablereferencehandlepositionflags---------------------------------------------------------------052d82be052d82b2052d82e5814DEP[01]==>在dependency部分我们看到,这个cursor依附的工具handle:52d82e58==>这个handle指向的就是EYGLE.EMP表，假如以上两个CRSR会见的是统一个工具,那末==>这两个SQL才会是真的共享.这里我们的sql固然是不异的，会见的倒是分歧用户的数据表==>子指针的观点就出来了.==>在这里我们看到52d82e58指向的是EYGLE.EMP这个工具,也就是EYGLE所查询的数据表.ACCESSES:count=1size=16dependency#types----------------00009TRANSLATIONS:count=1size=16originalfinal----------------52d82e5852d82e58DATABLOCKS:data#heappointerstatuspinschangealloc(K)size(K)-----------------------------------------------------052d8c24452d827e4I/-/A0NONE1.091.64652d82ac052d817c4I/-/A0NONE3.703.73==>这里的DataBlocks是个主要的部分==>每一个把持块包括一个heapdescriptor,指向响应的heapmemory,这个heapmemory包括的就是==>DianaTree,P-Code,SourceCode,SharedCursorContextarea等主要数据,也就是我们一般==>所说的，剖析过的SQL及实行企图树,真正到这里今后,sql才得以共享.也就真实的制止了硬==>剖析HEAPDUMPOFDATABLOCK0:******************************************************HEAPDUMPheapname="librarycache"desc=0x52d8c244extentsz=0x224alt=32767het=16rec=9flg=2opc=0parent=0x5000002cowner=0x52d82a24nex=(nil)xsz=0x224EXTENT0addr=0x52d80ff0Chunk52d80ff8sz=464free""52D80FF0C00001D100000000[........]52D8100052D8C28C52D8C28C0000000000000000[...R...R........]52D8101000000000000000000000000000000000[................]Repeat26times52D811C00000000000000000[........]Chunk52d811c8sz=76freeable"kgltbtab"52D811C01000004D52D80FF8[M......R]52D811D00A85792852D82B680000000000000000[(y..h+.R........]52D811E000000000000000000000000000000000[................]Repeat2times52D8121000000000[....]EXTENT1addr=0x52d827ccChunk52d827d4sz=540perm"perm"alo=53252D827D05000021D0000000052D82A14[...P.....*.R]52D827E000000214000000000000001A00000069[............i...]52D827F000000110000000000000000000000006[................]52D8280000000850000000100000000800000005[P...............]52D82810000000054C4759450000004500000000[....EYGLE.......]52D8282000000000000000000000000000000000[................]52D828300005000052D829700000000000000000[....p).R........]52D82840000000694C4759450000004500000000[i...EYGLE.......]52D8285000000000000000000000000000000000[................]52D8286000050000000000010000000400000019[................]52D828700000000B000000000000000200000001[................]52D8288000002DC700000000000030A400000000[.-.......0......]52D8289000000000040000000000000000650000[..............e.]52D828A000100000000500010105010000000001[................]52D828B0000007D0006400000001000001000000[......d.........]52D828C000000404000000000101010101010001[................]52D828D001010101000100010101010100000000[................]52D828E000000202020100000101010001010101[................]52D828F000000000010000010000000000000000[................]52D829000000000000000000000000001A086878[............xh..]52D829100036190B00000000000001C400000000[..6.............]52D8292000000000000000000000000000000000[................]Repeat1times52D8294000022000000000000000FFFFFFFFFFFF[...............]52D829500000000000000000000000001A086878[............xh..]52D829600036190B000000000000000000000000[..6.............]52D8297000000001000000690000007700000002[....i...w.......]52D829800000000352D829D80001001000000004[.....).R........]52D8299000000000000000000000000000000000[................]52D829A0000000000000000052D82B5800010010[........X+.R....]52D829B00000000452D82B400001001000000004[....@+.R........]52D829C000000000000000000000000000000000[................]52D829D0000000000000000052D82BE000000000[.........+.R....]52D829E000000000000000000000000000000000[................]EXTENT2addr=0x52d82a0cChunk52d82a14sz=252perm"perm"alo=25252D82A10400000FD0000000000000000[...@........]52D82A20000000FC52D885CC52D82A2852D82A28[.......R(*.R(*.R]52D82A3052D82A3052D82A3052D8298400000000[0*.R0*.R.).R....]52D82A4000010001000000000000000000000000[................]52D82A500000000052D82A980000000000000000[.....*.R........]52D82A6000000000000000000000000052D82AAC[.............*.R]52D82A7000000000000000000000000000000000[................]Repeat1times52D82A90000000000000000052D8C24400000000[........D..R....]52D82AA052D827E40000000052FF5B7452D82AC0[..R....t[.R.*.R]52D82AB00000000052D817C40004000052FF5B9C[.......R.....[.R]52D82AC05000002C0000102452D82A2452D817AC[,..P$...$*.R...R]52D82AD052D817B40000000052D8237C05010200[...R....|#.R....]52D82AE00000000000000000206C717361657261[........sqlarea]52D82AF0000000000000000000107FFF7FFF7FFF[................]52D82B00000004010000000052D82B0852D82B08[.........+.R.+.R]Chunk52d82b10sz=120perm"perm"alo=10452D82B104000007952D82A1452D827D400000068[y..@.*.R..Rh...]52D82B2052B2D47052B2D47052D82E5800000000[p..Rp..RX..R....]52D82B300000000152D82A240000000E00000001[....$*.R........]52D82B4052D82B94000000000000000000000000[.+.R............]52D82B5052D82E5852D82E5852D811D400000000[X..RX..R...R....]52D82B6000000000000000000000000000000000[................]52D82B7002000000000000000000000000000000[................]52D82B800000000000000000[........]Chunk52d82b88sz=76freeable"kgltbtab"52D82B800000004D52D82B10[M....+.R]52D82B900A85792852D82B500000000000000000[(y..P+.R........]52D82BA000000000000000000000000000000000[................]Repeat2times52D82BD000000000[....]Chunk52d82bd4sz=76freeable"kgltbtab"52D82BD01000004D52D82B880A857928[M....+.R(y..]52D82BE052D82B20000000000000000000000000[+.R............]52D82BF000000000000000000000000000000000[................]Repeat2timesTotalheapsize=1604FREELISTS:Bucket0size=0Chunk52d80ff8sz=464free""52D80FF0C00001D100000000[........]52D8100052D8C28C52D8C28C0000000000000000[...R...R........]52D8101000000000000000000000000000000000[................]Repeat26times52D811C00000000000000000[........]Totalfreespace=464UNPINNEDRECREATABLECHUNKS(lrufirst):PERMANENTCHUNKS:Chunk52d82b10sz=120perm"perm"alo=10452D82B104000007952D82A1452D827D400000068[y..@.*.R..Rh...]52D82B2052B2D47052B2D47052D82E5800000000[p..Rp..RX..R....]52D82B300000000152D82A240000000E00000001[....$*.R........]52D82B4052D82B94000000000000000000000000[.+.R............]52D82B5052D82E5852D82E5852D811D400000000[X..RX..R...R....]52D82B6000000000000000000000000000000000[................]52D82B7002000000000000000000000000000000[................]52D82B800000000000000000[........]Chunk52d827d4sz=540perm"perm"alo=53252D827D05000021D0000000052D82A14[...P.....*.R]52D827E000000214000000000000001A00000069[............i...]52D827F000000110000000000000000000000006[................]52D8280000000850000000100000000800000005[P...............]52D82810000000054C4759450000004500000000[....EYGLE.......]52D8282000000000000000000000000000000000[................]52D828300005000052D829700000000000000000[....p).R........]52D82840000000694C4759450000004500000000[i...EYGLE.......]52D8285000000000000000000000000000000000[................]52D8286000050000000000010000000400000019[................]52D828700000000B000000000000000200000001[................]52D8288000002DC700000000000030A400000000[.-.......0......]52D8289000000000040000000000000000650000[..............e.]52D828A000100000000500010105010000000001[................]52D828B0000007D0006400000001000001000000[......d.........]52D828C000000404000000000101010101010001[................]52D828D001010101000100010101010100000000[................]52D828E000000202020100000101010001010101[................]52D828F000000000010000010000000000000000[................]52D829000000000000000000000000001A086878[............xh..]52D829100036190B00000000000001C400000000[..6.............]52D8292000000000000000000000000000000000[................]Repeat1times52D8294000022000000000000000FFFFFFFFFFFF[...............]52D829500000000000000000000000001A086878[............xh..]52D829600036190B000000000000000000000000[..6.............]52D8297000000001000000690000007700000002[....i...w.......]52D829800000000352D829D80001001000000004[.....).R........]52D8299000000000000000000000000000000000[................]52D829A0000000000000000052D82B5800010010[........X+.R....]52D829B00000000452D82B400001001000000004[....@+.R........]52D829C000000000000000000000000000000000[................]52D829D0000000000000000052D82BE000000000[.........+.R....]52D829E000000000000000000000000000000000[................]Chunk52d82a14sz=252perm"perm"alo=25252D82A10400000FD0000000000000000[...@........]52D82A20000000FC52D885CC52D82A2852D82A28[.......R(*.R(*.R]52D82A3052D82A3052D82A3052D8298400000000[0*.R0*.R.).R....]52D82A4000010001000000000000000000000000[................]52D82A500000000052D82A980000000000000000[.....*.R........]52D82A6000000000000000000000000052D82AAC[.............*.R]52D82A7000000000000000000000000000000000[................]Repeat1times52D82A90000000000000000052D8C24400000000[........D..R....]52D82AA052D827E40000000052FF5B7452D82AC0[..R....t[.R.*.R]52D82AB00000000052D817C40004000052FF5B9C[.......R.....[.R]52D82AC05000002C0000102452D82A2452D817AC[,..P$...$*.R...R]52D82AD052D817B40000000052D8237C05010200[...R....|#.R....]52D82AE00000000000000000206C717361657261[........sqlarea]52D82AF0000000000000000000107FFF7FFF7FFF[................]52D82B00000004010000000052D82B0852D82B08[.........+.R.+.R]Permanentspace=912******************************************************HEAPDUMPOFDATABLOCK6:******************************************************HEAPDUMPheapname="sqlarea"desc=0x52d82ac0extentsz=0x1024alt=32767het=16rec=0flg=2opc=5parent=0x5000002cowner=0x52d82a24nex=(nil)xsz=0x0EXTENT0addr=0x52d817acChunk52d817b4sz=3784perm"perm"alo=378452D817B050000EC90000000000000000[...P........]52D817C000000EC8000000100000000400000010[................]52D817D000000004000000000000000000000000[................]52D817E000000000000000000000000800000000[................]52D817F00000000052D81F5C404EEB2C00000000[......R,.N@....]52D8180000000000000000000000000052D81A08[...............R]52D8181000000000000000000000011000000003[................]52D818200000000000000000000000001A086878[............xh..]52D818300029180B000000000000000000000000[..).............]52D8184052D81C1052D825400000000052D824D4[...R@%.R.....$.R]52D8185000000000000000000000000052D81B7C[............|..R]52D8186000000000000000000000000152D81BFC[...............R]52D8187052D82360000000000000000052D82894[`#.R.........(.R]52D8188000000000000000000000000000000000[................]Repeat1times52D818A000000000000000000800000052D823AC[.............#.R]52D818B000000001000000000000000000000000[................]52D818C000000024000000000000000000000000[$...............]52D818D000000000000000000000000052D81C1C[...............R]52D818E000000000000000000000000052D82620[............&.R]52D818F000000000000000000000000052D81958[............X..R]52D8190000000000000000000000000000000000[................]52D81910000000000000000052D8252C00010001[........,%.R....]52D81920EBCE39A4000000000000000000000000[.9..............]52D8193000000000000000000000000000000001[................]52D8194000000001000007940000000000000001[................]52D8195000000001000000080000000052D817C4[...............R]52D8196000000000000000000000020200000000[................]52D8197052D819B852D819A052D819905001A874[...R...R...Rt..P]52D81980000000000000000052D819FC52D819CC[...........R...R]52D8199052D82AC0404EFB800000000000000000[.*.R..N@........]52D819A0000000000000000052D8195800000000[........X..R....]52D819B000000000000000000000000052D81958[............X..R]52D819C00000000252D885CC0000000052D819E4[.......R.......R]52D819D000000000000000000000000000000000[................]Repeat1times52D819F000000001000000000000000052D81958[............X..R]52D81A0000000000000000004C47594500000045[........EYGLE...]52D81A1000000000000000000000000000000000[................]52D81A200000000000050000000000690000000E[........i.......]52D81A304D450003000000500000000000000500[..EMP...........]52D81A4000000000000000000000000000000000[................]Repeat1times52D81A60404EE794000000000000000000000014[..N@............]52D81A7000000004000000000000000000000000[................]52D81A8000000000000000000000000000000000[................]52D81A9000000000000000000000000000003F09[.............?..]52D81AA000000001000000000000000000000000[................]52D81AB000000000000000690008000800000000[....i...........]52D81AC00868780029180B1A1A0868787829180B[.xh....)xh....)x]52D81AD00B1A0868000029180000000000000000[h....)..........]52D81AE000000000000000000000000000000000[................]52D81AF0000000000000000100000000000002E0[................]52D81B0000000000000000080000000000000000[................]52D81B1000000000404EEC040000000052D81B9C[......N@.......R]52D81B2052D81B9C000000000000000000000000[...R............]52D81B3000000000000000000000000000000000[................]52D81B4000000000000000000000000020000000[...............]52D81B5000000000000000000000000000000000[................]Repeat1times52D81B7000000000000000000000000052D81948[............H..R]52D81B800000000000000002000000080000000E[................]52D81B905945000500454C470000000000000000[..EYGLE.........]52D81BA040548000000000010000006400000000[..T@....d.......]52D81BB000000000000000000000000000000000[................]Repeat1times52D81BD000000000000020000000000000000000[...............]52D81BE000000000000000000000000000000000[................]52D81BF0000000000000000000003F0900000000[.........?......]52D81C0000000014000000040000000100000000[................]52D81C100000000000003F090001000052D81FD4[.....?.........R]52D81C2052D81F0852D81F640000000000000010[...Rd..R........]52D81C3000000007000001000000000000000000[................]52D81C4000000000000000000000000000000010[................]52D81C5000000104000000000000000000000000[................]52D81C6000000000000000000000000000000000[................]52D81C7052D81A2C00000000404EE79400000000[,..R......N@....]52D81C8000000000000000070000010200000000[................]52D81C9000010041000000000000001400000004[A...............]52D81CA000000010000001A00000001600000000[................]52D81CB052D824B4000400000000000052D82300[.$.R.........#.R]52D81CC00000000052D81A2C52D81FC4404EE794[....,..R...R..N@]52D81CD000000000000000000000000052D81C84[...............R]52D81CE000000007000001020000000000010041[............A...]52D81CF000000000000000140000001C00000010[................]52D81D0000000194000000160000000052D82494[.............$.R]52D81D10000400000000000052D822A000000000[.........".R....]52D81D2052D81A2C52D81FB8404EE79400000000[,..R...R..N@....]52D81D300000000052D81CD852D81CE000000007[.......R...R....]52D81D4000000102000000000001004100000000[........A.......]52D81D5000000014000000340000001000000188[....4...........]52D81D60000000160000000052D8247400040000[........t$.R....]52D81D700000000052D822400000000052D81A2C[....@".R....,..R]52D81D8052D81FAC404EE7940000000000000000[...R..N@........]52D81D9052D81D3452D81D3C000000070000010C[4..R<..R........]52D81DA000000000000100410000000000000014[....A...........]52D81DB00000004C000000100000017C00000007[L.......|.......]52D81DC00000000052D824540004000000000000[....T$.R........]52D81DD052D821E00000000052D81A2C52D81F9C[.!.R....,..R...R]52D81DE0404EE794000000000000000052D81D90[..N@...........R]52D81DF052D81D98000000070000010200000000[...R............]52D81E0000010041000000000000001400000054[A...........T...]52D81E1000000010000001700000001600000000[....p...........]52D81E2052D82434000400000000000052D82180[4$.R.........!.R]52D81E300000000052D81A2C52D81F90404EE794[....,..R...R..N@]52D81E40000000000000000052D81DEC52D81DF4[...........R...R]52D81E5000000007000001010001035400010041[........T...A...]52D81E6000040000000000140000006C00000010[........l.......]52D81E7000000164000900090000000052D82414[d............$.R]52D81E80000400000000000052D8212000000000[........!.R....]52D81E9052D81A2C52D81F84404EE79400000000[,..R...R..N@....]52D81EA00000000052D81E4852D81E5000000007[....H..RP..R....]52D81EB000000101000103540001004100040000[....T...A.......]52D81EC000000014000000780000001000000158[....x.......X...]52D81ED0000A000A0000000052D823F400040000[.........#.R....]52D81EE00000000052D820C00000000052D81A2C[......R....,..R]52D81EF052D81F74404EE7940000000000000000[t..R..N@........]52D81F0052D81EA452D81EAC0000000700000102[...R...R........]52D81F1000000000000100410000000000000014[....A...........]52D81F2000000084000000100000014C00000016[........L.......]52D81F300000000052D823D40004000000000000[.....#.R........]52D81F4052D820600000000052D81A2C52D81F64[`.R....,..Rd..R]52D81F50404EE794000000000000000052D81F00[..N@...........R]52D81F6052D81F08000000074D450005004F4E50[...R......EMPNO.]52D81F7000000000000000074E45000500454D41[..........ENAME.]52D81F8000000000000000074F4A000300000042[..........JOB...]52D81F9000000007474D00030000005200000007[......MGR.......]52D81FA049480008414445520000455400000007[..HIREDATE......]52D81FB0415300030000004C000000074F430004[..SAL.........CO]52D81FC000004D4D00000007454400064F4E5450[MM........DEPTNO]52D81FD00000000052D81FE852D81EAC52D81F74[.......R...Rt..R]52D81FE0000000000000001052D81FFC52D81E50[...........RP..R]52D81FF052D81F84000000000000001052D82010[...R..........R]52D8200052D81DF452D81F900000000000000010[...R...R........]52D8201052D8202452D81D9852D81F9C00000000[$.R...R...R....]52D820200000001052D8203852D81D3C52D81FAC[....8.R<..R...R]52D82030000000000000001052D8204C52D81CE0[........L.R...R]52D8204052D81FB8000000000000001000000000[...R............]52D8205052D81C8452D81FC40000000000000010[...R...R........]52D8206000000000000100010002000100000016[................]52D8207000000004000000000000000000000000[................]52D8208000000000000000000000000000000000[................]Repeat2times52D820B000000000000000000000000000003F09[.............?..]52D820C0000000000002000200010002000A000A[................]52D820D000000000000000000000000000000000[................]Repeat2times52D8210000010354000000000000000000000000[T...............]52D8211000000000000000000000000000003F09[.............?..]52D8212000000000000300030001000300090009[................]52D8213000000000000000000000000000000000[................]Repeat2times52D8216000010354000000000000000000000000[T...............]52D8217000000000000000000000000000003F09[.............?..]52D8218000000000000400040002000400000016[................]52D8219000000004000000000000000000000000[................]52D821A000000000000000000000000000000000[................]Repeat2times52D821D000000000000000000000000000003F09[.............?..]52D821E00000000000050005000C000500000007[................]52D821F000000000000000000000000000000000[................]Repeat3times52D8223000000000000000000000000000003F09[.............?..]52D8224000000000000600060002000600000016[................]52D8225000000207000000000000000000000000[................]52D8226000000000000000000000000000000000[................]Repeat2times52D8229000000000000000000000000000003F09[.............?..]52D822A000000000000700070002000700000016[................]52D822B000000207000000000000000000000000[................]52D822C000000000000000000000000000000000[................]Repeat2times52D822F000000000000000000000000000003F09[.............?..]52D8230000000000000800080002000800000016[................]52D8231000000002000000000000000000000000[................]52D8232000000000000000000000000000000000[................]Repeat2times52D8235000000000000000000000000000003F09[.............?..]52D8236000000000000000000000000052D82374[............t#.R]52D8237000003F090000000052D823703EEEEEEE[.?......p#.R...>]52D823800000000052D817B452D8238852D82388[.......R.#.R.#.R]52D8239000000000404EECB8404EECB8404EECB8[......N@..N@..N@]52D823A000000000000000000000000052D81A6C[............l..R]52D823B00000000852D81F0852D81EAC52D81E50[.......R...RP..R]52D823C052D81DF452D81D9852D81D3C52D81CE0[...R...R<..R...R]52D823D052D81C84000000100000014C00000014[...R....L.......]52D823E000000084000000160000000152D82060[............`.R]52D823F000000001000000100000015800000014[........X.......]52D82400000000780000000A0000000252D820C0[x.............R]52D8241000000001000000100000016400000014[........d.......]52D824200000006C000000090000000352D82120[l...........!.R]52D8243000000001000000100000017000000014[........p.......]52D8244000000054000000160000000452D82180[T............!.R]52D8245000000001000000100000017C00000014[........|.......]52D824600000004C000000070000000552D821E0[L............!.R]52D8247000000001000000100000018800000014[................]52D8248000000034000000160000000652D82240[4...........@".R]52D8249000000001000000100000019400000014[................]52D824A00000001C000000160000000752D822A0[.............".R]52D824B00000000100000010000001A000000014[................]52D824C000000004000000160000000852D82300[.............#.R]52D824D00000000152D819380000000400000002[....8..R........]52D824E0000000BC0000000052D81C1C00000008[...........R....]52D824F000000000000000000000000000000000[................]52D8250000000000000000000000001202400791[..............@.]52D8251000003F0900003F090003000000001FE8[.?...?..........]52D8252000000000000001003F09182600000001[........&..?....]52D8253000000010000001AC0000000000000000[................]52D8254000000000000000000000000000000000[................]52D8255052D823B000000010000001D000000017[.#.R............]52D8256052D825240000000100003F0900000000[$%.R.....?......]52D8257000000881000000000000000000000000[................]52D8258000000000000000000000000000000000[................]52D82590000000000000000052D823D400080000[.........#.R....]52D825A000000008000000000000000052D82508[.............%.R]52D825B000000000000000000000001000000270[............p...]52D825C052D823D400000008000000140000009C[.#.R............]52D825D000000000000000000000000052D81ACF[...............R]52D825E000000000000000000000000000000000[................]Repeat3times52D8262052D8263C00000010000006D400000010[<&.R............]52D82630000006F400000010000006F800000010[................]52D82640000006FC000000100000071400000010[................]52D8265000000720000000100000072C00000010[.......,.......]52D8266000000744000000100000074C00000010[D.......L.......]52D8267000000764000000100000077C[d.......|...]Totalheapsize=3784FREELISTS:Bucket0size=0Totalfreespace=0UNPINNEDRECREATABLECHUNKS(lrufirst):PERMANENTCHUNKS:Chunk52d817b4sz=3784perm"perm"alo=378452D817B050000EC90000000000000000[...P........]52D817C000000EC8000000100000000400000010[................]52D817D000000004000000000000000000000000[................]52D817E000000000000000000000000800000000[................]52D817F00000000052D81F5C404EEB2C00000000[......R,.N@....]52D8180000000000000000000000000052D81A08[...............R]52D8181000000000000000000000011000000003[................]52D818200000000000000000000000001A086878[............xh..]52D818300029180B000000000000000000000000[..).............]52D8184052D81C1052D825400000000052D824D4[...R@%.R.....$.R]52D8185000000000000000000000000052D81B7C[............|..R]52D8186000000000000000000000000152D81BFC[...............R]52D8187052D82360000000000000000052D82894[`#.R.........(.R]52D8188000000000000000000000000000000000[................]Repeat1times52D818A000000000000000000800000052D823AC[.............#.R]52D818B000000001000000000000000000000000[................]52D818C000000024000000000000000000000000[$...............]52D818D000000000000000000000000052D81C1C[...............R]52D818E000000000000000000000000052D82620[............&.R]52D818F000000000000000000000000052D81958[............X..R]52D8190000000000000000000000000000000000[................]52D81910000000000000000052D8252C00010001[........,%.R....]52D81920EBCE39A4000000000000000000000000[.9..............]52D8193000000000000000000000000000000001[................]52D8194000000001000007940000000000000001[................]52D8195000000001000000080000000052D817C4[...............R]52D8196000000000000000000000020200000000[................]52D8197052D819B852D819A052D819905001A874[...R...R...Rt..P]52D81980000000000000000052D819FC52D819CC[...........R...R]52D8199052D82AC0404EFB800000000000000000[.*.R..N@........]52D819A0000000000000000052D8195800000000[........X..R....]52D819B000000000000000000000000052D81958[............X..R]52D819C00000000252D885CC0000000052D819E4[.......R.......R]52D819D000000000000000000000000000000000[................]Repeat1times52D819F000000001000000000000000052D81958[............X..R]52D81A0000000000000000004C47594500000045[........EYGLE...]52D81A1000000000000000000000000000000000[................]52D81A200000000000050000000000690000000E[........i.......]52D81A304D450003000000500000000000000500[..EMP...........]52D81A4000000000000000000000000000000000[................]Repeat1times52D81A60404EE794000000000000000000000014[..N@............]52D81A7000000004000000000000000000000000[................]52D81A8000000000000000000000000000000000[................]52D81A9000000000000000000000000000003F09[.............?..]52D81AA000000001000000000000000000000000[................]52D81AB000000000000000690008000800000000[....i...........]52D81AC00868780029180B1A1A0868787829180B[.xh....)xh....)x]52D81AD00B1A0868000029180000000000000000[h....)..........]52D81AE000000000000000000000000000000000[................]52D81AF0000000000000000100000000000002E0[................]52D81B0000000000000000080000000000000000[................]52D81B1000000000404EEC040000000052D81B9C[......N@.......R]52D81B2052D81B9C000000000000000000000000[...R............]52D81B3000000000000000000000000000000000[................]52D81B4000000000000000000000000020000000[...............]52D81B5000000000000000000000000000000000[................]Repeat1times52D81B7000000000000000000000000052D81948[............H..R]52D81B800000000000000002000000080000000E[................]52D81B905945000500454C470000000000000000[..EYGLE.........]52D81BA040548000000000010000006400000000[..T@....d.......]52D81BB000000000000000000000000000000000[................]Repeat1times52D81BD000000000000020000000000000000000[...............]52D81BE000000000000000000000000000000000[................]52D81BF0000000000000000000003F0900000000[.........?......]52D81C0000000014000000040000000100000000[................]52D81C100000000000003F090001000052D81FD4[.....?.........R]52D81C2052D81F0852D81F640000000000000010[...Rd..R........]52D81C3000000007000001000000000000000000[................]52D81C4000000000000000000000000000000010[................]52D81C5000000104000000000000000000000000[................]52D81C6000000000000000000000000000000000[................]52D81C7052D81A2C00000000404EE79400000000[,..R......N@....]52D81C8000000000000000070000010200000000[................]52D81C9000010041000000000000001400000004[A...............]52D81CA000000010000001A00000001600000000[................]52D81CB052D824B4000400000000000052D82300[.$.R.........#.R]52D81CC00000000052D81A2C52D81FC4404EE794[....,..R...R..N@]52D81CD000000000000000000000000052D81C84[...............R]52D81CE000000007000001020000000000010041[............A...]52D81CF000000000000000140000001C00000010[................]52D81D0000000194000000160000000052D82494[.............$.R]52D81D10000400000000000052D822A000000000[.........".R....]52D81D2052D81A2C52D81FB8404EE79400000000[,..R...R..N@....]52D81D300000000052D81CD852D81CE000000007[.......R...R....]52D81D4000000102000000000001004100000000[........A.......]52D81D5000000014000000340000001000000188[....4...........]52D81D60000000160000000052D8247400040000[........t$.R....]52D81D700000000052D822400000000052D81A2C[....@".R....,..R]52D81D8052D81FAC404EE7940000000000000000[...R..N@........]52D81D9052D81D3452D81D3C000000070000010C[4..R<..R........]52D81DA000000000000100410000000000000014[....A...........]52D81DB00000004C000000100000017C00000007[L.......|.......]52D81DC00000000052D824540004000000000000[....T$.R........]52D81DD052D821E00000000052D81A2C52D81F9C[.!.R....,..R...R]52D81DE0404EE794000000000000000052D81D90[..N@...........R]52D81DF052D81D98000000070000010200000000[...R............]52D81E0000010041000000000000001400000054[A...........T...]52D81E1000000010000001700000001600000000[....p...........]52D81E2052D82434000400000000000052D82180[4$.R.........!.R]52D81E300000000052D81A2C52D81F90404EE794[....,..R...R..N@]52D81E40000000000000000052D81DEC52D81DF4[...........R...R]52D81E5000000007000001010001035400010041[........T...A...]52D81E6000040000000000140000006C00000010[........l.......]52D81E7000000164000900090000000052D82414[d............$.R]52D81E80000400000000000052D8212000000000[........!.R....]52D81E9052D81A2C52D81F84404EE79400000000[,..R...R..N@....]52D81EA00000000052D81E4852D81E5000000007[....H..RP..R....]52D81EB000000101000103540001004100040000[....T...A.......]52D81EC000000014000000780000001000000158[....x.......X...]52D81ED0000A000A0000000052D823F400040000[.........#.R....]52D81EE00000000052D820C00000000052D81A2C[......R....,..R]52D81EF052D81F74404EE7940000000000000000[t..R..N@........]52D81F0052D81EA452D81EAC0000000700000102[...R...R........]52D81F1000000000000100410000000000000014[....A...........]52D81F2000000084000000100000014C00000016[........L.......]52D81F300000000052D823D40004000000000000[.....#.R........]52D81F4052D820600000000052D81A2C52D81F64[`.R....,..Rd..R]52D81F50404EE794000000000000000052D81F00[..N@...........R]52D81F6052D81F08000000074D450005004F4E50[...R......EMPNO.]52D81F7000000000000000074E45000500454D41[..........ENAME.]52D81F8000000000000000074F4A000300000042[..........JOB...]52D81F9000000007474D00030000005200000007[......MGR.......]52D81FA049480008414445520000455400000007[..HIREDATE......]52D81FB0415300030000004C000000074F430004[..SAL.........CO]52D81FC000004D4D00000007454400064F4E5450[MM........DEPTNO]52D81FD00000000052D81FE852D81EAC52D81F74[.......R...Rt..R]52D81FE0000000000000001052D81FFC52D81E50[...........RP..R]52D81FF052D81F84000000000000001052D82010[...R..........R]52D8200052D81DF452D81F900000000000000010[...R...R........]52D8201052D8202452D81D9852D81F9C00000000[$.R...R...R....]52D820200000001052D8203852D81D3C52D81FAC[....8.R<..R...R]52D82030000000000000001052D8204C52D81CE0[........L.R...R]52D8204052D81FB8000000000000001000000000[...R............]52D8205052D81C8452D81FC40000000000000010[...R...R........]52D8206000000000000100010002000100000016[................]52D8207000000004000000000000000000000000[................]52D8208000000000000000000000000000000000[................]Repeat2times52D820B000000000000000000000000000003F09[.............?..]52D820C0000000000002000200010002000A000A[................]52D820D000000000000000000000000000000000[................]Repeat2times52D8210000010354000000000000000000000000[T...............]52D8211000000000000000000000000000003F09[.............?..]52D8212000000000000300030001000300090009[................]52D8213000000000000000000000000000000000[................]Repeat2times52D8216000010354000000000000000000000000[T...............]52D8217000000000000000000000000000003F09[.............?..]52D8218000000000000400040002000400000016[................]52D8219000000004000000000000000000000000[................]52D821A000000000000000000000000000000000[................]Repeat2times52D821D000000000000000000000000000003F09[.............?..]52D821E00000000000050005000C000500000007[................]52D821F000000000000000000000000000000000[................]Repeat3times52D8223000000000000000000000000000003F09[.............?..]52D8224000000000000600060002000600000016[................]52D8225000000207000000000000000000000000[................]52D8226000000000000000000000000000000000[................]Repeat2times52D8229000000000000000000000000000003F09[.............?..]52D822A000000000000700070002000700000016[................]52D822B000000207000000000000000000000000[................]52D822C000000000000000000000000000000000[................]Repeat2times52D822F000000000000000000000000000003F09[.............?..]52D8230000000000000800080002000800000016[................]52D8231000000002000000000000000000000000[................]52D8232000000000000000000000000000000000[................]Repeat2times52D8235000000000000000000000000000003F09[.............?..]52D8236000000000000000000000000052D82374[............t#.R]52D8237000003F090000000052D823703EEEEEEE[.?......p#.R...>]52D823800000000052D817B452D8238852D82388[.......R.#.R.#.R]52D8239000000000404EECB8404EECB8404EECB8[......N@..N@..N@]52D823A000000000000000000000000052D81A6C[............l..R]52D823B00000000852D81F0852D81EAC52D81E50[.......R...RP..R]52D823C052D81DF452D81D9852D81D3C52D81CE0[...R...R<..R...R]52D823D052D81C84000000100000014C00000014[...R....L.......]52D823E000000084000000160000000152D82060[............`.R]52D823F000000001000000100000015800000014[........X.......]52D82400000000780000000A0000000252D820C0[x.............R]52D8241000000001000000100000016400000014[........d.......]52D824200000006C000000090000000352D82120[l...........!.R]52D8243000000001000000100000017000000014[........p.......]52D8244000000054000000160000000452D82180[T............!.R]52D8245000000001000000100000017C00000014[........|.......]52D824600000004C000000070000000552D821E0[L............!.R]52D8247000000001000000100000018800000014[................]52D8248000000034000000160000000652D82240[4...........@".R]52D8249000000001000000100000019400000014[................]52D824A00000001C000000160000000752D822A0[.............".R]52D824B00000000100000010000001A000000014[................]52D824C000000004000000160000000852D82300[.............#.R]52D824D00000000152D819380000000400000002[....8..R........]52D824E0000000BC0000000052D81C1C00000008[...........R....]52D824F000000000000000000000000000000000[................]52D8250000000000000000000000001202400791[..............@.]52D8251000003F0900003F090003000000001FE8[.?...?..........]52D8252000000000000001003F09182600000001[........&..?....]52D8253000000010000001AC0000000000000000[................]52D8254000000000000000000000000000000000[................]52D8255052D823B000000010000001D000000017[.#.R............]52D8256052D825240000000100003F0900000000[$%.R.....?......]52D8257000000881000000000000000000000000[................]52D8258000000000000000000000000000000000[................]52D82590000000000000000052D823D400080000[.........#.R....]52D825A000000008000000000000000052D82508[.............%.R]52D825B000000000000000000000001000000270[............p...]52D825C052D823D400000008000000140000009C[.#.R............]52D825D000000000000000000000000052D81ACF[...............R]52D825E000000000000000000000000000000000[................]Repeat3times52D8262052D8263C00000010000006D400000010[<&.R............]52D82630000006F400000010000006F800000010[................]52D82640000006FC000000100000071400000010[................]52D8265000000720000000100000072C00000010[.......,.......]52D8266000000744000000100000074C00000010[D.......L.......]52D8267000000764000000100000077C[d.......|...]Permanentspace=3784MARKS:Mark0x52d8237c******************************************************这里的handle=52d82e58就是sql依附的工具信息:BUCKET63037:LIBRARYOBJECTHANDLE:handle=52d82e58name=EYGLE.EMPhash=7310f63dtimestamp=08-26-200410:23:40namespace=TABL/PRCD/TYPEflags=KGHP/TIM/SML/[02000000]kkkk-dddd-llll=0000-0501-0501lock=0pin=0latch#=1lwt=0x52d82e70[0x52d82e70,0x52d82e70]ltm=0x52d82e78[0x52d82e78,0x52d82e78]pwt=0x52d82e88[0x52d82e88,0x52d82e88]ptm=0x52d82ee0[0x52d82ee0,0x52d82ee0]ref=0x52d82e60[0x52d82e60,0x52d82e60]lnd=0x52d82eec[0x52d7dcf0,0x52d89fc8]LIBRARYOBJECT:object=52d81594type=TABLflags=EXS/LOC[0005]pflags=[00]status=VALDload=0==>Type:工具范例,这里是一张表==>flags:代表工具形态DATABLOCKS:data#heappointerstatuspinschangealloc(K)size(K)-----------------------------------------------------052d8c1e452d8161cI/-/A0NONE0.661.09852d8123852d80a18I/-/A0NONE1.101.131052d8129c52d80ea0I/-/A0NONE0.120.37HEAPDUMPOFDATABLOCK0:******************************************************HEAPDUMPheapname="librarycache"desc=0x52d8c1e4extentsz=0x224alt=32767het=16rec=9flg=2opc=0parent=0x5000002cowner=0x52d81594nex=(nil)xsz=0x224==>每一个heapdescriptor都包括一个owner部分，指向一切者，这里的52d81594也就是EYGLE.EMP==>指向的Library工具:LIBRARYOBJECT:object=52d81594EXTENT0addr=0x52d81220Chunk52d81228sz=540perm"perm"alo=19652D812205000021D00000000[...P....]52D8123052D81584000000C45000002C00000824[...R....,..P$...]52D8124052D8159452D80A0052D80A0800000000[...R...R...R....]52D8125000000000050102000000000000000000[................]52D81260534C474B616568200000007000000000[KGLSheap.......]52D8127000107FFF7FFF7FFF0000040100000000[................]52D8128052D8128052D8128052D8129C00000000[...R...R...R....]52D8129052D80EA00004000052FF5C145000002C[...R......R,..P]52D812A00000082452D8159452D80E8852D80E90[$......R...R...R]52D812B000000000000000000501020000000000[................]52D812C00000015C534C474B6165682000000070[...KGLSheap...]52D812D00000000000107FFF7FFF7FFF00000401[................]52D812E00000000052D812E452D812E400000000[.......R...R....]52D812F000000000000000000000000000000000[................]Repeat20times52D8144000000000[....]EXTENT1addr=0x52d8157cChunk52d81584sz=484perm"perm"alo=48452D81580400001E50000000000000000[...@........]52D81590000001E452D82E5852D8159852D81598[....X..R...R...R]52D815A052D815A052D815A00000000000000000[...R...R........]52D815B000010005000000000000000000000000[................]52D815C00200000052D816080000000000000000[.......R........]52D815D000000000000000000000000000000000[................]52D815E00000000052D817540000000052D81288[....T..R.......R]52D815F000000000000000000000000000000000[................]52D81600000000000000000052D8C1E400000000[...........R....]52D8161052D8161C0000000052FF5BC400000006[...R.....[.R....]52D816200000000052D816500000000000000000[....P..R........]52D8163000003F0900003F090000000000000000[.?...?..........]52D8164000000000000000000000006900000000[........i.......]52D8165020000000000000010008000800000008[...............]52D81660000000002D2D2D2D2D2D2D2D2D2D2D2D[....------------]52D816702D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D[----------------]52D816802D2D2D2D000000120240079100000000[----......@.....]52D8169000000000000000000000000000000000[................]Repeat3times52D816D0000000000001280A000000FF00000000[.....(..........]52D816E040548000000000010000006400000000[..T@....d.......]52D816F000000000000000000000000000000000[................]52D8170000000000000000000000000000000001[................]52D8171000000000000000000000000100000001[................]52D817200000000000000000000002E000000000[................]52D8173000000000000000000000000000000000[................]52D81740FFFFFFFFFFFFFFFF68780000180B1A08[..........xh....]52D817500000002952D812380000000052D80A18[)...8..R.......R]52D817600004000052FF5BEC[.....[.R]Chunk52d81768sz=40free""52D81760D000002952D81584[)......R]52D8177052D8C22C52D8C22C0000000000000000[,..R,..R........]52D8178000000000000000000000000000000000[................]Totalheapsize=1064FREELISTS:Bucket0size=0Chunk52d81768sz=40free""52D81760D000002952D81584[)......R]52D8177052D8C22C52D8C22C0000000000000000[,..R,..R........]52D8178000000000000000000000000000000000[................]Totalfreespace=40UNPINNEDRECREATABLECHUNKS(lrufirst):PERMANENTCHUNKS:Chunk52d81228sz=540perm"perm"alo=19652D812205000021D00000000[...P....]52D8123052D81584000000C45000002C00000824[...R....,..P$...]52D8124052D8159452D80A0052D80A0800000000[...R...R...R....]52D8125000000000050102000000000000000000[................]52D81260534C474B616568200000007000000000[KGLSheap.......]52D8127000107FFF7FFF7FFF0000040100000000[................]52D8128052D8128052D8128052D8129C00000000[...R...R...R....]52D8129052D80EA00004000052FF5C145000002C[...R......R,..P]52D812A00000082452D8159452D80E8852D80E90[$......R...R...R]52D812B000000000000000000501020000000000[................]52D812C00000015C534C474B6165682000000070[...KGLSheap...]52D812D00000000000107FFF7FFF7FFF00000401[................]52D812E00000000052D812E452D812E400000000[.......R...R....]52D812F000000000000000000000000000000000[................]Repeat20times52D8144000000000[....]Chunk52d81584sz=484perm"perm"alo=48452D81580400001E50000000000000000[...@........]52D81590000001E452D82E5852D8159852D81598[....X..R...R...R]52D815A052D815A052D815A00000000000000000[...R...R........]52D815B000010005000000000000000000000000[................]52D815C00200000052D816080000000000000000[.......R........]52D815D000000000000000000000000000000000[................]52D815E00000000052D817540000000052D81288[....T..R.......R]52D815F000000000000000000000000000000000[................]52D81600000000000000000052D8C1E400000000[...........R....]52D8161052D8161C0000000052FF5BC400000006[...R.....[.R....]52D816200000000052D816500000000000000000[....P..R........]52D8163000003F0900003F090000000000000000[.?...?..........]52D8164000000000000000000000006900000000[........i.......]52D8165020000000000000010008000800000008[...............]52D81660000000002D2D2D2D2D2D2D2D2D2D2D2D[....------------]52D816702D2D2D2D2D2D2D2D2D2D2D2D2D2D2D2D[----------------]52D816802D2D2D2D000000120240079100000000[----......@.....]52D8169000000000000000000000000000000000[................]Repeat3times52D816D0000000000001280A000000FF00000000[.....(..........]52D816E040548000000000010000006400000000[..T@....d.......]52D816F000000000000000000000000000000000[................]52D8170000000000000000000000000000000001[................]52D8171000000000000000000000000100000001[................]52D817200000000000000000000002E000000000[................]52D8173000000000000000000000000000000000[................]52D81740FFFFFFFFFFFFFFFF68780000180B1A08[..........xh....]52D817500000002952D812380000000052D80A18[)...8..R.......R]52D817600004000052FF5BEC[.....[.R]Permanentspace=1024******************************************************HEAPDUMPOFDATABLOCK8:******************************************************HEAPDUMPheapname="KGLSheap"desc=0x52d81238extentsz=0x824alt=32767het=16rec=0flg=2opc=5parent=0x5000002cowner=0x52d81594nex=(nil)xsz=0x0EXTENT0addr=0x52d80a00Chunk52d80a08sz=1124perm"perm"alo=112452D80A005000046500000000[e..P....]52D80A1000000000000004640000000000000007[....d...........]52D80A20000004540000000052D80E0052D80B0C[T..........R...R]52D80A3052D80A3052D80A300000000000000008[0..R0..R........]52D80A400000000352D80A4452D80A4452D80A4C[....D..RD..RL..R]52D80A5052D80A4C000000000000000000000023[L..R........#...]52D80A6052D80A6052D80A6052D80A6852D80A68[`..R`..Rh..Rh..R]52D80A7000000000000000000000003252D80A7C[........2...|..R]52D80A8052D80A7C52D80A8452D80A8400000000[|..R...R...R....]52D80A90000000000000003352D80A9852D80A98[....3......R...R]52D80AA052D80AA052D80AA00000000000000000[...R...R........]52D80AB00000002C52D80AB452D80AB452D80ABC[,......R...R...R]52D80AC052D80ABC000000000000000000000035[...R........5...]52D80AD052D80AD052D80AD052D80AD852D80AD8[...R...R...R...R]52D80AE000000000000000000000000000000000[................]Repeat1times52D80B0000000000000000000000000052D80A28[............(..R]52D80B1052D80B7800000000454400064F4E5450[x..R......DEPTNO]52D80B2000000000000000000000000000000000[................]52D80B3000000000000000000008000800160002[................]52D80B4000000200000000080000000000000000[................]52D80B5000000000000000000000000000000000[................]Repeat1times52D80B70000000000000000052D80B0C52D80BE4[...........R...R]52D80B80000000004F43000400004D4D00000000[......COMM......]52D80B9000000000000000000000000000000000[................]52D80BA000000000000700070016000200020700[................]52D80BB000000007000000000000000000000000[................]52D80BC000000000000000000000000000000000[................]Repeat1times52D80BE00000000052D80B7852D80C5000000000[....x..RP..R....]52D80BF0415300030000004C0000000000000000[..SAL...........]52D80C0000000000000000000000000000000000[................]52D80C1000060006001600020002070000000006[................]52D80C2000000000000000000000000000000000[................]Repeat2times52D80C5052D80BE452D80CBC0000000049480008[...R...R......HI]52D80C6041444552000045540000000000000000[REDATE..........]52D80C7000000000000000000000000000050005[................]52D80C800007000C000000000000000500000000[................]52D80C9000000000000000000000000000000000[................]Repeat1times52D80CB000000000000000000000000052D80C50[............P..R]52D80CC052D80D2800000000474D000300000052[(..R......MGR...]52D80CD000000000000000000000000000000000[................]52D80CE000000000000000000004000400160002[................]52D80CF000000400000000040000000000000000[................]52D80D0000000000000000000000000000000000[................]Repeat1times52D80D20000000000000000052D80CBC52D80D94[...........R...R]52D80D30000000004F4A00030000004200000000[......JOB.......]52D80D4000000000000000000000000000000000[................]52D80D5000000000000300030009000100000000[................]52D80D6000000003000000000001035400090000[........T.......]52D80D7000000000000000000000000000000000[................]Repeat1times52D80D900000000052D80D2852D80E0000000000[....(..R...R....]52D80DA04E45000500454D410000000000000000[..ENAME.........]52D80DB000000000000000000000000000000000[................]52D80DC000020002000A00010000000000000002[........“数据行级锁定”的意思是指在事务操作的执行过程中锁定正在被处理的个别记录，不让其他用户进行访问。这种锁定将影响到（但不限于）SELECT、LOCKINSHAREMODE、SELECT、FORUPDATE命令以及INSERT、UPDATE和DELETE命令。

光写几个SQL实在叫无知。

呵呵，这就是偶想说的

还不是性能有问题！否则面向对象的数据库早就实现了！建议使用CLR的地方一般是和应用的复杂程度或操作系统环境有很高的耦合度的场景。如你想构建复杂的算法，并且用到了大量的指针和高级数据模型。

个人感觉没有case直观。而且默认的第三字段（还可能更多）作为groupby字段很容易造成新手的错误。

而SQLServer如果能像Oracle一样可以为登陆分配如：5%的cpu，10%的内存。就可以解决这个漏洞。

XML字段类型更好的解决了XML数据的操作。XQuery确实不错，但是个人对其没好感。（CSDN的开发者应该是相当的熟了！）

而写到本地,我又考虑到效率问题.大家来讨论讨论吧,分数不打紧,就给10分,十全十美,没啥对错,各抒己见,但是要有说服力的哦~

而SQLServer如果能像Oracle一样可以为登陆分配如：5%的cpu，10%的内存。就可以解决这个漏洞。