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

  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>

转载于:https://www.cnblogs.com/ios9/p/9072362.html