| Low Hit Ratio Problem [message #53042] |
Mon, 26 August 2002 10:38  |
Venkat
Messages: 110
Registered: February 2001
|
Senior Member |
|
|
Hi Gurus,
Would any body through some idea on the causes of having a low buffer cache hit ratio.
any of the following could possibly be an issue?
1)Tables are truncated and reloaded frequently
2)New data is being loaded
3)We drop mass amounts of data, then rebuild every night.
Thanks,
Venkat
|
|
|
|
| Re: Low Hit Ratio Problem [message #53050 is a reply to message #53042] |
Mon, 26 August 2002 13:35  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
Of course your buffer cache could be too small. To get everything into the buffer cache it would have to be as big as the database itself which you obviously can't generally do. Also remember that full table scans don't leave their data in the buffer cache (else you'd fill it up too quickly).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
