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>
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K
最新推荐文章于 2022-02-21 17:55:01 发布