Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL 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了。