• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6095
  • Last Modified:

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

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?
0
chundi_gus
Asked:
chundi_gus
2 Solutions
 
sujit_kumarCommented:
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.
0
 
schwertnerCommented:
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.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now