Pages

Tuesday, June 13, 2023

ORA-00379 no free buffers available in buffer pool for block size 16k

Error :ORA-00379 no free buffers available in buffer pool for block size 16k 

General
There has been no memory allocated to 8K or 16K or 32K block buffers cache. 
Explicitly allocating memory to the non-default block buffers will resolve the ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K or 16K or 32K errors

To see current status:

COL name FOR A30
COL value FOR A30
SELECT name, value 
  FROM V$PARAMETER 
 WHERE name LIKE '%cache_size';

To resolve the issue:
set DB_nK_CACHE_SIZE to a certain value and restart the instance
( Replace the n with the failing block size 8K or 16K or 32K as appropriate )

For example:

ALTER SYSTEM SET  DB_16K_CACHE_SIZE=100M SCOPE = SPFILE;

Restart the instance.


No comments:

Post a Comment