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

* 博客文章部分截图及内容来自于学习的书本及相应培训课程以及网络其他博客，仅做学习讨论之用，不做商业用途。
* 如有侵权，马上联系我，我立马删除对应链接。
* @author Alan
* @Email no008@foxmail.com

  1 SYS@orcl> select  TABLESPACE_NAME ,AUTOEXTENSIBLE from dba_data_files ;
  2 ERROR:
  3 ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K
  4 
  5 
  6 
  7 no rows selected
  8 
  9 SYS@orcl> show parameter db_16k_cache_size
 10 
 11 NAME                                 TYPE        VALUE
 12 ------------------------------------ ----------- ------------------------------
 13 db_16k_cache_size                    big integer 0
 14 SYS@orcl> alter system set db_16k_cache_size=10m;
 15 
 16 System altered.
 17 
 18 SYS@orcl> select  TABLESPACE_NAME ,AUTOEXTENSIBLE from dba_data_files ;
 19 
 20 TABLESPACE_NAME                AUT
 21 ------------------------------ ---
 22 USERS                          YES
 23 UNDOTBS1                       YES
 24 SYSAUX                         YES
 25 SYSTEM                         YES
 26 EXAMPLE                        YES
 27 TBS_TEST1                      NO
 28 TBS_TEST_3                     YES
 29 TBS_TEST4                      NO
 30 TBS_TEST5                      YES
 31 TBS_BIG_1                      NO
 32 TS_1                           NO
 33 
 34 TABLESPACE_NAME                AUT
 35 ------------------------------ ---
 36 TS_2                           NO
 37 TBSP_1                         YES
 38 COMPRESS_01                    NO
 39 COMPRESS_02                    NO
 40 TEST                           NO
 41 TEST2                          YES
 42 
 43 17 rows selected.
 44 
 45 SYS@orcl>