首页 > 代码库 > AWR报告简易分析

AWR报告简易分析

 Snap IdSnap TimeSessionsCursors/Session
Begin Snap:356692012-11-8 13:00124611.3
End Snap:356792012-11-8 18:0083416
Elapsed: 300.14  
DB Time: 2,841.67  
     
Operating System StatisticsTime Model Statistics 
     
StatisticTotalStatistic NameTime (s)% of DB Time
NUM_LCPUS0sql execute elapsed time87,551.8499.97
NUM_VCPUS0DB CPU248.770.28
AVG_BUSY_TIME126,487parse time elapsed2.760
AVG_IDLE_TIME1,675,188hard parse elapsed time1.470
AVG_IOWAIT_TIME2,687failed parse elapsed time0.450
AVG_SYS_TIME11,000PL/SQL execution elapsed time0.840
AVG_USER_TIME114,879hard parse (sharing criteria) elapsed time0.320
BUSY_TIME48,496hard parse (bind mismatch) elapsed time14.160.01
IDLE_TIME8,623,372sequence load elapsed time9.80.01
IOWAIT_TIME7,728repeated bind elapsed time0.010
SYS_TIME5,691PL/SQL compilation elapsed time2.030
USER_TIME42,512connection management call elapsed time1.70
LOAD0inbound PL/SQL rpc elapsed time0.020
OS_CPU_WAIT_TIME7,404,200DB time87577.44 
RSRC_MGR_CPU_WAIT_TIME0background elapsed time1585.54 
PHYSICAL_MEMORY_BYTES135,319,207,936background cpu time206.8 
NUM_CPUS48   
NUM_CPU_CORES24   
     
     
     
每个CPU耗时:=DB Time/逻辑cpu个数59.20min 
DB利用率:=DB Time/(NUM_CPUS*Elapsed)*100%19.72% NUM_CPUS是逻辑cpu个数
CPU利用率:=(DB CPU + background cpu time )/(NUM_CPUS*Elapsed )*100%0.08% NUM_CPUS是实际cpu个数
%User =USER_TIME/(BUSY_TIME+IDLE_TIME)*100%0.49%  
%Sys  = SYS_TIME/(BUSY_TIME+IDLE_TIME)*100%0.07%  
%Idle = IDLE_TIME/(BUSY_TIME+IDLE_TIME)*100%99.44%  
ELAPSED_TIME=(BUSY_TIME+IDLE_TIME)/1000Elapsed*60*60  
8671.8681080504.00  
     
Service Statistics    
     
ordered by DB Time    
     
Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS87,476.00146.003,26251,625
oradb11101.00102.000545
SYS$BACKGROUND00126
     
Total DB Time87577.0   
Total DB Cpu248.0   
% DB Time0.28%   

AWR报告简易分析