-
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,
clio_usa
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.
-
Originally posted by shenru
Block buffer is used to store updated data blocks.
Well, the non-updated data blocks are also stored in the cache.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|