ORACLE数据库SQL优化原则  

Optimization Principles of SQL in ORACLE Database

作　　者：郭珉[1] 

机构地区：[1]山西财经大学信息管理学院,山西太原030006

出　　处：《计算机系统应用》2010年第4期170-173,165,共5页Computer Systems & Applications

摘　　要：Oracle数据库是当前应用最广泛的大型数据库之一,其系统结构复杂,性能受多方面因素影响,其中SQL语句的执行效率是影响其性能的关键因素。以一个省级通信运营商的ORACLE ERP系统为例,从ORACLE数据库的SQL共享原理和SQL执行过程入手,指出合理配置数据库参数,提高SQL语句共享、提高数据缓存命中率是SQL语句性能提高的前提;并在此基础提出了SQL语句优化的四个原则。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.

关 键 词：ORACLE数据库 SQL 性能优化 优化器 共享池 

分 类 号：TP311.138[自动化与计算机技术—计算机软件与理论]