查询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
- 查询dba_data_files遇到ORA-00379: no free buffers available in buffer pool DEFAULT for block size 2K
- there is no default constructor available in ...
- WSAENOBUFS: No buffer space available in SAP
- Default buffer size used in BufferedReader constructor. It would be better to be explicit if an 8k-c
- Exception in BPOfferService for Block pool BP
- No buffer space available
- No buffer space available
- no buffer space available
- There is no default constructor available in xxx错误引发
- ORA-00349: failure obtaining block size for '+fra_grp01_d
- no appropriate default constructor available
- no appropriate default constructor available
- 偶遇No buffer space available
- default/keep/recycle buffer pool 的区别
- innodb buffer pool管理--free list
- Buffer Pool Extension For 2014
- weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool JDBC D
- Error 130010: Resource pool ‘' asked for a dynamic IP but there were no more available
- iOS UIAppearance使用详解
- Objective-C 编码建议
- OC中的加密算法
- Json数据解析
- C# 用委托BeginInvoke做异步线程
- 查询dba_data_files遇到ORA-00379: no free buffers available in buffer pool DEFAULT for block size 2K
- 关于textview 内textkit 的使用
- SQL Server的查询优化器详解
- 好久没写博客了
- Unity ShaderLab学习总结
- 代码注入技术
- 提高iOS性能的建议和技巧
- PhpStorm配置Xdebug
- 使用Maven插件生成MyBatis代码