Oracle数据库优化探究

Research on the Optimization of Oracle Database

Oracle是目前使用最为广泛的大型数据库管理系统,提高Oracle数据库系统的运行效率,是整个计算机信息系统高效运转的前提和保证。影响Oracle数据库应用系统性能的因素,既有软件方面的因素,也有数据运行的硬件环境、网络环境、数据库管理和维护方面的因素等。通过对其优化可以解决数据库系统运行过程中性能突降等问题,以保证系统运行的优良性能。以数据库性能优化的基本原则为基础,从5个方面总结了Oracle数据库的优化调整。

Oracle is currently the most widely used large-scale database management systems, oracle database systems to improve operat- ing efficiency, it is the computer information systems and efficient operation of the prerequisite and guarantee.there are many factors affect the performance of Oracle oatabase application system,both the software aspects,but also including data to run the hardware environ- ment, network environment, database management and maintenance of the factors, so the performance optimization is directly related to the whole system run more efficiently.In this paper,the basic principles of database performance optimization based on analysis of oracle＇s system structure and working mechanism, summarized in five aspects of the optimal adjustment of the oracle database.