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>
上一篇:玩得一手好注入之order by排序篇


下一篇:170703、springboot编程之模板使用(thymeleaf、freemarker)