发现数据库很慢,监控到如下信息:
SQL> select name,value from v$sysstat
2where name='free buffer inspected';
NAME
VALUE
---------------------------------------------------------------- ----------
free buffer inspected
5857145
SQL>
SQL> select event,total_waits
2from v$system_event
3where event in ('free buffer waits','buffer busy waits');
EVENT
TOTAL_WAITS
---------------------------------------------------------------- -----------
free buffer waits
2431
buffer busy waits
11813
但是db buffer的命中率还可以。
SQL> select 1-(phy.value/(cur.value+con.value))
2from v$sysstat cur,v$sysstat con,v$sysstat phy
3where cur.name='db block gets'
4and con.name='consistent gets'
5and phy.name='physical reads';
1-(PHY.VALUE/(CUR.VALUE+CON.VALUE))
-----------------------------------
.942779655
应该怎么办?
|