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

34.0racle深度學(xué)習(xí)筆記ーー12C的AWR初步解讀34.0racle深度學(xué)習(xí)筆記——12C的AWR初步解讀/notbaron/article/details/50840016歡迎轉(zhuǎn)載關(guān)于AWR,我也經(jīng)?？础Ｒ?yàn)榻?jīng)?？磩e人給出的建議,很難有深刻體會。對此,計(jì)劃花費(fèi)幾個晚上時間好好體會一把并記錄下來。此處以單實(shí)例為例。列出目錄便于整體理解。目錄.快照生成方法...1.生成AWR報告...1.系統(tǒng)描述...3.報告匯總...31負(fù)載信息...3.等待事件統(tǒng)計(jì)...31時間模型統(tǒng)計(jì)...31操作系統(tǒng)統(tǒng)計(jì)…31操作系統(tǒng)統(tǒng)計(jì)詳細(xì)…41前臺等待類...41前臺等待事件…4!后臺等待事件...4!等待事件直方圖...4!等待事件直方圖的詳細(xì)（64ms到2s）...4!等待事件直方圖的詳細(xì)（4ms到2min）…4!等待事件直方圖的詳細(xì)（4ms到Ihr）...4!服務(wù)統(tǒng)計(jì)...5!服務(wù)等待類統(tǒng)計(jì)…5.SQL統(tǒng)計(jì)...5!通過執(zhí)行時間排序...51通過CPU時間排序...51通過USER10排序...51通過Gets排序...51通過Reads排序...51通過物理讀（無優(yōu)化）排序...6!通過執(zhí)行數(shù)量排序...61通過解析調(diào)用排序...61通過共享內(nèi)存排序...61通過打開的子游標(biāo)排序...61SQL文本的完整列表...6.實(shí)例活動統(tǒng)計(jì)...6!關(guān)鍵實(shí)例活動統(tǒng)計(jì)...6!實(shí)例活動統(tǒng)計(jì)...7!實(shí)例活動統(tǒng)計(jì)的絕對值...7!實(shí)例活動統(tǒng)計(jì)的進(jìn)程活動...7.10狀態(tài)...7!函數(shù)引起的I0..7!文件類型引起的I0..71函數(shù)或文件類型的I0..71表空間的I0..71文件的I0..8.緩存池統(tǒng)計(jì)...8. 數(shù)據(jù)庫建議統(tǒng)計(jì)...81實(shí)例匯通統(tǒng)計(jì)...81MTTR建議…8!緩存池建議…81PGA命中匯總...81PGA命中統(tǒng)計(jì)...81PGA命中直方圖...91PGA內(nèi)存建議...9!共享庫建議...91SGA建議...91流池建議…9JAVAPOOL建議...9等待統(tǒng)計(jì)...91緩存等待統(tǒng)計(jì)…91隊(duì)列等待活動...10回滾統(tǒng)計(jì)...10!回滾段匯總...10!回滾段統(tǒng)計(jì)...10Latch統(tǒng)計(jì)...101LACTH活動...101LATCH睡眠中斷…101LATCH丟失源...101Mutex睡眠匯總...111父Latch統(tǒng)計(jì)…11!子Latch統(tǒng)計(jì)...1114. 段信息統(tǒng)計(jì)...11I段的邏輯讀...11!段的物理讀...11!段的物理讀請求...111段的未優(yōu)化讀...111段的優(yōu)化讀…121段的直接物理讀…12!段的物理寫…12!段的物理寫請求…121段的直接物理寫…121表掃描…12!塊改變…12!行鎖等待…121ITL等待…121BufferBusy等待...1315I字典CACHE統(tǒng)計(jì)…13.庫緩存統(tǒng)計(jì)…13.內(nèi)存統(tǒng)計(jì)...13!內(nèi)存動態(tài)組件…13!內(nèi)存組件大小重設(shè)置操作匯總…13!進(jìn)程內(nèi)存匯總...131SGA內(nèi)存匯總...141SGA中組件變化...14復(fù)制統(tǒng)計(jì)（X流,GoldenGate）...14流統(tǒng)計(jì)…14資源限制統(tǒng)計(jì)…14共享服務(wù)統(tǒng)計(jì)…14啟動參數(shù)匯總...14ASH報告”.15ADDM執(zhí)行...1512c完整AWR報告...16.快照生成方法如下:SQL>execdbms_workload_repository.create_snapshot();.生成AWR報告如下:SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sqlCurrentInstanceDBIdDBNameInstNumInstance53626287TOADDBltoaddbSpecifytheReportTypeAWRreportscanbegeneratedinthefollowingformats.Pleaseenterthenameoftheformatattheprompt.Defaultvalueis'html’.'html* HTMLformat(default)'text' Textformat'active-html'IncludesPerformanceHubactivereportEntervalueforreport_type:htmlTypeSpecified:htmlInstancesinthisWorkloadRepositoryschemaDBldInstNumDBName InstanceHost*53626287 1TOADDB toaddb OELUsing53626287fordatabaseIdUsing1forinstancenumberSpecifythenumberofdaysofsnapshotstochoosefromEnteringthenumberofdays(n)willresultinthemostrecent(n)daysofsnapshotsbeinglisted.Pressing<return>withoutspecifyinganumberlistsallcompletedsnapshots.Entervaluefornum_days:lListingthelastday'sCompletedSnapshotsSnapInstanceDBNameSnapIdSnapStartedLeveltoaddbTOADDB10209Mar201616:48 110309Mar201617:19 1SpecifytheBeginandEndSnapshotIdsへEntervalueforbegin_snap:102BeginSnapshotIdspecified:102Entervalueforend_snap:103EndSnapshotIdspecified:103SpecifytheReportNameThedefaultreportfilenameisawrrpt_l_102_103.html.Tousethisname,press<return>tocontinue,otherwiseenteranalternative.Entervalueforreport_name:test_awr.htmlUsingthereportnametest_awr.html然后在當(dāng)前目錄下生成一個test_awr.html的awr報告。

