0racle深度學(xué)習(xí)筆記- 12C的AWR初步解讀

34.0racle深度學(xué)習(xí)筆記——12C的AWR初步解讀關(guān)于AWR,蛤蟆也經(jīng)?？?。因?yàn)榻?jīng)?？磩e人給出的建議,很難有深刻體會(huì)。對(duì)此,計(jì)劃花費(fèi)幾個(gè)晚上時(shí)間好好體會(huì)一把并記錄下來。此處以單實(shí)例為例。列出目錄便于整體理解。目錄TOC\o"1-5"\h\z\o"CurrentDocument". 快照生成方法 3\o"CurrentDocument". 生成AWR報(bào)告 3\o"CurrentDocument".系統(tǒng)描述 5\o"CurrentDocument".報(bào)告匯總 6? 負(fù)載信息 6\o"CurrentDocument".等待事件統(tǒng)計(jì) 7時(shí)間模型統(tǒng)計(jì) 7操作系統(tǒng)統(tǒng)計(jì) 7操作系統(tǒng)統(tǒng)計(jì)詳細(xì) 7前臺(tái)等待類 7前臺(tái)等待事件 7后臺(tái)等待事件 7等待事件直方圖 7等待事件直方圖的詳細(xì)（64ms到2s） 7等待事件直方圖的詳細(xì)（4ms到2min） 7等待事件直方圖的詳細(xì)（4ms到!hr） 7服務(wù)統(tǒng)計(jì) 7通過執(zhí)行時(shí)間排序 8通過CPU時(shí)間排序 8通過USER10排序 8通過Gets排序 8通過Reads排序 8通過物理讀（無(wú)優(yōu)化）排序 8通過執(zhí)行數(shù)量排序 8通過解析調(diào)用排序 8通過共享內(nèi)存排序 8通過打開的子游標(biāo)排序 8SQL文本的完整列表 8\o"CurrentDocument".實(shí)例活動(dòng)統(tǒng)計(jì) 8關(guān)鍵實(shí)例活動(dòng)統(tǒng)計(jì) 8實(shí)例活動(dòng)統(tǒng)計(jì) 8實(shí)例活動(dòng)統(tǒng)計(jì)的絕對(duì)值 9實(shí)例活動(dòng)統(tǒng)計(jì)的進(jìn)程活動(dòng) 9. 10狀態(tài) 9函數(shù)引起的10 9文件類型引起的I〇 9函數(shù)或文件類型的10 9表空間的10 9文件的10 9\o"CurrentDocument".緩存池統(tǒng)計(jì) 9\o"CurrentDocument"數(shù)據(jù)庫(kù)建議統(tǒng)計(jì) 9實(shí)例匯通統(tǒng)計(jì) 10MTTR建議 10緩存池建議 10PGA命中匯總 10PGA命中統(tǒng)計(jì) 10PGA命中直方圖 10PGA內(nèi)存建議 10共享庫(kù)建議 10SGA建議 10流池建議 10JAVAPOOL建議 10緩存等待統(tǒng)計(jì) 10隊(duì)列等待活動(dòng) 10\o"CurrentDocument"回滾統(tǒng)計(jì) 10回滾段匯總 11回滾段統(tǒng)計(jì) 11\o"CurrentDocument"Latch統(tǒng)計(jì) 11LACTH活動(dòng) 11LATCH丟失源 11父Latch統(tǒng)計(jì) 11子Latch統(tǒng)計(jì) 11\o"CurrentDocument"段信息統(tǒng)計(jì) 11段的邏輯讀 11段的物理讀 11段的物理讀請(qǐng)求 11段的未優(yōu)化讀 11段的優(yōu)化讀 12段的直接物理讀 12段的物理寫 12段的物理寫請(qǐng)求 12段的直接物理寫 12表掃描 12塊改變 12行鎖等待 12ITL等待 12BufferBusy等待 12\o"CurrentDocument"字典CACHE統(tǒng)計(jì) 12庫(kù)緩存統(tǒng)計(jì) 12內(nèi)存統(tǒng)計(jì) 12內(nèi)存動(dòng)態(tài)組件 12內(nèi)存組件大小重設(shè)置操作匯總 12進(jìn)程內(nèi)存匯總 13SGA內(nèi)存匯總 13SGA中組件變化 13\o"CurrentDocument"復(fù)制統(tǒng)計(jì)（X流,GoldenGate） 13\o"CurrentDocument"流統(tǒng)計(jì) 13\o"CurrentDocument"資源限制統(tǒng)計(jì) 13\o"CurrentDocument"共享服務(wù)統(tǒng)計(jì) 13\o"CurrentDocument"啟動(dòng)參數(shù)匯總 13\o"CurrentDocument"ASH報(bào)告 14\o"CurrentDocument"ADDM執(zhí)行 1412C完整AWR報(bào)告 14L快照生成方法如下:SQL>execdbms_workload_repository.create_snapshot();2.生成AWR報(bào)告如下:SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sqlCurrentInstanceDBIdDBNameInstNumInstance53626287TOADDB1toaddbSpecifytheReportTypeAWRreportscanbegeneratedinthefollowingformats.Pleaseenterthenameoftheformatattheprompt.Defaultvalueis'html'.'html'HTMLformat(default)'texゼTextformat,active-html'IncludesPerformanceHubactivereportEntervalueforreport_type:htmlTypeSpecified:htmlInstancesinthisWorkloadRepositoryschemaDBIdInstNumDBNameInstanceHost*53626287 1TOADDBtoaddbOELUsing 53626287fordatabaseIdUsing 1forinstancenumberSpecifythenumberofdaysofsnapshotstochoosefrom~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enteringthenumberofdays(n)willresultinthemostrecent(n)daysofsnapshotsbeinglisted.Pressing<return>withoutspecifyinganumberlistsallcompletedsnapshots.Entervaluefornum_days:lListingthelastday'sCompletedSnapshotsSnapInstanceDBName SnapIdSnapStartedLeveltoaddbTOADDB10209Mar201616:48 110309Mar201617:19 1SpecifytheBeginandEndSnapshotIdsEntervalueforbegin_snap:102BeginSnapshotIdspecified:102Entervalueforend_snap:103EndSnapshotIdspecified:103SpecifytheReportName~~~~~~~~~~~~~~~~~~~~~~~Thedefaultreportfilenameisawrrpt__l_102_103.html.Tousethisname,press<return>tocontinue,otherwiseenteranalternative.Entervalueforreport_name:test__awr.htmlUsingthereportnametest_awr.html然后在當(dāng)前目錄下生成一個(gè)test_awr.html的awr報(bào)告。.系統(tǒng)描述DBNameDBIdInstanceInstnumStartupTimeReleaseRACTOADDB 53626287toaddb 109-Mar-1616:03.0 NOHostNamePlatformCPUsCoresSocketsMemory(GB)OEL Linuxx8664-bit 1 3.61SnapIdSnapTimeSessionsCursors/Session jBeginSnap: 10209-Mar-1616:48:00331.0EndSnap: 10309-Mar-1617:19:01321.1Elapsed:31.01(mins)DBTime:0.10(mins)描述了數(shù)據(jù)的ID,數(shù)據(jù)庫(kù)名字,啟動(dòng)時(shí)間，版本，快照號(hào),運(yùn)行的版本,CPU數(shù)量,內(nèi)存大小,快照抓取時(shí)間,開始的會(huì)話數(shù)量,結(jié)束時(shí)候的會(huì)話數(shù)量,每個(gè)會(huì)話的游標(biāo)數(shù)量等。.報(bào)告匯總?負(fù)載信息?實(shí)例命中TOP10等待的前臺(tái)事件按等待事件的等待類主機(jī)系統(tǒng)CPU實(shí)例的CPU10負(fù)載總體內(nèi)存統(tǒng)計(jì)總體CACHAE大小共享池統(tǒng)計(jì)5.等待事件統(tǒng)計(jì)時(shí)間模型統(tǒng)計(jì)操作系統(tǒng)統(tǒng)計(jì)操作系統(tǒng)統(tǒng)計(jì)詳細(xì)前臺(tái)等待類前臺(tái)等待事件后臺(tái)等待事件等待事件直方圖等待事件直方圖的詳細(xì)（64ms到2s）等待事件直方圖的詳細(xì)（4ms至リ2min）等待事件直方圖的詳細(xì)（4ms到Ihr）服務(wù)統(tǒng)計(jì)服務(wù)等待類統(tǒng)計(jì).SQL統(tǒng)計(jì)通過執(zhí)行時(shí)間排序通過CPU時(shí)間排序通過USER10排序通過Gets排序通過Reads排序通過物理讀（無(wú)優(yōu)化）排序通過執(zhí)行數(shù)量排序通過解析調(diào)用排序通過共享內(nèi)存排序通過打開的子游標(biāo)排序SQL文本的完整列表.實(shí)例活動(dòng)統(tǒng)計(jì)?關(guān)鍵實(shí)例活動(dòng)統(tǒng)計(jì)?實(shí)例活動(dòng)統(tǒng)計(jì)?實(shí)例活動(dòng)統(tǒng)計(jì)的絕對(duì)值?實(shí)例活動(dòng)統(tǒng)計(jì)的進(jìn)程活動(dòng)8.10狀態(tài)函數(shù)引起的10文件類型引起的10函數(shù)或文件類型的10表空間的10文件的10.緩存池統(tǒng)計(jì)緩沖池中包含默認(rèn)的和其他塊大小的。.數(shù)據(jù)庫(kù)建議統(tǒng)計(jì)根據(jù)負(fù)載情況,AWR給DBA的一些建議實(shí)例匯通統(tǒng)計(jì)MTTR建議緩存池建議PGA命中匯總PGA命中統(tǒng)計(jì)PGA命中直方圖PGA內(nèi)存建議共享庫(kù)建議SGA建議流池建議JAVAPOOL建議11,等待統(tǒng)計(jì)緩存等待統(tǒng)計(jì)隊(duì)列等待活動(dòng)12.回滾統(tǒng)計(jì)?回滾段匯總?回滾段統(tǒng)計(jì).Latch統(tǒng)計(jì)記錄的所有LATCH的統(tǒng)計(jì)信息LACTH活動(dòng)LATCH睡眠中斷LATCH丟失源Mutex睡眠匯總父Latch統(tǒng)計(jì)子Latch統(tǒng)計(jì).段信息統(tǒng)計(jì)段的邏輯讀段的物理讀段的物理讀請(qǐng)求段的未優(yōu)化讀?段的優(yōu)化讀段的直接物理讀段的物理寫段的物理寫請(qǐng)求段的直接物理寫表掃描塊改變行鎖等待ITL等待BufferBusy等待.字典CACHE統(tǒng)計(jì).庫(kù)緩存統(tǒng)計(jì).內(nèi)存統(tǒng)計(jì)內(nèi)存動(dòng)態(tài)組件?內(nèi)存組件大小重設(shè)置操作匯總進(jìn)程內(nèi)存匯總SGA內(nèi)存匯總SGA中組件變化18.復(fù)制統(tǒng)計(jì)（X流,GoldenGate）啟用了GoldenGate或XStream后就有記錄,蛤蟆這里都是空。19B流統(tǒng)計(jì)沒有設(shè)置就是空了,蛤蟆這里都是空。.資源限制統(tǒng)計(jì)資源限制管理,如果有沒有設(shè)置就是空了,蛉蟆這里都是空。.共享服務(wù)統(tǒng)計(jì)數(shù)據(jù)庫(kù)啟動(dòng)共享模式下オ有記錄。如果是專有模式就都是。了。.啟動(dòng)參數(shù)匯總修改過的非默認(rèn)的參數(shù)都列出來了,如ド:ParameterNameI Beginvalue IEndvalue(ifdifferent)audit_file_dest/u01/app/oracle/admin/toaddb/adumpaudit_trailDBcompatible.0control_files+DATA/toaddb/control01.ctl,+DATA/toaddb/control02.ctldb_block_size8192db_domaindb_nametoaddbdiagnostic_dest/u01/app/oracledispatchers(PROTOCOL=TCP)(SERVICE=toaddbXDB)localjistenerLISTENER_TOADDBopen_cursors300optimizer_adaptive_featuresFALSEparallel_max_servers8parallel_min_servers0pga_aggregate_target377487360processes300remote_login_passwordfileEXCLUSIVEsession_cached_cursors201sga_target1140850688undo_tablespaceUNDOTBS1utl_file_dir/home/oracle/logminer.ASH報(bào)告12C的AWR也包好了ASH報(bào)告,不用再手動(dòng)去生成了。.ADDM執(zhí)行在12c中,AWR報(bào)告自帶了ADDM了報(bào)告,不用再手動(dòng)生成了。.12C完整AWR報(bào)告WORKLOADREPOSITORYreportforDBNameIDBIdIInstanceIInstnumIStartupTimeIReleaseIRAC

