buffer cache free memory

[rammi65]

hi
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?

ramesh

[tamilselvan]

What is the combined SGA size for the 3 instances?
Is it greater than 3 GB?

Tamil

[rammi65]

Hi
Each database SGA size is 700 mb.

[Jr]

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

[tamilselvan]

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.

Tamil