1、RAC相關(guān)指標(biāo)GlobalCacheLoadProfilePerSecondPerTransactionGlobalCacheblocksreceived:12.062.23GlobalCacheblocksserved:8.181.51GCS/GESmessagesreceived:391.1972.37GCS/GESmessagessent:368.7668.22DBWRFusionwrites:0.100.02EstdInterconnecttraffic(KB)310.31指標(biāo)指標(biāo)說(shuō)明GlobalCacheblocksreceived通過(guò)硬件連接收到遠(yuǎn)程實(shí)例的數(shù)據(jù)塊的數(shù)量。發(fā)生在一個(gè)進(jìn)

2、程請(qǐng)求一致性讀一個(gè)數(shù)據(jù)塊不是在本地緩存中。Oracle發(fā)送一個(gè)請(qǐng)求到另外的實(shí)例。一旦緩沖區(qū)收到，這個(gè)統(tǒng)計(jì)值就會(huì)增加。這個(gè)統(tǒng)計(jì)值是另兩個(gè)統(tǒng)計(jì)值的和：GlobalCacheblocksreceived=gccurrentblocksreceived+gccrblocksreceivedGlobalCacheblocksserved通過(guò)硬件連接發(fā)送到遠(yuǎn)程實(shí)例的數(shù)據(jù)塊的數(shù)量。這個(gè)統(tǒng)計(jì)值是另外兩個(gè)統(tǒng)計(jì)值的和：GlobalCacheblocksserved=gccurrentblocksserved+gccrblocksservedGCS/GESmessagesreceived通過(guò)硬件連接收到遠(yuǎn)程實(shí)例的消

3、息的數(shù)量。這個(gè)統(tǒng)計(jì)值通常代表RAC服務(wù)引起的開銷。這個(gè)統(tǒng)計(jì)值是另外兩個(gè)統(tǒng)計(jì)值的和：GCS/GESmessagesreceived=gcsmsgsreceived+gesmsgsreceivedGCS/GESmessagessent通過(guò)硬件連接發(fā)送到遠(yuǎn)程實(shí)例的消息的數(shù)量。這個(gè)統(tǒng)計(jì)值通常代表RAC服務(wù)引起的開銷。這個(gè)統(tǒng)計(jì)值是另外兩個(gè)統(tǒng)計(jì)值的和：GCS/GESmessagessent=gcsmessagessent+gesmessagessentDBWRFusionwrites這個(gè)統(tǒng)計(jì)值顯示融合寫入的次數(shù)。在RAC中，單實(shí)例Oracle數(shù)據(jù)庫(kù)，數(shù)據(jù)塊只被寫入磁盤因?yàn)閿?shù)據(jù)過(guò)期，緩沖替換或者發(fā)生檢查點(diǎn)。

4、當(dāng)一個(gè)數(shù)據(jù)塊在緩存中被替換因?yàn)閿?shù)據(jù)過(guò)期或發(fā)生檢查點(diǎn)但在另外的實(shí)例沒(méi)有寫入磁盤GlobalCacheService會(huì)請(qǐng)求實(shí)例將數(shù)據(jù)塊寫入磁盤。因此融合寫入不包括在第一個(gè)實(shí)例中的額外寫入磁盤。大量的融合寫入表明一個(gè)持續(xù)的問(wèn)題。實(shí)例產(chǎn)生的融合寫入請(qǐng)求占總的寫入請(qǐng)求的比率用于性能分析。高比率表明DBcache大小不合適或者檢查點(diǎn)效率低。EstdInterconnecttraffic(KB)連接傳輸?shù)腒B大小。計(jì)算公式如下：EstdInterconnecttraffic(KB)=(gccrblocksreceived'+gccurrentblocksreceived'+gccrblock

5、sserved'+gccurrentblocksserved')*Blocksize)+(gcsmessagessent'+gesmessagessent'+gcsmsgsreceived'+gcsmsgsreceived')*200)/1024/ElapsedTimeGlobalCacheEfficiencyPercentages(Targetlocal+remote100%)Bufferaccess-localcache%:91.05Bufferaccess-remotecache%:0.03Bufferaccess-disk%:8.92指標(biāo)