系統(tǒng)描述DBNameTOADDBDBId Inst53626287toadョneeInstnumStartiupTimear-1616:03Release.0RACNOdb1 09-M;HostNameOELPlatform CPUs CoresLinuxx8664-bit 1SocketsMemory(GB)3.61SnapIdSnapTimeSessionsCursors/SessionBeginSnap:10209-Mar-1616:48:00331.0EndSnap:Elapsed:DBTime:10309-Mar-1617:19:0131.01(mins)0.10(mins)321.1描述了數(shù)據(jù)的ID,數(shù)據(jù)庫名字,啟動時間,版本,快照號,運(yùn)行的版本,CPU數(shù)量,內(nèi)存大小,快照抓取時間,開始的會話數(shù)量,結(jié)束時候的會話數(shù)量,每個會話的游標(biāo)數(shù)量等。報告匯總!負(fù)載信息!實(shí)例命中ITOP10等待的前臺事件!按等待事件的等待類I主機(jī)系統(tǒng)CPUI實(shí)例的CPUI10負(fù)載總體!內(nèi)存統(tǒng)計(jì)總體ICACHAE大小I共享池統(tǒng)計(jì)等待事件統(tǒng)計(jì)I時間模型統(tǒng)計(jì)I操作系統(tǒng)統(tǒng)計(jì)I操作系統(tǒng)統(tǒng)計(jì)詳細(xì)I前臺等待類I前臺等待事件!后臺等待事件!等待事件直方圖!等待事件直方圖的詳細(xì)（64ms到2s）!等待事件直方圖的詳細(xì)（4ms到2min）!等待事件直方圖的詳細(xì)（4ms到Ihr）I服務(wù)統(tǒng)計(jì)!服務(wù)等待類統(tǒng)計(jì)SQL統(tǒng)計(jì)!通過執(zhí)行時間排序1通過CPU時間排序1通過USER10排序1通過Gets排序1通過Reads排序1通過物理讀（無優(yōu)化）排序!通過執(zhí)行數(shù)量排序1通過解析調(diào)用排序I通過共享內(nèi)存排序!通過打開的子游標(biāo)排序ISQL文本的完整列表實(shí)例活動統(tǒng)計(jì)!關(guān)鍵實(shí)例活動統(tǒng)計(jì)!實(shí)例活動統(tǒng)計(jì)!實(shí)例活動統(tǒng)計(jì)的絕對值!實(shí)例活動統(tǒng)計(jì)的進(jìn)程活動10狀態(tài)I函數(shù)引起的10I文件類型引起的10I函數(shù)或文件類型的10I表空間的10!文件的10緩存池統(tǒng)計(jì)緩沖池中包含默認(rèn)的和其他塊大小的。數(shù)據(jù)庫建議統(tǒng)計(jì)根據(jù)負(fù)載情況,AWR給DBA的一些建議I實(shí)例匯通統(tǒng)計(jì)IMTTR建議!緩存池建議IPGA命中匯總IPGA命中統(tǒng)計(jì)IPGA命中直方圖IPGA內(nèi)存建議!共享庫建議ISGA建議I流池建議IJAVAPOOL建議等待統(tǒng)計(jì)I緩存等待統(tǒng)計(jì)I隊(duì)列等待活動回滾統(tǒng)計(jì)I回滾段匯總I回滾段統(tǒng)計(jì)Latch統(tǒng)計(jì)記錄的所有LATCH的統(tǒng)計(jì)信息ILACTH活動ILATCH睡眠中斷ILATCH丟失源IMutex睡眠匯總I父Latch統(tǒng)計(jì)!子Latch統(tǒng)計(jì)段信息統(tǒng)計(jì)I段的邏輯讀|段的物理讀|段的物理讀請求I段的未優(yōu)化讀I段的優(yōu)化讀!段的直接物理讀|段的物理寫|段的物理寫請求I段的直接物理寫!表掃描!塊改變I行鎖等待IITL等待IBufferBusy等待字典CACHE統(tǒng)計(jì)庫緩存統(tǒng)計(jì)內(nèi)存統(tǒng)計(jì)!內(nèi)存動態(tài)組件!內(nèi)存組件大小重設(shè)置操作匯總!進(jìn)程內(nèi)存匯總ISGA內(nèi)存匯總ISGA中組件變化復(fù)制統(tǒng)計(jì)（X流,GoldenGate）啟用了GoldenGate或XStream后就有記錄,蛤蟆這里都是空。流統(tǒng)計(jì)沒有設(shè)置就是空了,蛤蟆這里都是空。資源限制統(tǒng)計(jì)資源限制管理,如果有沒有設(shè)置就是空了,蛤蟆這里都是空。共享服務(wù)統(tǒng)計(jì)數(shù)據(jù)庫啟動共享模式下オ有記錄。如果是專有模式就都是。了。啟動參數(shù)匯總修改過的非默認(rèn)的參數(shù)都列出來了，如下:ParameterNameBeginvalue Endvalue(ifdifferent)audit_file_dest/uOl/app/oracle/admin/toaddb/adumpaudit_trailDBcompatible.0control_files+DATA/toaddb/control01.ctl,+DATA/toaddb/control02.ctldb_block_size8192db_domaindb_nametoaddbdiagnostic_dest/uOl/app/oracledispatchers(PROTOCOL=TCP)(SERVICE=toaddbXDB)

