CAJ | 학술논문

Oracle数据库是当前使用最为广泛的大型数据库之一。共享池存储数据库所运行的可执行程序代码和相关数据字典提供，是Oracle数据库体系中最复杂的内存组件之一。由于缺乏对共享池内部运行机制的了解，当数据库在运行过程中显示共享池中空闲空间较多，报ORA?4031错误提示共享池空间不足时，往往束手无策。通过导出Oracle数据库共享池的内存数据的方法，总结并分析共享池空间管理的内部管理机制，找到空闲空间较多而报ORA?4031错误的原因，给出了错误检测方法和相对应的解决方法。
Oracle수거고시당전사용최위엄범적대형수거고지일。공향지존저수거고소운행적가집행정서대마화상관수거자전제공，시Oracle수거고체계중최복잡적내존조건지일。유우결핍대공향지내부운행궤제적료해，당수거고재운행과정중현시공향지중공한공간교다，보ORA?4031착오제시공향지공간불족시，왕왕속수무책。통과도출Oracle수거고공향지적내존수거적방법，총결병분석공향지공간관리적내부관리궤제，조도공한공간교다이보ORA?4031착오적원인，급출료착오검측방법화상대응적해결방법。
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.