6、指標(biāo)說(shuō)明Bufferaccess-localcache%數(shù)據(jù)塊從本地緩存命中占會(huì)話總的數(shù)據(jù)庫(kù)請(qǐng)求次數(shù)的比例。在OLTP應(yīng)用中最希望的是盡可能維持這個(gè)比率較高，因?yàn)檫@是最低成本和最快速的獲得數(shù)據(jù)庫(kù)數(shù)據(jù)塊的方法。計(jì)算公式：LocalCacheBufferAccessRatio=1-(physicalreadscache+GlobalCacheblocksreceived)/LogicalReadsBufferaccess-remotecache%數(shù)據(jù)塊從遠(yuǎn)程實(shí)例緩存命中占會(huì)話總的數(shù)據(jù)塊請(qǐng)求的比例。在OLTP應(yīng)用中這個(gè)比率和Bufferaccess-localcache的和應(yīng)該盡可能的高因?yàn)檫@兩種方

7、法訪問(wèn)數(shù)據(jù)庫(kù)數(shù)據(jù)塊是最快速最低成本的。這個(gè)比率的計(jì)算方法：RemoteCacheBufferAccessRatio=GlobalCacheblocksreceived/LogicalReadsBufferaccess-disk%從磁盤上讀數(shù)據(jù)塊到緩存占會(huì)話總的數(shù)據(jù)塊請(qǐng)求次數(shù)的比例。在OLTP應(yīng)用中希望維持這個(gè)比例低因?yàn)槲锢碜x是最慢的訪問(wèn)數(shù)據(jù)庫(kù)數(shù)據(jù)塊的方式。這個(gè)比率計(jì)算方法：1-physicalreadscache/LogicalReadsGlobalCacheandEnqueueServices-WorkloadCharacteristicsAvgglobalenqueuegettime(ms

8、):0.0Avgglobalcachecrblockreceivetime(ms):0.3Avgglobalcachecurrentblockreceivetime(ms):0.2Avgglobalcachecrblockbuildtime(ms):0.0Avgglobalcachecrblocksendtime(ms):0.0Globalcachelogflushesforcrblocksserved%:1.2Avgglobalcachecrblockflushtime(ms):1.8Avgglobalcachecurrentblockpintime(ms):1,021.7Avgglobal

9、cachecurrentblocksendtime(ms):0.0Globalcachelogflushesforcurrentblocksserved%:6.9Avgglobalcachecurrentblockflushtime(ms):0.9指標(biāo)指標(biāo)說(shuō)明Avgglobalenqueuegettime(ms)通過(guò)interconnect發(fā)送消息，為爭(zhēng)奪資源開啟一個(gè)新的全局隊(duì)列或者對(duì)已經(jīng)開啟的隊(duì)列轉(zhuǎn)換訪問(wèn)模式所花費(fèi)的時(shí)間。如果大于20ms，你的系統(tǒng)可能會(huì)出現(xiàn)超時(shí)。Avgglobalcachecrblockreceivetime(ms)從請(qǐng)求實(shí)例發(fā)送消息到masteringinstance(2

10、-wayget)和一些到holdinginstanee(3-wayget)花費(fèi)的時(shí)間。這個(gè)時(shí)間包括在holdinginstanee生成數(shù)據(jù)塊一致性讀映像的時(shí)間°CR數(shù)據(jù)塊獲取耗費(fèi)的時(shí)間不應(yīng)該大于15ms。Avgglobalcachecurrentblockreceivetime(ms)從請(qǐng)求實(shí)例發(fā)送消息到masteringinstance(2-wayget)和一些到holdinginstanee(3-wayget)花費(fèi)的時(shí)間。這個(gè)時(shí)間包括holdinginstanee日志刷新花費(fèi)的時(shí)間°CurrentBlock獲取耗費(fèi)的時(shí)間不大于30msAvgglobalcachecrbl

11、ockbuildtime(ms)CR數(shù)據(jù)塊創(chuàng)建耗費(fèi)的時(shí)間Avgglobalcachecrblocksendtime(ms)CR數(shù)據(jù)塊發(fā)送耗費(fèi)的時(shí)間Globalcachelogflushesforcrblocksserved%Avgglobalcachecrblockflushtime(ms)CR數(shù)據(jù)塊刷新耗費(fèi)的時(shí)間Avgglobalcachecurrentblockpintime(ms)Current數(shù)據(jù)塊pin耗費(fèi)的時(shí)間Avgglobalcachecurrentblocksendtime(ms)Current數(shù)據(jù)塊發(fā)送耗費(fèi)的時(shí)間Globalcachelogflushesforcurrentb

12、locksserved%需要日志刷新的Current數(shù)據(jù)塊占總的需要服務(wù)的Current數(shù)據(jù)塊的比例Avgglobalcachecurrentblockflushtime(ms)Current數(shù)據(jù)塊刷新耗費(fèi)的時(shí)間GlobalCacheandEnqueueServices-MessagingStatisticsAvgmessagesentqueuetime(ms):2,367.6Avgmessagesentqueuetimeonksxp(ms):0.1Avgmessagereceivedqueuetime(ms):0.3AvgGCSmessageprocesstime(ms):0.0AvgGES