open_cursors300optimizer^adaptive_featuresFALSEparallel_max_servers8parallel_min_servers0pga_aggregate_target377487360processes300remotejogin.passwordfileEXCLUSIVEsession_cached_cursors201sga.target1140850688undo_tablespaceUNDOTBS1utl_file_dir/home/oracle/logminerlocaljistenerLISTENERTOADDB23.ASH報告12c的AWR也包好了ASH報告,不用再手動去生成了。24.ADDM執(zhí)行在12c中,AWR報告自帶了ADDM了報告,不用再手動生成了。2512C完整2512C完整AWR報告DBNameDBIdInstanceInstnumStartupTimeReleaseRACTOADDB53626287toaddb109-Mar-1616:03.0NOHostNamePlatformCPUsCoresSocketsMemory(GB)OELLinuxx8664-bit13.61SnapId SnapTimeSessionsCursors/SessionBeginSnap:10209-Mar-1616:48:0033 1.0EndSnap: 10309-Mar-1617:19:0132 1.1Elapsed:31.01(mins)DBTime:0.10(mins)ReportSummaryLoadProfilePerSecondPerTransactionPerExecPerCallDBTime(s):0.00.1 0.00 0.01DBCPU(s):0.00.0 0.00 0.00BackgroundCPU(s):0.00.1 0.00 0.00Redosize(bytes):1,679.840,074.2Logicalread(blocks):40.5966.7Blockchanges:5.8138.2Physicalread(blocks):0.819.9Physicalwrite(blocks):0.410.1ReadIOrequests:0.819.5

