• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6557
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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