13、messageprocesstime(ms):0.0%ofdirectsentmessages:54.00%ofindirectsentmessages:44.96%offlowcontrolledmessages:1.03指標(biāo)指標(biāo)說(shuō)明Avgmessagesentqueuetime(ms)條信息進(jìn)入隊(duì)列到發(fā)送它的時(shí)間Avgmessagesentqueuetimeonksxp(ms)對(duì)端收到該信息并返回ACK的時(shí)間，這個(gè)指標(biāo)很重要，直接反應(yīng)了網(wǎng)絡(luò)延遲，一般小于1msAvgmessagereceivedqueuetime(ms)條信息進(jìn)入隊(duì)列到收到它的時(shí)間AvgGCSmessageprocesst

14、ime(ms)AvgGESmessageprocesstime(ms)%ofdirectsentmessages直接發(fā)送信息占的比率%ofindirectsentmessages間接發(fā)送信息占的比率，一般是排序或大的信息，流控制也可能引起%offlowcontrolledmessages流控制信息占的比率，流控制最常見的原因是網(wǎng)絡(luò)狀況不佳，%offlowcontrolledmessages應(yīng)當(dāng)小于1%WaitEventHistogram%ofWaitsEventTotalWaits<1ms<2ms<4ms<8ms<16ms<32ms<=1s>1s

15、ADRblockfileread20838.03.444.713.9ADRblockfilewrite40100.0ADRfilelock48100.0ARCHwaitforarchiveloglock3100.0ASMfilemetadataoperation12.8K99.7.1.0.0.0.2.0Backup:MMLwritebackuppiece310.5K7.6.1.11.310.430.250.2.0CGSwaitforIPCmsg141.7K100.0CSSinitialization3450.047.12.9CSSoperation:action11048.220.928.22

16、.7CSSoperation:query10288.23.97.8DFSlockhandle660793.9.5.2.0.05.3.0DiskfileoperationsI/O1474100.0IPCsendcompletionsync21.9K99.5.1.1.1.0.2KJC:Waitformsgsendstocomplete13100.0LGWRwaitforredocopy16.3K100.0.0LogarchiveI/O333.366.7PXDeq:SignalACKEXT225699.8.1.1PXDeq:SignalACKRSG212499.9.1.0PXDeq:SlaveSes

17、sionStats799794.6.9.92.5.8.4PXDeq:TableQqref235599.9.1PXDeq:reapcredit1215.7K100.0.0.0PXqreflatch1366100.0ParameterFileI/O19494.81.01.01.01.5.5WaitEventHistogram:等待時(shí)間直方圖Event：等待事件名字TotalWaits:該等待事件在快照時(shí)間內(nèi)等待的次數(shù)%ofWaits<1ms:小于1ms的等待次數(shù)%ofWaits<2ms:小于2ms的等待次數(shù)%ofWaits<4ms:小于4ms的等待次數(shù)%ofWaits<8m

18、s:小于8ms的等待次數(shù)%ofWaits<16ms:小于16ms的等待次數(shù)%ofWaits<32ms:小于32ms的等待次數(shù)%ofWaits<=1s:小于等于1s的等待次數(shù)%ofWaits>1s:大于1s的等待次數(shù)ParentLatchStatisticsonlylatcheswithsleepsareshownorderedbynameLatchNameGetRequestsMissesSleepsSpin&Sleeps1->3+Real-timeplanstatisticslatch77,84013620116/0/0/0activecheckpoin

19、tqueuelatch321,02320,5287720451/0/0/0activeservicelist339,641546132424/0/0/0callallocation328,283550148440/0/0/0enqueues1,503,52521714203/0/0/0ksuosstatsglobalarea2,605110/0/0/0messages2,608,863141,38029141351/0/0/0name-servicerequestqueue155,047431528/0/0/0qmntaskqueuelatch2,368907812/0/0/0queryser

20、verprocess26830300/0/0/0redowriting910,70311,6235011573/0/0/0resmgr:freethreadslist14,4541904186/0/0/0spacebackgroundtasklatch11,2091578/0/0/0LatchName:閂名稱GetRequests:申請(qǐng)獲得父閂的次數(shù)ChildLatchStatisticsonlylatcheswithsleeps/gets>1/100000areshownorderedbyname,getsdescLatchNameChildNumGetRequestsMissesSp