Write10requests:0.25.7Read10(MB):0.00.2Write10(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%)BufferNowait%:100.00RedoNoWait%: 100.00BufferHit%:97.95 In-memorySort%: 100.00LibraryHit%:89.21 SoftParse%: 91.37ExecutetoParse%:48.96LatchHit%: 100.00ParseCPUtoParseElapsd%:47.06 %Non-ParseCPU: 50.82FlashCacheHit%:0.00Top10ForegroundEventsbyTotalWaitTimeEventWaitsTotalWaitTime(sec)WaitAvg(ms)%DBtimeWaitClassDBCPU231.2dbfilesequential951.313.2520.1UserI/Oreadlogfilesync21147.2115.8Commit

Diskfileoperations399 .10.161.0UserI/OI/Ocontrolfile 217 .1sequentialread0.24.8SystemI/OCSSinitialization 1 03.25.1Otherlatch:sharedpool1 01.58.0ConcurrencyCSSoperation: 6 0query0.12.0OtherCSSoperation: 1 0action0.68.0Otherdirectpathwrite 2 0temp0.23.0UserI/OWaitClassesbyTotalWaitTimeWaitClassWaitsTotalWaitAvgWait%DBAvgActiveTime(sec)(ms)timeSessionsSystemI/O5,881101.72161.50.0UserI/O 2,32062.4590.70.0Other 894 3DBCPU 23.4749.631.20.00.0Commit 25 139.8315.90.0Concurrency4 0Network 373 00.00.00.0Application2 00.10.00.0HostCPUCPUCoreSocketLoadLoad %Use%Syste%WI%Idls s s AverageBeginAveragreEndmO e1 0.160.10 98.8InstanceCPU

%TotaICPU%BusyCPU%DBtimewaitingforCPU(ResourceManager)%TotaICPU%BusyCPU0.4 35.7 0.0IOProfileRead+WritePerSecondReadperSecondWritePerSecondTotalRequests:4.13.1 1.0DatabaseRequests:1.10.8 0.2OptimizedRequests:0.00.0 0.0RedoRequests:0.10.0 0.1Total(MB):0.10.0 0.0Database(MB):0.00.0 0.0OptimizedTotal(MB):0.00.0 0.0Redo(MB):0.00.0 0.0Database(blocks):1.30.8 0.4ViaBufferCache(blocks):1.20.8 0.4Direct(blocks):0.00.0 0.0MemoryStatisticsBeginEndHostMem(MB):3,693.9 3,693.9SGAuse(MB):1,088.0 1,088.0PGAuse(MB):140.9 140.1%HostMemusedforSGA+PGA:33.27 33.25CacheSizesBeginEndBufferCache:736M 736MStdBlockSize: 8KSharedPoolSize:240M 240MLogBuffer: 13,528K

