Oracle9i数据库的性能优化方法  

The Optimized Method of Oracle9i Database Performance

作　　者：陈迪[1] 陈琴[1] 

机构地区：[1]广西大学计算机与电子信息学院,广西南宁530004

出　　处：《广西科学院学报》2005年第S1期109-111,共3页Journal of Guangxi Academy of Sciences

摘　　要：介绍数据库性能优化的基本原则,并从设计阶段和运行阶段论述了O racle9 i数据库性能优化的方法,结合实例,给出O racle9 i数据库对系统全局区、磁盘输入输出和SQL语句的优化过程。O racle9 i数据库优化前后的效果比较表明,优化后的查询效率和CPU占用率明显改善,SQL语句执行时间减少。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.

关 键 词：数据库 性能优化 ORACLE9I CACHE命中率 SQL语句 

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