| Oracle9i数据库的性能优化方法 |
| |
| 引用本文： | 陈迪,陈琴.Oracle9i数据库的性能优化方法[J].广西科学院学报,2005(Z1). |
| |
| 作者姓名： | 陈迪 陈琴 |
| |
| 作者单位： | 广西大学计算机与电子信息学院 广西大学计算机与电子信息学院 广西南宁 广西南宁 |
| |
| 摘 要： | 介绍数据库性能优化的基本原则,并从设计阶段和运行阶段论述了O racle9 i数据库性能优化的方法,结合实例,给出O racle9 i数据库对系统全局区、磁盘输入输出和SQL语句的优化过程。O racle9 i数据库优化前后的效果比较表明,优化后的查询效率和CPU占用率明显改善,SQL语句执行时间减少。
|
| 关 键 词： | 数据库 性能优化 Oracle9i Cache命中率 SQL语句 |
The Optimized Method of Oracle9i Database Performance |
| |
| Chen Di,Chen Qin.The Optimized Method of Oracle9i Database Performance[J].Journal of Guangxi Academy of Sciences,2005(Z1). |
| |
| Authors: | Chen Di Chen Qin |
| |
| Abstract: | This paper introduces the basic principle of database performance optimizing.And the optimized method of database performance in design stage and run stage is discussed.The optimized process of Oracle9i database to System Global Area,input/output of disk and SQL statement is given by an example.The result of before and after optimizing verifies that after optimizing the query efficiency and CPU-take-up rate are improved obviously and the time of carrying out SQL statement is reduced. |
| |
| Keywords: | database performance optimizing Oracle9i cache hits ratio SQL statement |
| 本文献已被 CNKI 维普 等数据库收录！ |