21、in&Sleeps1->3+KJCmessagepoolfreelist196,136822062/0/0/0Lsodarraylatch102,22215311858/0/0/0Lsodarraylatch132,151431429/0/0/0Lsodarraylatch42,06615412459/0/0/0Lsodarraylatch51,9881054463/0/0/0Lsodarraylatch1,734953264/0/0/0Lsodarraylatch21,707883855/0/0/0Lsodarraylatch111,695883257/0/0/0Lsodarr

22、aylatch61,68015812664/0/0/0Lsodarraylatch121,65715511165/0/0/0Lsodarraylatch71,640903459/0/0/0Lsodarraylatch11,62716915346/0/0/0Lsodarraylatch31,555873654/0/0/0Lsodarraylatch81,4871278857/0/0/0cachebufferschains47418354,3133914387/0/0/0cachebufferschains8031337,1352508242/0/0/0cachebufferschains7835

23、8305,022#9519/0/0/0cachebufferschains6927241,8081294125/0/0/0LatchName:閂名稱ChildNum：GetRequests:Misses:Sleeps:Spin&Sleeps1->3+:DictionaryCacheStats(RAC)CacheGESRequestsGESConflictsGESReleasesdc_awr_control1150dc_global_oids500dc_histogram_defs2151707dc_objects90911dc_segments791073dc_sequences

24、35,738370dc_table_scns600dc_tablespace_quotas907770dc_users1000outstanding_alerts5762880Cache:字典緩存類名GESRequests：GESConflicts：GESReleases：LibraryCacheActivity(RAC)NamespaceGESLockRequestsGESPinRequestsGESPinReleasesGESInvalRequestsGESInvali-dationsACCOUNT_STATUS2420000BODY01,530,0131,530,0130CLUSTER7

25、4747400DBLINK246EDITION31131131100HINTSETOBJECT#18618600INDEX152,360152,360152,36000QUEUE2239,7179,71700SCHEMA2550000SUBSCRIPTION0262600TABLE/PROCEDURE275,2153,023,0833,023,08300TRIGGER0384,493384,49300Namespace：librarycache的命名空間GESLockRequests：GESPinRequests：GESInvalRequests：GESInvali-dations：Inter

26、connectPingLatencyStatsPinglatencyoftheroundtripofamessagefromthisinstancetotargetinstances.Thetargetinstanceisidentifiedbyaninstancenumber.Averageandstandarddeviationofpinglatencyisgiveninmilisecondsformessagesizesof500bytesand8K.Notethatlatencyofamessagefromtheinstancetoitselfisusedascontrol,since

27、messagelatencycanincludewaitforCPUTargetInstance500BPingCountAvgLatency500BmsgStddev500Bmsg8KPingCountAvgLatency8KmsgStddev8Kmsg11,1380.200.031,1380.200.03#1,1380.170.041,1380.200.0531,1380.190.221,1380.230.2241,1380.180.041,1380.210.04TargetInstanee:目標(biāo)實(shí)例500BPingCount：AvgLateney500Bmsg:Stddev500Bmsg

28、:8KPingCount:AvgLateney8Kmsg:Stddev8Kmsg:IntereonneetThroughputbyClientThroughputofintereonneetusagebymajoreonsumersAllthroughputnumbersaremegabytesperseeondUsedBySendMbytes/seeReeeiveMbytes/seeGlobalCaehe0.100.20ParallelQuery0.020.06DBLocks0.090.09DBStreams0.000.00Other0.020.01UsedBy:主要消費(fèi)者SendMbyte

29、s/sec:發(fā)送Mb/每秒ReceiveMbytes/sec:接收Mb/每秒InterconnectDeviceStatisticsThroughputanderrorsofinterconnectdevices(atOSlevel)AllthroughputnumbersaremegabytespersecondDeviceNameIPAddressPublicSourceSendMbytes/secSendErrorsSendDroppedSendBufferOverrunSendCarrierLostReceiveMbytes/secReceiveErrorsReceiveDropped

30、ReceiveBufferOverrunReceiveFrameErrorsbondib0192.168.10.8NOcluster_interconnectsparameter0.0000000.00000DeviceName:設(shè)備名稱IPAddress:IP地址Public:是否為公用網(wǎng)絡(luò)Source:來(lái)源SendMbytes/sec:發(fā)送MB/每秒SendErrors:發(fā)送錯(cuò)誤SendDropped:SendBufferOverrun:SendCarrierLost:ReceiveMbytes/sec:ReceiveErrors:ReceiveDropped:ReceiveBufferOverrun:ReceiveFrameErrors:DynamicRemasteringStatstimesareinsecondsAffinityobjects-objectsmasteredduetoaffinityatbegin/endsnapNameTotalperRemasterOpBeginSnapEndSnapremasterops291.00remasteredobjects40