Large DB buffer, low cache hit ratio

Hi, all,

The OS has 1G mem. SGA is about 700M, DB_BLOCK_BUFFERS is about 500M (133230*4K) in bytes. The size of whole database data files is less than 50G. So the DB_BLOCK_BUFFERS is more than 1% of the total database size. While the database buffer cache hit ratio only 24%. Please advice what happens here.

Thank you.

Helen

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 22 2001 - 16:11:37 CST