今天群里面一位兄弟问AWR中的%BUSY CPU是什么意思
|
%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager) 39.4 94.8 0.0 |
%Busy CPU代表中DB使用CPU占总CPU使用的比例。
%Busy CPU=(%Total CPU/%Used CPU)*100
在11G之前的版本中，没有直接统计%Total CPU,我们需要去计算。
|
%Total CPU=(((DB CPU + background cpu time)*100)/(BUSY TIME+IDLE TIME))*100||’%’ %Used CPU=(BUSY TIME/BUSY TIME+IDLE TIME)*100 ||’%’ |
所以10G中的%Busy CPU为
|
((DB CPU+background cpu time)*100)/BUSY_TIME)*100||’%’ |
下面根据那位兄弟的AWR来计算一下
需要的数据查询
|
|
![clip_image001[4]](http://www.htz.pw/wp-content/uploads/2014/09/clip_image0014.png "clip_image001[4]")
![clip_image002[4]](http://www.htz.pw/wp-content/uploads/2014/09/clip_image0024.png "clip_image002[4]")
![clip_image003[4]](http://www.htz.pw/wp-content/uploads/2014/09/clip_image0034.png "clip_image003[4]")
![clip_image004[4]](http://www.htz.pw/wp-content/uploads/2014/09/clip_image0044.png "clip_image004[4]"){kind=small}
11G中计算方法
|
%Busy CPU=((39.4)/(100-58.38))*100||’100′ www.htz.pw > select round(((39.4)/(100-58.38))*100,2)||’%’ as "%Busy CPU" from dual;
%Busy —— 94.67% 跟94.8%差不多 |
10G中的计算方法
|
%Busy CPU=((44056.77+1010.35)*100/4755234)*100 www.htz.pw > select round(((44056.77+1010.35)*100/4755234)*100,2)||’%’ as "%Busy CPU" from dual;
%Busy —— 94.77% |
AWR中的%Busy CPU计算：等您坐沙发呢！