查询dba_data_files遇到ORA-00379: no free buffers available in buffer pool DEFAULT for block size 2K

来源:互联网 发布:access数据库财务模板 编辑:程序博客网 时间:2024/06/10 15:19
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE    11.2.0.3.0      ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - Production查询此视图dba_data_files,报错ERROR at line 1:ORA-00379: no free buffers available in buffer pool DEFAULT for block size 2K


后来检查发现(select tablespace_name,block_size from dba_tablespaces;),有2k的表空间,于是设置2k表空间的cache:

alter system set db_2k_cache_size=10m;


然后就ok了。

 

 

0 0
原创粉丝点击