HostNamePlatformCPUsCores1SocketsMemory(GB)OELLinuxx8664-bit13.61|Sn叩(dSnapTimeSessionsCursors/SessionBeginSnap:10209-Mar-1616:48:00331.0EndSnap:10309-Mar-1617:19:01321.1Elapsed:31.01(mins)DBTime:0.10(mins)TOADDB53626287toaddb109-Mar-1616:03.0NOReportSummaryLoadProfilePerSecondPerTransactionPerExecPerCallDBTime(s):0.00.10.000.01DBCPU(s):0.00.00.000.00BackgroundCPU(s):0.00.10.000.00Redosize(bytes):1,679.840,074.2Logicalread(blocks):40.5966.7Blockchanges:5.8138.2Physicalread(blocks):0.819.9Physicalwrite(blocks):0.410.1ReadIOrequests:0.819.5WriteIOrequests:0.25.7ReadIO(MB):0.00.2WriteIO(MB):0.00.1IMscanrows:0.00.0SessionLogicalReadIM:Usercalls:0.410.1Parses(SQL):2.970.0Hardparses(SQL):0.36.0SQLWorkArea(MB):0.11.8Logons:0.12.1Executes(SQL):5.8137.1Rollbacks:0.00.0Transactions:0.0InstanceEfficiencyPercentages(Target100%)

BufferHit%:97.95In-memorySort%:100.00LibraryHit%:89.21SoftParse%:91.37ExecutetoParse%:48.96LatchHit%:100.00ParseCPUtoParseElapsd%:47.06%Non-ParseCPU:50.82FlashCacheHit%:0.00BufferNowait%:100.00RedoNoWait%:100.00Top10ForegroundEventsbyTotalWaitTimeI EventWaitsTotalWaitTime(sec)WaitAvg(ms)%DBtimeWaitClassDBCPU231.2dbfilesequentialread951.313.2520.1UserI/Ologfilesync21147.2115.8CommitDiskfileoperationsI/O399J0.161.0UserI/OcontrolfilesequentialreadSystemI/OCSSinitialization103.25.1Otherlatch:sharedpool101.58.0ConcurrencyCSSoperation:query600.12.0OtherCSSoperation:action100.68.0Otherdirectpathwritetemp200.23.0UserI/OWaitClassesbyTotalWaitTimeWaitClassWaitsTotalWaitTime(sec)AvgWait(ms)%DBtimeAvgActiveSessionsSystemI/O5,881101.72161.50.0UserI/O2,32062.4590.70.0Other89433.4749.60.0DBCPU231.20.0Commit25139.8315.90.0Concurrency40Network37300.00.00.0Application200.10.00.0HostCPUICPUsCoresSocketsILoadAverageBeginLoadAverageEnd%User%System%WIO%ldleI 0.4 1.198.8InstanceCPU

%TotalCPU%BusyCPU%DBtimewaitingforCPU(ResourceManager)0.4 35.7 0.010ProfileRead+WritePerSecondReadperSecondWritePerSecondTotalRequests:DatabaseRequests:OptimizedRequests:0.00.00.0RedoRequests:0.10.00.1Total(MB):0.10.00.0Database(MB):0.00.00.0OptimizedTotal(MB):0.00.00.0Redo(MB):0.00.00.0Database(blocks):ViaBufferCache(blocks):1,20.80.4Direct(blocks):0.00.00.0MemoryStatisticsIBeginEnd |HostMem(MB):3,693.93,693.9SGAuse(MB):1,088.01,088.0PGAuse(MB):140.9140.1%HostMemusedforSGA+PGA:33.2733.25CacheSizesBufferCache:736M736MStdBlockSize:8KSharedPoolSize:240M240MLogBuffer:13.528KIn-MemoryArea:0M0MSharedPoolStatisticsMemoryUsage%:%SQLwithexecutions>1:MemoryUsage%:%SQLwithexecutions>1:%MemoryforSQLw/exec>1:90.4772.3470.9786.4576.6561.66MainReportReportSummaryWaitEventsStatisticsSQLStatisticsInstanceActivityStatisticsIOStatsBufferPoolStatisticsAdvisoryStatisticsWaitStatisticsUndoStatisticsLatchStatisticsSeamentStatisticsDictionaryCacheStatisticsLibraryCacheStatisticsMemoryStatisticsReplicationStatistics(GoldenGate,XStream)StreamsStatisticsResourceLimitStatisticsSharedServerStatisticsinit.oraParametersActiveSessionHistory(ASH)ReportADDMReportsBackt。TopWaitEventsStatisticsTimeModelStatisticsOperating!SystemStatisticsOperatinaSystemStatistics ?DetailForegroundWaitClassForearoundWaitEventsBackqroundWaitEventsWaitEventHistoaramWaitEventHistogramDetail(64msecto2sec)WaitEventHistoaramDetail (4secto 2 min)WaitEventHistoqramDetail (4minto 1 hr)ServiceStatisticsServiceWaitClassStatsBacktoTop

TimeModelStatisticsDBTimerepresentstotaltimeinusercallsDBCPUrepresentsCPUtimeofforegroundprocessesTotalCPUTimerepresentsforegroundandbackgroundprocessesStatisticsincludingtheword"background"measurebackgroundprocesstime,thereforedonotcontributetotheDBtimestatisticOrderedby%ofDBtimeindescendingorder,followedbyStatisticNameStatisticNameTime(s)94)ofDBTime%ofTotalCPUTimeIsqlexecuteelapsedtime4.6474.11DBCPU1.9531.1924.43parsetimeelapsed1.8830.05hardparseelapsedtime1.8329.23PL/SQLcompilationelapsedtime0.548.61PL/SQLexecutionelapsedtime0.182.88connectionmanagementcallelapsedtime0.091.38hardparse(sharingcriteria)elapsedtime0.040.63failedparseelapsedtime0.030.48repeatedbindelapsedtime0.000.03sequenceloadelapsedtime0.000.01DBtime6.26backgroundelapsedtime32.35backgroundcputime6.0475.57totalCPUtime7.99BacktoWaitEventsStatisticsBacktoTopOperatingSystemStatistics*TIMEstatisticvaluesarediffed.Allothersdisplayactualvalues.EndValueisdisplayedifdifferentorderedbystatistictype(CPUUse,VirtualMemory,HardwareConfig),NameFREE_MEMORY_BYTESINACTIVE_MEMORY_BYTESFREE_MEMORY_BYTESINACTIVE_MEMORY_BYTESSWAP_FREE_BYTES921,088,000907,710,4641,740,865,5361,696,837,6322,097,147,904StatisticValueEndValue

