AWR报告
监控提示总体缓冲区命中率只有76%，但是AWR报告里显示命中率是正常的。不知道从哪里入手，请飞总指点！另外在数据库中查询到有两个指标很低，不知道有没有影响
1、Parse CPU to Pares Elapsed
SQL> select round((1 - cpu.value/total.value)*100,2) "Ratio"2from v$sysstat cpu,v$sysstat total3where cpu.name ='parse time cpu'4and total.name ='parse time elapsed';
Ratio---------- 2.95
2、Non-Parse CPUSQL> select round((1 - parse.value/total.value)*100,2) "Non-Parse CPU Ratio"2from v$sysstat parse,v$sysstat total3where parse.name ='parse time cpu'4and total.name ='CPU used by this session';
Non-Parse CPU Ratio------------------- 81.33
页:
[1]