ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K

Posted on 2005-04-11
Last Modified: 2012-05-05
We are hitting this error on one of our customers' production database. ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K. Need resolution asap, please help. I have set db_block_buffers=1300 going by the formula, db_block_buffers= (> 4*processes). Here, Processes = 300 and db_block_size=8192. I am not sure if that fixes it, got to wait and see. Last friday, I had to recreate init.ora file and spfile and restart the db since the customer support person accidentally edited the spfile and the db had failed to restart! After that everything was fine until we ran into this problem. Wondering if there is anything else I should take care of? Any ideas?
Question by:chundi_gus
    LVL 11

    Accepted Solution

    ORA-00379: no free buffers available in buffer pool string for block size stringK
    Cause: All buffers in the specified buffer pool for the specified block size are in use and no free buffers are available.
    Action: Increase the number of buffers in the specified pool for the specified block size.
    LVL 47

    Assisted Solution

    You have to increase the total size of SGA and the DB Buffer Cache (Pool) entry. After that recreate the DB8_8K_CACHE_SIZE parameter. The minimum value is 16M and this points that the measure units isn't blocks as in 8i. The unit is bytes.
    It seems you have missed this parameter in the old SPFILE.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now