浅析Oracle数据库的优化

Optimization of Oracle Database

使Oracle数据库保持优良性能,这是许多数据库管理员关心的问题。通过实践,这里提出了一种优化Oracle数据库的方法。Oracle中SQL语句的执行过程可分为解析(Parse)、执行(Execute)和提取结果(Fetch)三步,此方法就是通过对SQL语句在Oracle数据库中优化执行的三个过程来提高Oracle数据库的性能。

Maintain the excellent performance of the Oracle database, it is the concerns of many database administrators. Here, presented an optimization method of Oracle database. SQL statement execution in the Oracle can be divided into analytic （Parse）, Executive （Execute） and extracting results （Fetch） three steps. This method is through the Oracle database on the SQL statements to optimize the implementation of the three processes to improve Oracle database performance.