IDLE_TIME177,120IOWAIT_TIME1,925SYS_TIME705USER_TIME1,518LOAD0PHYSICAL_MEMORY_BYTES3,873,296,384NUM_CPUS1GLOBAL_RECEIVE_SIZE_MAX4,194,304GLOBAL_SEND_SIZE_MAX1,048,586TCP_RECEIVE_SIZE_DEFAULT87,380TCP_RECEIVE_SIZE_MAX6,291,456TCP_RECEIVE_SIZE_MIN4,096TCP_SEND_SIZE_DEFAULT16,384TCP_SEND_SIZE_MAX4,194,304TCP_SEND_SIZE_MIN4,096BUSY_TIME2,240BacktoWaitEventsStatisticsBacktoTopOperatingSystemStatistics-DetailSnapTimeLoadI%busyI%userI%sysI%idleI%iowait09-Mar16:48:000.1609-Mar17:19:010.10 1.25 0.850.3998.75 1.07BacktoWaitEventsStatisticsBacktoTopForegroundWaitClasss-second,ms-millisecond-1000thofasecondorderedbywaittimedesc,waitsdesc%Timeouts:valueof0indicatesvaluewas<.5%.Valueofnullistruly0CapturedTimeaccountsfor69.1%ofTotalDBtime6.26(s)TotalFGWaitTime:2.37(s)DBCPUtime:1.95(s)WaitClass|Waits|%Time-outsTotalWaitTime(s)Avgwait(ms)%DBtime

