解析Oracle内存结构及内存性能诊断与调优

The Analysis on Diagnosis and Optimization of Oracle Memory Structure and its Performance

内存结构是Oracle数据库体系结构中最重要的部分之一,它是影响数据库性能的重要因素,服务器内存的大小直接影响数据库的运行速度。Oracle系统使用的内存结构可以分为系统全局区(SGA)、程序全局区(PGA),对这两类内存结构进行解析,并提供了诊断缓冲区设置合理与否的机制,从而实现对Oracle内存结构的优化。

Memory structure is one of the most important parts in Oracle database architecture, and it also exerts a great influence on database performance. The EMS memory size of the server directly influences its speed of service. Memory structure in Oracle system can be divided into SGA and PGA. The paper focuses on them and puts forward a mechanism, according to which a reasonable buffer installation is diagnosed so as to optimize structure of Oracle memory structure.