DB_BLOCK_BUFFERS

Using T.O.A.D. I found our database has a Buffer Cache Hit Rate of just udner 76%.
The advise is that the db_block_buffers may need to be increased.

Our db_block_size is 8K.
db_block_buffers is currently set to 4096

Any advise as to how to determine the optimal size for db_block_buffers ?

Thanx for any hints !

Greets,

Kirsten

--openmail-part-09ab92e0-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+IpJ9AQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAFgAAAFJFIDogREJfQkxP Q0tfQlVGRkVSUwDNBQEFgAMADgAAANAHCAAJAAoAAQANAAMAAwEBAIAAAKAAAAAEAKAAQgBO AEpvaG4gSi4gS2FuYWdhcmFqIC9GSUMzMjEsT1BFTk1BSUwvbz1CUlVORUkgU0hFTEwgUEVU Uk9MRVVNIFNFUklBAE9QRU5NQUlMOkpvaG4gSi4gS2FuYWdhcmFqIC9GSUMzMjEsT1BFTk1B SUwvbz1CUlVORUlcIFNIRUxMXCBQRVRST0xFVU1cIFNFUklBAAAAAAAAAAAAJyoBIIADAA4A AADQBwgACQAKAAAACwADAAABAQmAAQAhAAAAODQzNTVGMTk4MjZERDQxMTkzODQwMDYwOTc5 OTExQjMAzgYBBJAGAAQCAAABAAAAEgAAAAMAADACAAAACwAPDgAAAAACAf8PAQAAAEcAAAAA AAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQBvcmFjbGUtbEBmYXRjaXR5LmNvbQBTTVRQAG9yYWNs ZS1sQGZhdGNpdHkuY29tAAAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAAFQAAAG9yYWNs ZS1sQGZhdGNpdHkuY29tAAAAAAMAFQwBAAAAAgH5DwEAAABHAAAAAAAAAIErH6S+oxAZnW4A 3QEPVAIAAAEQb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUtbEBmYXRjaXR5LmNv bQAAAwD+DwYAAAAeAAEwAQAAABcAAAAnb3JhY2xlLWxAZmF0Y2l0eS5jb20nAAACAQswAQAA ABoAAABTTVRQOk9SQUNMRS1MQEZBVENJVFkuQ09NAAAAAwAAOQAAAAALAEA6AAAAAAMAcToA AAAAHgD2XwEAAAAVAAAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAAAAgH3XwEAAABHAAAAAAAA AIErH6S+oxAZnW4A3QEPVAIAAAEAb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUt bEBmYXRjaXR5LmNvbQAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALBbwEDkAYA FAQAACIAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkAAAAAAAMANgAAAAAAQAA5AFCM SbKlAcABHgBCAAEAAABCAAAASm9obiBKLiBLYW5hZ2FyYWogL0ZJQzMyMSxPUEVOTUFJTC9v PUJSVU5FSSBTSEVMTCBQRVRST0xFVU0gU0VSSUEAAABAAEgA0KbAtKUBwAEeAHAAAQAAABYA AABSRSA6IERCX0JMT0NLX0JVRkZFUlMAAAACAXEAAQAAABYAAAABwAGlskQZXzWGbYIR1JOE AGCXmRGzAAAeABoMAQAAAEIAAABKb2huIEouIEthbmFnYXJhaiAvRklDMzIxLE9QRU5NQUlM L289QlJVTkVJIFNIRUxMIFBFVFJPTEVVTSBTRVJJQQAAAAIBHQwBAAAATgAAAE9QRU5NQUlM OkpPSE4gSi4gS0FOQUdBUkFKIC9GSUMzMjEsT1BFTk1BSUwvTz1CUlVORUlcIFNIRUxMXCBQ RVRST0xFVU1cIFNFUklBAAAAHgAeDAEAAAAJAAAAT1BFTk1BSUwAAAAAHgAfDAEAAABFAAAA Sm9obiBKLiBLYW5hZ2FyYWogL0ZJQzMyMSxPUEVOTUFJTC9vPUJSVU5FSVwgU0hFTExcIFBF VFJPTEVVTVwgU0VSSUEAAAAAAwCAEP////9AAAcwMOEieKQBwAFAAAgwMAX4jKUBwAEDAN4/ r28AAAsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwACgAggBgAAAAAAwAAAAAAA AEYAAAAAEIUAAAAAAAADAAiACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAMAFoAIIAYA AAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAngAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAOMV AAAeACiACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA4LjUACwApgAggBgAAAAAA wAAAAAAAAEYAAAAABoUAAAAAAAALAC2ACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMA L4AIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgA9gAggBgAAAAAAwAAAAAAAAEYAAAAA NoUAAAEAAAABAAAAAAAAAB4APoAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAA AAAeAD+ACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwBKgAsgBgAAAAAA wAAAAAAAAEYAAAAAAIgAAAAAAAALAEyACyAGAAAAAADAAAAAAAAARgAAAAAFiAAAAAAAAB4A PQABAAAAAQAAAAAAAAADAA00/TcAAC+h Received on Mon Aug 07 2000 - 11:37:24 CDT