DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to deal ORA-00379,how to increase default pool size ?

  1. #1
    Join Date
    May 2002
    Posts
    34
    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 ?

  2. #2
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    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

  3. #3
    Join Date
    May 2002
    Posts
    35
    You can increase DB_BLOCK_BUFFERS value in initial file. Block buffer is used to store updated data blocks.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width