博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

AWR报告简易分析

Posted on 2014-12-30 16:50  徐正柱-  阅读(534)  评论(0编辑  收藏  举报
  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 35669 2012-11-8 13:00 1246 11.3
End Snap: 35679 2012-11-8 18:00 834 16
Elapsed:   300.14    
DB Time:   2,841.67    
         
Operating System Statistics Time Model Statistics  
         
Statistic Total Statistic Name Time (s) % of DB Time
NUM_LCPUS 0 sql execute elapsed time 87,551.84 99.97
NUM_VCPUS 0 DB CPU 248.77 0.28
AVG_BUSY_TIME 126,487 parse time elapsed 2.76 0
AVG_IDLE_TIME 1,675,188 hard parse elapsed time 1.47 0
AVG_IOWAIT_TIME 2,687 failed parse elapsed time 0.45 0
AVG_SYS_TIME 11,000 PL/SQL execution elapsed time 0.84 0
AVG_USER_TIME 114,879 hard parse (sharing criteria) elapsed time 0.32 0
BUSY_TIME 48,496 hard parse (bind mismatch) elapsed time 14.16 0.01
IDLE_TIME 8,623,372 sequence load elapsed time 9.8 0.01
IOWAIT_TIME 7,728 repeated bind elapsed time 0.01 0
SYS_TIME 5,691 PL/SQL compilation elapsed time 2.03 0
USER_TIME 42,512 connection management call elapsed time 1.7 0
LOAD 0 inbound PL/SQL rpc elapsed time 0.02 0
OS_CPU_WAIT_TIME 7,404,200 DB time 87577.44  
RSRC_MGR_CPU_WAIT_TIME 0 background elapsed time 1585.54  
PHYSICAL_MEMORY_BYTES 135,319,207,936 background cpu time 206.8  
NUM_CPUS 48      
NUM_CPU_CORES 24      
         
         
         
每个CPU耗时:= DB Time/逻辑cpu个数 59.20 min  
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)/1000 Elapsed*60*60    
8671.868 1080504.00    
         
Service Statistics     
         
ordered by DB Time        
         
Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 87,476.00 146.00 3,262 51,625
oradb11 101.00 102.00 0 545
SYS$BACKGROUND 0 0 1 26
         
Total DB Time 87577.0      
Total DB Cpu 248.0      
% DB Time 0.28%