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.
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';
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.
Restart the instance.
No comments:
Post a Comment