]]>
棣栧厛鍒涘緩涓や釜嫻嬭瘯琛細
create table test_long (a int primary key,b long);
create table test_clob (a int primary key,b clob);
鐢ㄩ檮浠秊ava浠ｇ爜錛屽線涓や釜琛ㄩ噷闈㈠悇鎻掑叆100鏉℃暟鎹紝淇濊瘉鎻掑叆鏁版嵁鏄竴鏍風殑錛宭ob瀛楁闀垮害涓?0k錛堝鏋滃皬浜?k錛宱racle鍙互鎶婂畠淇濆瓨鍒板埌琛ㄥ唴錛屼笉浼氬瓨鍌ㄥ湪琛ㄥ錛屾ц兘娌℃湁闂錛岃繖涓垜鍩烘湰紜畾錛岃屼笖鎴戜滑搴旂敤涓繖涓瓧孌電粡甯鎬細瓚呰繃4k錛夈?
鍋氫竴涓畝鍗曟煡璇㈠姣斾竴涓嬶細
SQL> set autotrace traceonly;
SQL> select * from test_clob where a=1;
緇熻淇℃伅
----------------------------------------------------------
331 recursive calls
0 db block gets
69 consistent gets
4 physical reads
0 redo size
1278 bytes sent via SQL*Net to client
837 bytes received via SQL*Net from client
5 SQL*Net roundtrips to/from client
12 sorts (memory)
0 sorts (disk)
1 rows processed
SQL> select * from test_long where a=1;
緇熻淇℃伅
----------------------------------------------------------
236 recursive calls
0 db block gets
43 consistent gets
0 physical reads
0 redo size
675 bytes sent via SQL*Net to client
531 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
5 sorts (memory)
0 sorts (disk)
1 rows processed
瀵規瘮涓涓嬶紝long寮閿姣攍ob灝忥紝褰撶劧浣犲彲浠ユ妸lob瀛楁鍚敤緙撳瓨錛屾妸4嬈＄墿鐞嗚鍘繪帀錛屼絾榪樻槸澶氫簡錛?3-43錛夋閫昏緫璇伙紝update涔熻瘯浜嗕竴涓嬶紝lob浜х敓鐨剅edo姣攍ong澶э紝灝變笉鍒楀嚭鏉ヤ簡錛屾湁鍏磋叮鐨勫彲浠ヨ嚜宸辮瘯璇?
嫻嬭瘯涓嬫潵錛岀湅鏉ヤ箣鍓嶇殑璁よ瘑涓嶅錛屼笉紜畾鐨勪笢瑗挎渶濂借繕鏄姩鎵嬭瘯璇曪紝褰撶劧瀵逛簬鏂板簲鐢紝榪樻槸涓嶅緩璁敤long錛屾瘯绔無racle宸茬粡搴熷純瀹冧簡銆?
]]>
涔熷氨鏄錛屾湇鍔″櫒鐨勮繛鎺ユ暟宸茬粡婊′簡錛屽緢澶氭椂鍊欙紝鍙兘鏄埆浜哄紓甯告柇寮榪炴帴錛屽鑷磋繛鎺ユ病鏈夐噴鏀撅紝涓鑸繖鏃跺欎綘闇瑕佸幓鏈烘埧鐧誨叆鏈嶅姟鍣ㄦ柇寮榪炴帴錛屽叾瀹瀢indows鎻愪緵浜唗sdiscon鍛戒護鏉ュ仛榪欎簨鎯?/p>
]]>
1銆佹斂搴滃弽鏄犻潪甯歌繀閫?br /> 2銆佸瓙寮熷叺鐪熷ソ
2銆佹湁涓涓ソ鎬葷悊
3銆佸湴鏂規斂搴滀笉浣滀負錛屽畼璇濆璇濓紙琚噰璁跨殑閭ｄ釜浠涔堜綍褰紝鐪熸兂鎶戒斧鐨勶級
4銆佷負浠涔堟繪槸瀛︽牎錛熷浜庡湴鍧澶氬彂鍦板甫鐨勫鏍″拰鍏朵粬鍏叡璁炬柦涓轟粈涔堥兘鏄眴鑵愭福
涓烘墍鏈夊彈闅劇殑浜虹紲鳳紒涓烘垜浠ケ鍙楃（闅劇殑紲栧浗紲堢シ錛?br />
鍏徃鍛樺伐鎹愭20W錛屽敖鐐圭壞鍔?br />
]]>
鍚庨潰鍐嶉噸鏂版祴璇曠殑鏃跺欙紝鍔犱笂浜唃c log錛岀敤gc鍒嗘瀽宸ュ叿鍒嗘瀽浜嗕竴涓媑c鐨勫悶鍚愰噺錛屽彂鐜板悶鍚愰噺濂囦綆錛岀珶鐒跺彧鏈?7%宸﹀彸錛屽緢鏄鎬紝鐪嬩簡涓涓媑c鏃ュ織錛屾墍鏈夐兘鏄痝lobal gc錛?鎬鐤慻c絳栫暐鏈夐棶棰橈紝鏌ヤ簡涓涓嬭祫鏂欙紝鍙傝冧簡涓嬮潰涓綃囨枃绔狅細 闃呰鍏ㄦ枃
]]>
涓涓敤鎴峰湪鏌愪釜鏃墮棿鐐逛笂褰撶劧鍙兘鍙戣搗涓涓敤鎴瘋姹傦紝涓涓敤鎴瘋姹傚氨鏄竴涓茍鍙?br>
鎴戜滑涓鑸籂緙犲湪鍚屼竴浜嬬墿騫跺彂榪樻槸涓嶅悓浜嬪姟騫跺彂銆?br>
鍙兘鍦ㄤ竴涓椂闂寸偣涓婏紝鏈?00涓敤鎴峰湪鍙戦佹祻瑙堬紝鏌ヨ鍔ㄤ綔錛?0涓敤鎴峰湪涓嬭鍗曪紝5涓敤鎴峰湪鍋氫粯嬈懼姩浣滐紝浣犺榪欎釜鏃墮棿鐐逛笂鏈夊灝戜釜騫跺彂璇鋒眰錛屽綋鐒舵槸115涓簡
琛￠噺涓涓郴緇熸ц兘涓昏闈犵殑灝辨槸榪欎釜鍚炲悙閲忥紙tps錛?br>
褰撶劧鎴戜滑涔熼潪甯稿叧蹇冨悓鏃?00涓敤鎴峰茍鍙戜笅璁㈠崟鐨勬椂鍊欑郴緇熸槸鍚﹁兘鏀拺錛堣繖鏄氬父鎴戜滑澶ч儴鍒嗕漢鐞嗚В鐨勫茍鍙戯級錛屾垜浠細璇磋繖鏄牳蹇冧笟鍔★紝鎴戜滑瑕佸緱鍑烘暟鎹紙鏄惁瑕佽冭檻鑳屾櫙涓氬姟鍛紝鍛靛懙錛屽緢闅捐鐨勬竻妤氾紝鎴戜竴鑸氨涓嶈冭檻錛?/p>
鏍規嵁鐜錛?4bit Solaris + 32bit JDK錛夛紝瀹㈡埛鎶奌eap鏈澶ц緗負2G錛屽紑濮嬫鐤?2bit JDK鏃犳硶鍒嗛厤榪欎箞澶х殑Heap錛岀粡榪囬獙璇侊紝涓嶅瓨鍦ㄨ繖鏍風殑闂錛坰un緗戠珯涔熸湁鐩稿叧璇存槑錛屽湪solaris 64bit緋葷粺涓婏紝32bit jdk鏈澶у彲浠ヨ緗埌4G錛?/p>
浣嗘槸浠巇ump鐪嬪埌application classes loader澶у皬宸茬粡鍒頒簡60M浠ヤ笂錛屾湁鐐規鐤慞erm鍖鴻緗お灝忓鑷達紝鏌ヤ簡涓涓媠un鐨勬枃妗ｏ紝Perm鍖虹己鐪佸ぇ灝忎負64M錛屼及璁℃槸搴旂敤鍔犺澆澶classes瀵艱嚧Perm鍖烘孩鍑猴紝
鎴戜滑涔熺畝鍗曟ā鎷熶簡涓涓婸erm婧㈠嚭錛屽己鍒惰緗甿ax perm澶у皬涓?2M錛屽茍瀵笹C榪涜浜嗙洃鎺э紝緇撴灉鍜屾垜浠鎯崇殑涓鑷達紝鐪嬩笅闈㈢殑gc log錛?
151.836: [Full GC 151.836: [Tenured: 25735K->25736K(1048576K), 0.8380858 secs] 25911K->25736K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8382804 secs]
152.676: [Full GC 152.676: [Tenured: 25736K->25722K(1048576K), 0.8464782 secs] 25752K->25722K(1557568K), [Perm : 32767K->32766K(32768K)], 0.8466638 secs]
153.525: [Full GC 153.525: [Tenured: 25722K->25724K(1048576K), 0.8419056 secs] 25738K->25724K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8420986 secs]
154.368: [Full GC 154.368: [Tenured: 25724K->25724K(1048576K), 0.8398816 secs] 25724K->25724K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8400498 secs]
155.212: [Full GC 155.212: [Tenured: 25724K->25725K(1048576K), 0.8365448 secs] 25788K->25725K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8367370 secs]
156.050: [Full GC 156.050: [Tenured: 25725K->25722K(1048576K), 0.8422488 secs] 25725K->25722K(1557568K), [Perm : 32767K->32766K(32768K)], 0.8424328 secs]
156.895: [Full GC 156.895: [Tenured: 25722K->25724K(1048576K), 0.8443532 secs] 25738K->25724K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8445450 secs]
157.740: [Full GC 157.741: [Tenured: 25724K->25724K(1048576K), 0.8427754 secs] 25740K->25724K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8429634 secs]
158.587: [Full GC 158.588: [Tenured: 25724K->25726K(1048576K), 0.8352290 secs] 25820K->25726K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8354212 secs]
159.424: [Full GC 159.424: [Tenured: 25726K->25723K(1048576K), 0.8435336 secs] 25726K->25723K(1557568K), [Perm : 32767K->32766K(32768K)], 0.8437092 secs]
160.270: [Full GC 160.270: [Tenured: 25723K->25725K(1048576K), 0.8477722 secs] 25739K->25725K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8479596 secs]
161.119: [Full GC 161.119: [Tenured: 25725K->25725K(1048576K), 0.8543338 secs] 25725K->25725K(1557568K), [Perm : 32767K->32767K(32768K)], 0.8545040 secs
浠庢棩蹇楃湅錛屽拰鎴戜滑鐜板満鐨勭姸鍐甸潪甯哥浉浼鹼紝heap絀洪棿鍏呰凍錛屼絾鏄痯erm宸茬粡鍒頒簡32M錛屾棤娉曞啀榪涗竴姝ュ垎閰嶇┖闂達紝鐩存帴瀵艱嚧jvm棰戠箒鍋欶ull GC錛屾帶鍒跺彴涔熷紑濮嬫姏鍑篛OM錛圥erm寮曡搗鐨勫洖鏀墮兘鏄痜ull gc錛夛紝榪欐牱鐪嬪熀鏈垜浠垽鏂槸Perm澶皬錛屽鑷存棤娉曞姞杞絚lasses瀵艱嚧鐨?
鍜屽鎴鋒矡閫氫箣鍚庯紝鎴戜滑鏈潵鎵撶畻榪涗竴姝ラ獙璇侊紙鍦ㄧ敓浜х幆鑺傛墦寮PrintGCDetail錛岃幏鍙栬緇嗙殑GC log錛夛紝鍚庨潰浠旂粏媯鏌ohup.out,鍙戠幇閲岄潰宸茬粡鎶涘嚭浜?OutOfMemoryError:PermGen Space錛岃嚦姝ゆ垜浠‘瀹氭槸Perm璁劇疆涓嶅悎鐞嗗鑷翠簡鏈浜嬫晠錛屽拰瀹㈡埛紜涔嬪悗錛屾垜浠湪鍚姩鍙傛暟涓姞涓婁簡MaxPermSize
鍚庨潰鎯沖埌涓棿涓婁簡闆嗙兢涔嬪悗錛宔os鍔犺澆浜嗗ぇ閲忕殑jboss cache class錛岃繖涔熺洿鎺ヨВ閲婁簡涓轟粈涔堣繖孌墊椂闂碠OM鍑虹幇鐨勯鐜囨瘮涔嬪墠鏇撮綣佺殑鍘熷洜
榪欓噷鎬葷粨涓涓嬶紝甯屾湜瀵圭鍒扮被浼奸棶棰樼殑tx鏈夊熼壌鎰忎箟錛屽己鐑堝緩璁敤sun jdk 1.4.2鐨勫悓瀛﹀崌綰у埌>=1.4.2_12錛屼究浜庡OOM闂鐨勮瘖鏂紝騫跺姞涓奊C log鍗忓姪楠岃瘉銆?
榪欓噷鍐嶄粙緇嶄竴涓婮VM鍙戠敓OOM鐨勫嚑縐嶆儏鍐碉細
1銆乯ava.lang.OutOfMemoryError: Java heap space
榪欐槸鎴戜滑騫沖父鐞嗚В鐨凮OM錛屾槸鐢變簬heap space紜疄娌℃湁絀洪棿鍒嗛厤錛岃繖縐嶄竴鑸槸鐢變簬鍐呭瓨娉勬紡瀵艱嚧錛屼篃鏈夊彲鑳芥槸heap space璁劇疆澶皬銆傞渶瑕佸叿浣撳垎鏋?
2銆乯ava.lang.OutOfMemoryError: PermGen space
jvm瑙勮寖閲岄潰鏈夊畾涔変竴涓猰ethod space錛岃繖閲屼富瑕佹斁classes鍜宮ethod list鍜屼竴涓猻tring pool錛宻tring鏈変竴涓猧ntern鏂規硶錛岄氳繃榪欎釜鏂規硶瀹氫箟鐨剆tring閮芥斁鍦ㄨ繖閲岋紙濂藉儚涓嶅父鐢級錛岃繖閲岃緗笉澶皬浼氬鑷碠OM錛岀己鐪?4M錛屼富瑕佺敱浜庣幇鍦ㄥ簲鐢ㄤ緷璧栫殑絎笁鏂圭被瓚婃潵瓚婂錛屽鑷磋繖綾婚棶棰橀綣佸彂鐢燂紝闇瑕佸紩璧烽噸瑙?
3銆丷equested array size exceeds VM limit
榪欑鏄敱浜庣敵璇風殑array size瓚呭嚭浜唄eap space澶у皬錛屾瘮濡傚湪涓涓?56M鐨刪eap space涓敵璇蜂竴涓?12M鐨刟rray錛岃繖縐嶅熀鏈兘鏄簲鐢╞ug瀵艱嚧
4銆乺equest <size> bytes for <reason>. Out of swap space?
榪欑鏄敱浜巋eap size璁劇疆鐩稿浜庣郴緇熺墿鐞嗗唴瀛樺お澶э紝瀵艱嚧緋葷粺swap space涓嶈凍錛岃繖縐嶇殑瑙ｅ喅鍔炴硶灝辨槸鍑忓皬heap size澶у皬
5銆?lt;reason> <stack trace> (Native method)
榪欑浼拌鏄渶楹葷儲鐨勪簡錛屼篃鏄渶灝戠鍒扮殑錛屾槸鐢變簬jni鎴杗ative method瀵艱嚧錛屽鏋滆嚜宸辨病鏈夊啓榪欑被鐨勪笢瑗匡紝鍩烘湰鍙互璇存槸jdk闂
]]>