本文已被：浏览 2481次 下载 5245次
Received:July 19, 2009 Revised:August 21, 2009
Received:July 19, 2009 Revised:August 21, 2009
中文摘要: Oracle数据库是当前应用最广泛的大型数据库之一，其系统结构复杂，性能受多方面因素影响，其中SQL语句的执行效率是影响其性能的关键因素。以一个省级通信运营商的ORACLE ERP系统为例，从ORACLE数据库的SQL共享原理和SQL执行过程入手，指出合理配置数据库参数，提高SQL语句共享、提高数据缓存命中率是SQL语句性能提高的前提；并在此基础提出了SQL语句优化的四个原则。
Abstract:Oracle is one of the most widely-used large-scale databases at present. For its complex architecture, Oracle's performance is subjected to various factors, and query operation is one of the key factors. This paper analyzes the sharing principle and execution process of SQL statement in Oracle database. It finds out that improving the sharing of SQL statements and the data cache hit rate of the SQL statement is the premise of performance tuning. Lastly, it presents four principles for SQL performance tuning.
文章编号： 中图分类号： 文献标志码：
基金项目:
| Author Name | Affiliation |
| GUO Min | 山西财经大学 信息管理学院 山西 太原 030006 |
| Author Name | Affiliation |
| GUO Min | 山西财经大学 信息管理学院 山西 太原 030006 |
引用文本：
郭珉.ORACLE数据库SQL优化原则.计算机系统应用,2010,19(4):170-173
GUO Min.Optimization Principles of SQL in ORACLE Database.COMPUTER SYSTEMS APPLICATIONS,2010,19(4):170-173
郭珉.ORACLE数据库SQL优化原则.计算机系统应用,2010,19(4):170-173
GUO Min.Optimization Principles of SQL in ORACLE Database.COMPUTER SYSTEMS APPLICATIONS,2010,19(4):170-173