SharedPoolStatisticsBeginEndMemoryUsage%:90.4786.45%SQLwithexecutions>l:72.3476.65%MemoryforSQLw/exec>l:70.9761.66In-MemoryArea:OMOMIn-MemoryArea:OMOMMainReportReportSummaryWaitEventsStatisticsSQLStatisticsInstanceActivityStatisticsIOStatsBufferPoolStatisticsAdvisoryStatisticsWaitStatisticsUndoStatisticsLatchStatisticsSegmentStatisticsDictionaryCacheStatisticsLibraryCacheStatisticsMemoryStatisticsReplicationStatistics(GoldenGate,XStream)StreamsStatisticsResourceLimitStatisticsSharedServerStatisticsinit.oraParametersActiveSessionHistory(ASH)ReportADDMReportsBacktoTopWaitEventsStatisticsTimeModelStatisticsOperatingSystemStatisticsOperatingSystemStatistics-DetailForegroundWaitClassForegroundWaitEventsBackgroundWaitEventsWaitEventHistogramWaitEventHistogramDetail(64msecto2sec)WaitEventHistogramDetail(4secto2min)WaitEventHistogramDetail(4minto1hr)ServiceStatisticsServiceWaitClassStatsBacktoTopTimeModelStatisticsDBTimerepresentstotaltimeinusercallsDBCPUrepresentsCPUtimeofforegroundprocessesTotalCPUTimerepresentsforegroundandbackgroundprocessesStatisticsincludingtheword"background"measurebackgroundprocesstime,thereforedonotcontributetotheDBtimestatisticOrderedby%ofDBtimeindescendingorder,followedbyStatisticNameStatisticNameTime⑸%ofDBTime%ofTotalCPUTimesqlexecuteelapsedtime4.6474.11DBCPU1.9531.1924.43parsetimeelapsed1.8830.05hardparseelapsedtime1.8329.23PL/SQLcompilationelapsedtime0.548.61PL/SQLexecutionelapsedtime0.182.88connectionmanagementcallelapsed0.091.38timehardparse(sharingcriteria)elapsed0.040.63timefailedparseelapsedtime0.030.48repeatedbindelapsedtime0.000.03sequenceloadelapsedtime0.000.01DBtime6.2632.35backgroundelapsedtime32.35backgroundcputime 6.04 75.57totalCPUtime 7.99BacktoWaitEventsStatisticsBacktoTopOperatingSystemStatistics*TIMEstatisticvaluesarediffed.Allothersdisplayactualvalues.EndValueisdisplayedifdifferentorderedbystatistictype(CPUUse,VirtualMemory,HardwareConfig),NameStatisticValueEndValueFREE-MEMORY-BYTES921,088,000907,710,464INACTIVE-MEMORY-BYTES1,740,865,5361,696,837,632SWAP_FREE_BYTES2,097,147,904BUSY.T1ME2,240IDLE_TIME177,120IOWAIT_TIME1,925SYS.TIME705USER_TIME1,518LOAD00PHYSICAL_MEMORY_BYTES3,873,296,384NUM_CPUS1GLOBAL_RECEIVE_S1ZE_MAX4,194,304GLOBAL_SEND_SIZE_MAX1,048,586TCP-RECEIVE一SIZE-DEFAULT87,380TCP_RECE1VE_SIZE_MAX6,291,456TCP_RECEIVE_SIZE_MIN4,096

16,3844,194,30416,3844,194,3044,096TCP_SEND_SIZE_MAXTCP_SEND_SIZE_MINBacktoWaitEventsStatisticsBacktoTopOperatingSystemStatistics-DetailSnapTimeLoad%busy%user%sys%idle%iowait09-Mar16:48:000.1609-Mar17:19:050.3998.751.07BacktoWaitEventsStatisticsBacktoTopForegroundWaitClasss-second,ms-millisecond-1000thofasecondorderedbywaittimedesc,waitsdesc%Timeouts:valueof0indicatesvaluewas<.5%,Valueofnullistruly0CapturedTimeaccountsfor69.1%ofTotalDBtime6.26(s)TotalFGWaitTime:2.37(s)DBCPUtime:1.95(s)WaitClassWaits%Time-outsTotalWaitTime⑸Avgwait(ms)%DBtimeDBCPU231.19UserI/O496012.6721.12Commit210147.2115.84SystemI/O217000.240.82Other8000.580.07Concurrency1001.580.03Network233000.000.00

