如何捕獲問題sql解決過度cpu消耗問題

《如何捕獲問題sql解決過度cpu消耗問題》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在學(xué)術(shù)論文-天天文庫。

1、如何捕獲問題SQL解決過度CPU消耗問題如何捕獲問題SQL解決過度CPU消耗問題問題描述:開發(fā)人員報告系統(tǒng)運行緩慢，影響用戶訪問.1.登陸數(shù)據(jù)庫主機(jī)使用vmstat檢查，發(fā)現(xiàn)CPU資源已經(jīng)耗盡，大量任務(wù)位于運行隊列:bash-2.03$vmstat3procsmemorypagediskfaultscpurbwswapfreeremfpipofrdesrs6s9s1sdinsycsussyid0005504232146411200000000110429496719600-84-5-145131005368072151836056691

2、0220001003011791827959730131005377328152246481719022000100276680192577964013000538240015247766768200000000035708534331697301340053736161520512127107802200010038389584362396401360053693921518496107924055000000292085732639973013200536491215162246357800000000033587944311997

3、3012900535864815117121891236000000000336610365313595501290053545281511304120119400000004032358864291196401280053468481507704998230000000303189904830749640125005341248150470480843022000610356395143314955013300533274415011127979800000001032188805290297301290053253841497368

4、1076430220001403184829728799640126005363144151432081753000000000253374092164973013600535562415105121695667860000001030028600281096401301053514481502936267580182100000000312678122900964012900534725614995681559132220000102225807619419820116005338192149540017711620000000101

5、9477781163997302.使用Top命令觀察進(jìn)程CPU耗用,發(fā)現(xiàn)沒有明顯過高CPU使用的進(jìn)程$toplastpid:28313;loadaverages:99.90,117.54,125.7123:28:38296processes:186sleeping,99running,2zombie,9oncpuCPUstates:0.0%idle,96.5%user,3.5%kernel,0.0%iowait,0.0%swapMemory:4096Mreal,1404Mfree,2185Mswapinuse,5114Mswapfree

6、PIDUSERNAMETHRPRINICESIZERESSTATETIMECPUCOMMAND27082oracle8i13301328M1309Mrun0:171.29%oracle26719oracle8i15501327M1306Msleep0:291.11%oracle28103oracle8i13501327M1304Mrun0:061.10%oracle28161oracle8i12501327M1305Mrun0:041.10%oracle26199oracle8i14501328M1309Mrun0:421.10%ora

7、cle26892oracle8i13301328M1310Mrun0:241.09%oracle27805oracle8i14501327M1306Mcpu/10:101.04%oracle23800oracle8i12301327M1306Mrun1:281.03%oracle25197oracle8i13401328M1309Mrun0:571.03%oracle21593oracle8i13301327M1306Mrun2:121.01%oracle27616oracle8i14501329M1311Mrun0:141.01%or

8、acle27821oracle8i14301327M1306Mrun0:101.00%oracle26517oracle8i13301328M1309Mrun0:330.97%oracle25785orac