ORACLE AWR报告生成和分析

epositorycreatesnapshotoadepositorycreatesnapshotrdbmsadmin/awrrpt如果关注数据库的性能，那么当拿到一份AWR报告的时候，最想知道的第%User=USER_TIME/(BUSY_TIME+IDLE_TIME)*100=146355/(152946+41230)*100=75.37%Sys=SYS_TIME/(BUSY_TIME+IDLE_TIME)*100%Idle=IDLE_TIME/(BUSY_TIME+IDLE_TIME)*100DTIMECPUCOUNT正确的理解这个公式可以对系统CPU资源的使用及其度量的方式有更深一dslapsedtime令RMANcputime(backup/restore)令hardparseelapsedtimeesharingcriteriaelapsedtimeebindmismatchelapsedtime令failedparseelapsedtimefailedparse(outofsharedmemory)elapsedtimeTotalDBCPUDBCPUbackgroundcputime=1305.89+35.91=1341.8SYTIMEIDLETIMEU内存等等，这些对资源的利用同样可以利用这个系统的CPU个数是8，因此我们可以知道前台进程用了系统CPU的UPUreaddirectpathwritePXDeqreadcreditPXDeq:SlaveSessionStats这些就是占TopTimedForegroundEvents不看LoadDBCPUDBTIME.2FGWaitTime63是造成DBCPU+FGWaitTime<DBTime的一个重要RedoSize:‘redosize’LogicalreadssessionlogicalreadsordbblockgetsconsistentgetsBlocksChanges=‘dbblockchanges’Physicalreads=‘physicalreads’hysicalwritesphysicalwritesritesBlockSize024/1024/1024=1533MB/sphysicalreadtotalbytesphysicalwritetotalbytesLoadProfile剩下的部分主要是关于各种执行情况的统计，除了W/AMBatBlocksChanges:‘dbblockchanges’Usercalls:‘usercalls’Parses:‘parsecount(total)’Hardparses:‘parsecount(hard)’Logons:‘logonscumulative’Executes:‘executecount’Rollbacks:‘userrollbacks’Tranasactions:‘userrollbacks’+‘usercommits’W/AMBprocessed:‘bytesprocessed’如果这个系列是按“总-分-总”组织的话，接下来的系列应该是进行“分”le他刚好有一份AWR报告，在这份报告里，出现了严重的CPUusedbythisOSBusy080+5384293)=25%InstCPUusingDBCPU2%InstCPUusingCPUusedbythissession4293)=6%PU“priorto10gOracleusuallyupdatedtimefiguresattheendofeachdatabasecallbutfrom10gtherearesomeviewswheretimeisupdatedmoreregularly.TheDBCPUfromvsesstimemodelincreaseseverysixsecondswhilethe“C