| 摘要: |
| 介绍数据库性能优化的基本原则,并从设计阶段和运行阶段论述了Oracle9i数据库性能优化的方法,结合实例,给出Oracle9i数据库对系统全局区、磁盘输入输出和SQL语句的优化过程。Oracle9i数据库优化前后的效果比较表明,优化后的查询效率和CPU占用率明显改善,SQL语句执行时间减少。 |
| 关键词: 数据库 性能优化 Oracle9i Cache命中率 SQL语句 |
| DOI： |
| 投稿时间：2005-09-11 |
| 基金项目: |
|
| The Optimized Method of Oracle9i Database Performance |
|
Chen Di, Chen Qin
|
| (School of Comp., Elec. and Info., Guangxi Univ., Nanning, Guangxi, 530004, China) |
| 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. |
| Key words: database performance optimizing Oracle9i cache hits ratio SQL statement |