UserI/O496012.6721.12Commit210147.2115.84SystemI/O217000.240.82Other8000.580.07Concurrency1001.580.03Network233000.000.00Application2000.100.00DBCPU231.19BacktoWaitEventsStatisticsBacktoTopForegroundWaitEventss-second,ms-millisecond-10OOthofasecondOnlyeventswithTotalWaitTime(s)>=.001areshownorderedbywaittimedesc,waitsdesc(idleeventslast)%Timeouts:valueof0indicatesvaluewas<.5%.Valueofnullistruly0EventWaits%Time-outsTotalWaitTime(s)IAvgwait(ms)IWaits/txnI%DBtimedbfilesequentialread95113.251.2220.11logfilesync21147.210.2715.84DiskfileoperationsI/O39901controlfilesequentialread21700.242.780.82CSSinitialization103.250.010.05latch:sharedpool101.580.010.03SQL*Netmessagefromclient2342,52110774.053.00jobqslavewait1,91799955498.3724.58BacktoWaitEventsStatisticsBacktoTopBackgroundWaitEventsorderedbywaittimedesc,waitsdesc(idleeventslast)OnlyeventswithTotalWaitTime(s)>=.001areshown%Timeouts:valueof0indicatesvaluewas<.5%.Valueofnullistruly000000000000000000000989601001001001401000100100500EventIWaits[controlfileparallelwrite618dbfilesequentialread1,558dbfileparallelwrite406oraclethreadbootstrap101logfileparallelwrite243osthreadcreation101controlfilesequentialread3,992DiskfileoperationsI/O205LGWRwaitforredocopy22dbfilescatteredread8directpathwritetemp34CSSinitialization2rowcachelock1localwritewait4logfilesync4directpathwrite2ASMfilemetadataoperation372CSSoperation:query12CSSoperation:action2latch:lobsegmenthashtablelatch1rdbmsipcmessage10,742SpaceManager:slaveidlewait1,221DIAGidlewait3,719sharedserveridlewait62AQPCidle62dispatchertimer31smontimer21ASMbackgroundtimer372pmontimer620heartbeatredoinformer1,859waitforunreadmessageonbroadcast619channelIregtimer619StreamsAQ:qmncoordinatoridlewait132StreamsAQ:qmnslaveidlewait66TotalWaitTime(s)Avgwait(ms)Waits/txnI%bgtime58.727.9216.6642.7019.9713.0036.625.218.31221.021.296.5626.573.124.9319.221.292.8800.1051.181.2800.222.630.1401.140.280.0802.510.100.0600.440.440.0507.160.030.0406.960.010.0201.130.050.0101.090.050.0101.150.030.0100.004.770.0000.740.030.0001.090.010.0027,8142589.30137.725,9184846.7715.653,7191000.0847.681,86030007.410.791,86030004.640.791,86060006.850.401,86088576.390.271,8605000.044.771,8602999.887.951,8601000.4523.831,8593003.477.941,8583001.267.941,84814003.431.691,84828006.820.85175 081 0175 081 00 0.38 2.240 0.68 1.04SQL*NetmessagefromclientclassslavewaitBacktoWaitEventsStatisticsBacktoTopWaitEventHistogramUnitsforTotalWaitscolumn:Kis1000,Mis1000000,Gis1000000000%ofWaits:valueof.0indicatesvaluewas<.05%;valueofnullistruly0%ofWaits:columnheadingof<=1sistruly<1024ms,>1sistruly>=1024msOrderedbyEvent(idleeventslast)%ofWaitsEventTotalWaits<1ms<2ms<4ms<8ms<16ms<32ms<=1sASMfilemetadataoperation372100.0CSSinitialization333.333.333.3CSSoperation:action3100.0CSSoperation:query18100.0DiskfileoperationsI/O60999.2.2,2.5LGWRwaitforredocopy2240.959.1SQL*Netbreak/resettoclient2100.0SQL*Netmessagetoclient373100.0asynchdescriptorresize277100.0bufferbusywaits1100.0controlfileparallelwrite6183.4controlfilesequentialread4216,0.1.0dbfileasyncI/Osubmit406100.0dbfileparallelwrite4064.9dbfilescatteredread875.012.512.5dbfilesequentialread14572.7directpathwrite250.050.0directpathwritetemp36latch:lobsegmenthashtablelatch1100.0latch:sharedpool250.050.0localwritewait475.025.0logfileparallelwrite24339.9

logfilesync2552.032.04.012.0oraclethreadbootstrap1031.951.520.426.2osthreadcreation1037.85.835.01.0rowcachelock1100.0AQPCidle62100.0ASMbackgroundtimer372100.0DIAGidlewait372199.9.1SQL*Netmessagefromclient409SpaceManager:slaveidlewait1.97.6StreamsAQ:qmncoordinatoridlewait13250.050.0StreamsAQ:qmnslaveidlewait66100.0classslavewait831.2dispatchertimer31100.0heartbeatredoinformer186099.9.1jobqslavewait1917.199.9Iregtimer620100.0pmontimer621100.0rdbmsipcmessage10.7K.5.1.1,4.2d35.662.9sharedserveridlewait62100.0smontimer1910.510.552.6waitforunreadmessageonbroadcast621100.0channelBacktoWaitEventsStatisticsBacktoTopWaitEventHistogramDetail(64msecto2sec)UnitsforTotalWaitscolumn:Kis1000,Mis1000000,Gis1000000000Unitsfor%ofTotalWaits:msismillisecondssis1024milliseconds(approximately1second)%ofTotalWaits:totalwaitsforallwaitclasses,includingIdle%ofTotalWaits:valueof.0indicatesvaluewas<.05%;valueofnullistruly0OrderedbyEvent(onlynon-idleeventsaredisplayed)%3TotalWaitsEvent Waits64msto2sI<32ms<64ms<1/8s<1/4s<1/2s<1s<2s>=2scontrolfileparallelwrite 21 96.6 .8 1.1 .5 .8.2controlfilesequentialread 1 100.0 .0

dbfileparallelwrite201.0dbfilesequentialread40.2logfileparallelwrite896.71.6,4.4 .8logfilesync388.04.04.0 4.0oraclethreadbootstrap2773.825.21.0osthreadcreation199.01.0BacktoWaitEventsStatisticsBacktoTopWaitEventHistogramDetail(4secto2min)Nodataexistsforthissectionofthereport,BacktoWaitEventsStatisticsBacktoTopWaitEventHistogramDetail(4minto1hr)Nodataexistsforthissectionofthereport.BacktoWaitEventsStatisticsBacktoTopServiceStatisticsorderedbyDBTimeIServiceNameDBTime(s)DBCPU(s)PhysicalReads(K)LogicalReads(K)lSYS$USERS62023SYS$BACKGROUND00151toaddb0000toaddbXDB0000BacktoWaitEventsStatisticsBacktoTopServiceWaitClassStatsWaitClassinfoforservicesintheServiceStatisticssection.TotalWaitsandTimeWaiteddisplayedforthefollowingwaitclasses:UserI/O,Concurrency,Administrative,NetworkTimeWaited(WtTime)insecondsUserServiceNameI/OTotalWtsUserI/OWtTimeConcurcyTotalWtsConcurcyWtTimeAdminTotalWtsAdminWtTimeNetworkTotalWtsNetworkWtTimeSYS$USERS579510002330SYS$BACKGROUNacktoWaitEventsStatisticsBacktoTopSQLStatisticsSQLorderedbvElapsedTimeSQLorderedbvCPUTimeSQLorderedbvUserI/OWaitTimeSQLorderedbvGetsSQLorderedbvReadsSQLorderedbvPhysicalReads(UnOptimized)SQLorderedbvExecutionsSQLorderedbvParseCallsSQLorderedbvSharableMemorySQLorderedbvVersionCoentCompleteListofSQLTextBacktoTodSQLorderedbyElapsedTimeResourcesreportedforPL/SQLcodeincludestheresourcesusedbyallSQLstatementscalledbythecode.%TotalDBTimeistheElapsedTimeoftheSQLstatementdividedintotheTotalDatabaseTimemultipliedby100%Total-ElapsedTimeasapercentageofTotalDBtime%CPU-CPUTimeasapercentageofElapsedTime

%IO-UserI/OTimeasapercentageof