My Oracle Support Banner

How to resolve ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K 16K or 32K errors (Doc ID 2619717.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

This note helps in how to use multiple cache size for tablespaces with different block size i.e DB_nK_CACHE_SIZE

Upgrade Gather Stats or running any SQL fails with ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K or 32K errors

SQL> exec dbms_stats.gather_table_stats('CORECAS','LOS_APP_APPLICATIONS',estimate_percent=>100, cascade=>true);
BEGIN dbms_stats.gather_table_stats('CORECAS','LOS_APP_APPLICATIONS',estimate_percent=>100, cascade=>true); END;

*
ERROR at line 1:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K
ORA-06512: at "SYS.DBMS_STATS", line 23938
ORA-06512: at "SYS.DBMS_STATS", line 23989
ORA-06512: at line 1

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.