buffer cache free memory
i have oracle 8.1.6 running on tru64. server memory is 3 gb. we have 3 databases up and running. one database is giving an error
ORA-00379: no free buffers available in buffer pool DEFAULT.
Before changing the db_block_buffer, i would like to monitor the
buffer cache value. where can i see it?
What is the combined SGA size for the 3 instances?
Is it greater than 3 GB?
Each database SGA size is 700 mb.
FYI from metalink :
Each Oracle process may pin up to from 4 to db_block_buffers/processes number of buffers at any time. Minimally the parameters should satisfy db_block_buffers >= 4*processes in order to avoid the ORA-379 error.
[BUG:718337] TOO MANY BUFFER PINS LEADING TO ORA-379 ERROR
You can increase db_block_buffers marginally and reduce in other areas (shared pool , sort area size etc).
Or Buy additional memory from the HW vendor.
Click Here to Expand Forum to Full Width