hi dba's
my buffer hit ratio is 63.63 but my user hit ratio is about 99%
I need to tune my database is there any recommendation from you guys



SELECT Sum(DECODE(name, 'consistent gets', value, 0)) AS "consistent_gets",
Sum(DECODE(name, 'db block gets', value, 0)) AS "db_block_gets",
Sum(DECODE(name, 'physical reads', value, 0)) AS "physical_reads",
TO_CHAR(
(
Sum(DECODE(name, 'consistent gets', value, 0))
+ Sum(DECODE(name, 'db block gets', value, 0))
- Sum(DECODE(name, 'physical reads', value, 0))
)
/
(
Sum(DECODE(name, 'consistent gets', value, 0))
+ Sum(DECODE(name, 'db block gets', value, 0))
)
* 100, '99999999.99' ) AS "hit_ratio, %"
FROM v$sysstat;

--------------------------------------------------------------------------

consistent_gets db_block_gets physical_reads hit_ratio, %
--------------- ------------- -------------- ------------
15744863 783286 6011121 63.63
Oracle LazyDBA home page