Application20.100.00Application20.100.00BacktoWaitEventsStatisticsBacktoTopForegroundWaitEventss-second,ms-millisecond-1000thofasecondOnlyeventswithTotalWaitTime(s)>=.001areshownorderedbywaittimedesc,waitsdesc(idleeventslast)%Timeouts:valueof0indicatesvaluewas<.5%,Valueofnullistruly0EventWaits%Time-outsTotalWaitTime(s)Avgwait(ms)Waits/txn%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%.Valueofnullistruly0

EventWaits%Time-outsTotalWaitTime(s)Avgwait(ms)Waits/txn%bgtimecontrolfileparallelwrite618058.727.9216.66dbfilesequentialread1,558042.7019.9713.00dbfileparallelwrite406036.625.218.31oraclethreadbootstrap1010221.021.296.56logfileparallelwrite243026.573.124.93osthreadcreation101019.221.292.88controlfilesequentialread3,992000.1051.181.28DiskfileoperationsI/O205000.222.630.14LGWRwaitforredocopy22001.140.280.08dbfilescatteredread8002.510.100.06directpathwritetemp34000.440.440.05CSSinitialization2007.160.030.04rowcachelock1006.960.010.02localwritewait4001.130.050.01logfilesync4001.090.050.01directpathwrite2001.150.030.01ASMfilemetadataoperation372000.004.770.01CSSoperation:12000

