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