现代电子技术Issue(4):69-72,4.
Oracle数据库共享池空间管理调优
Adjustment and optimization for shared pool space management of Oracle database
胡晨光 1徐楠楠1
作者信息
- 1. 北京电子科技职业学院,北京 100176
- 折叠
摘要
Abstract
Oracle database as the large database is widely used. The executable program code run by the shared pool memo⁃ry database and provided by the data dictionary is one of the most complicated components in Oracle Database system. Because the internal operating mechanism of shared pool is not understood,there is much free memory in shared pool when Oracle data⁃base is running,but ORA⁃4031 error is reported. The research dumps the shared pool information in memory. The internal oper⁃ating mechanism of shared pool space management is analyzed and summarized. The reasons of the ORA⁃4031 error were found. The detection method and solution for the ORA⁃4031 error are offered in this paper.关键词
共享池/空间管理/调优/Oracle数据库Key words
shared pool/space management/adjustment and optimization/Oracle database分类
信息技术与安全科学引用本文复制引用
胡晨光,徐楠楠..Oracle数据库共享池空间管理调优[J].现代电子技术,2015,(4):69-72,4.