在Oracle数据库设计中长期受到设计人员重视的是如何更好更快地提高Oracle数据库性能的问题。其中对数据库表现有较大关联的是两个因素,一是执行SQL语句的速度问题;二是数据库的内存配置管理问题。通过优化SQL语句效率、扩充高级缓冲区和配置重做日志缓冲区等几个方面介绍了Oracle数据库优化方法 ,探讨了Oracle如何提高性能优化的措施。通过测试Oracle查询结果表明,经过优化后的Oracle数据库缩短了响应时间,同时内存的使用效率也有了较大提升。
The problem of Oracle database’s performance optimization has been the focal point which the decision-maker and the technician show solicitude for commonly, and two key factors affecting the database’s performance are that low efficiency of the SQL query sentence and management of Oracleˊs memory. Several kinds of common Oracle database’s performance optimization techniques were elaborated, such as database design’s optimization, the adjustment of various dynamic parameters of database, and the SQL sentence query optimization was discussed emphatically. Judging from the results of query optimization test, the system’s response time reduces obviously and the system’s operation efficiency obtains the promotion.