queryCSSoperation:action2000.740.030.00latch:lobsegmenthashtablelatch1001.090.010.00rdbmsipcmessage10,7429827,8142589.30137.72SpaceManager:slaveidlewait1,221965,9184846.7715.65DIAGidlewait3,71903,7191000.0847.68sharedserveridlewait621001,86030007.410.79AQPCidle621001,86030004.640.79dispatchertimer311001,86060006.850.40smontimer21141,86088576.390.27ASMbackgroundtimer37201,8605000.044.77pmontimer6201001,8602999.887.95heartbeatredoinformer1,85901,8601000.4523.83waitforunreadmessageonbroadcastchannel6191001,8593003.477.94Iregtimer6191001,8583001.267.94StreamsAQ:qmncoordinatoridlewait132501,84814003.431.69StreamsAQ:qmnslaveidlewait6601,84828006.820.85SQL*Netmessagefromclient175000.382.24classslavewait81000.681.04BacktoWaitEventsStatisticsBacktoTopWaitEventHistogramUnitsforTotalWaitscolumn:Kis1000,Mis1000000,Gis1000000000%ofWaits:valueof.0indicatesvaluewas<.05%;valueofnullistruly0%ofWaits:columnheadingof<=lsistruly<1024ms,>lsistruly>=1024msOrderedbyEvent(idleeventslast)%ofWaitsEventTotalWaits<lms<2ms<4ms<8ms<16ms<32ms<=ls>lsASMfilemetadataoperationCSSinitialization333.333.333.3CSSoperation:action3100.0CSSoperation:query18DiskfileoperationsI/O60999.2.2,2.5LGWRwaitforredocopy2240.959.1SQL*Netbreak/resettoclient2SQL*Netmessagetoclient373100.0asynchdescriptorresize277100.0bufferbusywaits100.0controlfileparallelwrite6183.4controlfilesequentialread421698.61.2,1,0dbfileasyncI/Osubmit406100.0dbfileparallelwrite4064.9dbfilescatteredread875.012.5dbfilesequentialread14572.7directpathwrite250.050.0directpathwritetemp3694.42.8latch:lobsegmenthashtablelatch1100.0latch:sharedpool250.050.0localwritewait475.0logfileparallelwrite24339.949.43.3,logfilesync2552.032.04.012.0oraclethreadbootstrap1.951.520.426.2osthreadcreation1037.85.835.01.0rowcachelock1AQPCidle62100.0ASMbackgroundtimer372100.0DIAGidlewait372199.9,1SQL*Netmessagefromclient40989.5,7,7.2,57.6,7SpaceManager:slaveidlewait1218.1.2,2,4.2,21.197.6StreamsAQ:qmncoordinatoridlewait13250.050.0StreamsAQ:qmnslaveidlewait66100.0classslavewait831.2dispatchertimerheartbeatredoinformer186099.9,1jobqslavewait191799.9Iregtimerpmontimer621100.0rdbmsipcmessage10.7K,.2,135.662.9sharedserveridlewait62100.0smontimer1910.510.552.6waitforunreadmessageonbroadcastchannelBacktoWaitEventsStatisticsBacktoTopWaitEventHistogramDetail(64msecto2sec)UnitsforTotalWaitscolumn:Kis1000,Mis1000000,Gis1000000000Unitsfor%ofTotalWaits:msismillisecondssis1024milliseconds(approximately1second)%ofTotalWaits:totalwaitsforallwaitclasses,includingIdle%ofTotalWaits:valueof.0indicatesvaluewas<.05%;valueofnullistruly0OrderedbyEvent(onlynon-idleeventsaredisplayed)%ofTotalWaitsEventWaits64msto2s<32ms<64ms<l/8s<l/4s<l/2s<ls<2s>=2scontrolfileparallelwrite2196.61.1,5.8.2controlfilesequentialread1100.0.0dbfileparallelwrite20dbfilesequentialread40.2logfileparallelwrite96.71.6,4,8logfilesync388.04.04.04.0oraclethreadbootstrap2773.825.21.0osthreadcreation199.01.0BacktoWaitEventsStatisticsBacktoTopWaitEventHistogramDetail(4secto2min)Nodataexistsforthissectionofthereport.WaitEventHistogramDetail(4minto1hr)Nodataexistsforthissectionofthereport.BacktoWaitEventsStatisticsBacktoTopServicestatistics?orderedbyDBTimeServiceNameDBTime⑸DBCPU⑸PhysicalReads(K)LogicalReads(K)SYS$USERS62023SYS$BACKGROUND00151toaddb0000toaddbXDB0000BacktoWaitEventsStatisticsBacktoTopServiceWaitClassStatsWaitClassinfoforservicesintheServiceStatisticssection.TotalWaitsandTimeWaiteddisplayedforthefollowingwaitclasses:UserI/O,Concurrency,Administrative,NetworkTimeWaited(WtTime)insecondsServiceNameUserI/OTotalWtsUserI/OwtTimeConcurcyTotalWtsConcurcyWtTimeAdminTotalWtsAdminWtTimeNetworkTotalWtsNetworkWtTimeSYS$USERS579510002330SYS$BACKGRO1433300000UND4SQLStatisticsSQLorderedbyElapsedTimeSQLorderedbyCPUTimeSQLorderedbyUserI/OWaitTimeSQLorderedbyGetsSQLorderedbyReadsSQLorderedbyPhysicalReads(UnOptimized)SQLorderedbyExecutionsSQLorderedbyParseCallsSQLorderedbySharableMemorySQLorderedbyVersionCountCompleteListofSQLTextBacktoTopSQLorderedbyElapsedTimeResourcesreportedforPL/SQLcodeincludestheresourcesusedbyallSQLstatementscalledbythecode.%TotalDBTimeistheElapsedTimeoftheSQLstatementdividedintotheTotalDatabaseTimemultipliedby100%Total-ElapsedTimeasapercentageofTotalDBtime%CPU-CPUTimeasapercentageofElapsedTime?%IO-UserI/OTimeasapercentageofElapsedTime?CapturedSQLaccountfor304.3%ofTotalDBTime(s):6?CapturedPL/SQLaccountfor272.8%ofTotalDBTime(s):6ElaExecuEla%T%c%SQLIdSQLSQLTextpsetionspseotalPUIOModuleddTimTimee⑸perExec(s)13.502168.289.bc7gjv3psqlplus@BEGIN7.80876pdtbzOEL(TNSdbms_workload_reV1-V3)pository...2.5212.5240.45.37.fhf8upaxMMON.SLBEGIN3155565cxszAVEsys.dbms_auto_reportjnt...

2.1912.1935.0150.7129.505k5207588w9ryMMON.SLAVESELECTDBMS.REPORT.GET_REPORT(…1.90260.0730.431.3199.24c3zymn7x3k6wyselectobj#,dataobj#,part#,...1.5411.5424.690.7199.39g67y24u07t8