Home » RDBMS Server » Server Administration » ideal buffer cache hit ratio
ideal buffer cache hit ratio [message #369256] Wed, 26 July 2000 21:52 Go to next message
WCK
Messages: 4
Registered: July 2000
Junior Member
What is the ideal value for the buffer cache hit ratio 1-(physical reads/(db block gets + consistent gets))?

Thanks!
Re: ideal buffer cache hit ratio [message #369260 is a reply to message #369256] Thu, 27 July 2000 19:31 Go to previous message
Sam
Messages: 255
Registered: April 2000
Senior Member
It depends on your application....OLTP/DSS ? More than 99% is possible....more than 95 % is excellent...
rgds
sam
Previous Topic: Table Definition and Data problem
Next Topic: Re: resize redo log without shutting down instance ?
Goto Forum:
  


Current Time: Thu Oct 22 05:00:48 CDT 2020