|
-
Hi
We have a database that had a Buffer Cache Hit Ratio of 24% average through the day.
The database has a block size of 8k
The DB_BLOCK_BUFFERS was set to 200
I changed this to 2000 and yet the buffer cache hit ratio has hardly improved. I have checked 'DBWR make free requests' from V$SYSSTAT and bfore the change this was 16000+ since the change it is now 0
Is this low hit ratio due to the fact that the DB may have few users connected. It is not a heavily used system
Cheers
Slaine
:p :p :p
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|