increase db_block_buffers in init.ora and check SQL-Statements with most
physical reads.

Regards

Volker Schön
E-Mail: mailto:v.[Email Address Removed] Nachricht-----
Von: Khan, Majid [mailto:majid.[Email Address Removed] Dienstag, 31. Juli 2001 14:42
An: LazyDBA.com Discussion
Betreff: my buffer cache hit ratio is 63.63? any recommendation?


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page