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>