2024從其他角度去解決數(shù)據(jù)庫問題

，每天早上8多客戶系統(tǒng)某天告警，15:10-15:25gcbufferbusy gccurrentblock gccr gccurrent與gc語句都是最簡單的insert相關(guān)：insertintoxxxcurrent請求就是訪問數(shù)據(jù)塊本身發(fā)生于IB檢查x$bh/v$bh發(fā)現(xiàn)部分塊在節(jié)點(diǎn)2也存在，懷疑是統(tǒng)selectfromx$bhh,dba_objectsowhereo.data_object_id=h.obj強(qiáng)制統(tǒng)計(jì)信息收集在節(jié)點(diǎn)1強(qiáng)行flush節(jié)點(diǎn)2的bufferaltersystemflushbuffer2020-09-2615:31:30.766===Twoconsecutivereceivecallstookin5945ms==2020-09-2615:31:30.767===Twoconsecutivereceivecallstookin7274ms==2020-09-2615:31:30.807===Twoconsecutivereceivecallstookin8494ms==2020-09-2615:31:30.835===Twoconsecutivereceivecallstookin6355msawk'/Twoconsecutivereceivecallstook/{if(wait>=3;cnt3[t]++);if(wait>=2;cnt2[t]++);if(wait>=1;cnt1[t]++);}END{for(iincnt1)printi,cnt1[i],cnt2[i],cnt3[i]}' Whatis搜索Oracle官網(wǎng)，發(fā)現(xiàn)OraJavaAgentDriver是OracleCRS健康檢查的一個工具，在CRS名字是ora.cvucrsctlstatresora.cvu-由于OracleCVU主要是初始安裝時(shí)用來檢查系統(tǒng)狀況是否符合安裝標(biāo)準(zhǔn)，如果后續(xù)整個集群沒有硬件和操作系統(tǒng)變更，理crsctlstopora.cvucrsctldisableora.cvu

ThuOct0112:35:30GMT+08:002020ARC1:Standbyredologfileselectedforthread2sequence109637fordestinationLOG_ARCHIVE_DEST_2ThuOct0112:36:24GMT+08:002020kkjcre1p:unabletospawnjobqslaveprocessThuOct0112:36:24GMT+08:002020ErrorsinfileThuOct0112:41:29GMT+08:002020ksvcreate:Process(m000)creationfailedThuOct0112:46:35GMT+08:002020kkjcre1p:unabletospawnjobqslaveprocessThuOct0112:46:35GMT+08:002020Errorsinfileprocstack和ps–elf***SESSIONID:(3904.1)2020-10-01WaitedforprocessJ003toinitializefor60***2020-10-01swapinfo:free_mem=136988.31Mrsv=alloc=651.48Mavail=156672.00Mswap_freeskgpgcmdout:read()forcmd/bin/sh-c'/usr/bin/procstack136973242>&1'timedoutafter18.798secondsskgpgcmdout:read()forcmd/bin/ps-elf|/bin/egrep'PID||/b