when I execute procedure ,later return the error
ORA-00379: no free buffers available in buffer pool DEFAULT
I did not configure keep or recycle pool, I konw all memory in db_block_buffers is for default pool ,How can I deal it ?
Increase the DB_BLOCK_BUFFERS parameter in init.ora file and restart your instance.
Make sure that you have at least DB_BLOCK_BUFFERS >= 4*PROCESSES in order to avoid ORA-00379 error. That is because each Oracle process can pin up to from 4 to DB_BLOCK_BUFFERS/PROCESSES number of buffers at any time.
Hope that helps,
OCP DBA 8/8i/9i
visit our Web Site
You can increase DB_BLOCK_BUFFERS value in initial file. Block buffer is used to store updated data blocks.
Well, the non-updated data blocks are also stored in the cache.
Originally posted by shenru
Block buffer is used to store updated data blocks.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
Click Here to Expand Forum to Full Width