Author Login Editor-in-Chief Peer Review Editor Work Office Work

Computer Engineering ›› 2006, Vol. 32 ›› Issue (19): 82-84,8. doi: 10.3969/j.issn.1000-3428.2006.19.030

• Software Technology and Database • Previous Articles     Next Articles

Skill and Implementation for the Oracle Performance Tuning

GUO Haifeng1,2, YANG Guogui2   

  1. (1. Hunan Meteorological Science and Technology Development Center, Changsha 410007; 2. Institute of Software, College of Computer, National University of Defense Technology, Changsha 410073)
  • Received:1900-01-01 Revised:1900-01-01 Online:2006-10-05 Published:2006-10-05

Oracle数据库性能调优技术与实现

郭海峰1,2,阳国贵2   

  1. (1. 湖南省气象科技开发中心,长沙 410007;2. 国防科技大学计算机学院软件所,长沙 410073)

Abstract: This paper discusses the skill and implementation for the Oracle DBMS on the KYLIN OS, using TPC-C benchmark as the instrument, and it analyzes the memory’s distribution of the system, the structure of Oracle’s process, the physical design of the database, the observation and the treatment of the wait events. As the result of the experiment, the performance of Oracle database can be improved by 50% at least, by using reasonable tuning skill.

Key words: KYLIN OS, Performance tuning, TPC-C benchmark

摘要: 讨论了麒麟操作系统上Oracle数据库系统性能优化与调整技术,以TPC-C测试程序作为手段,对不同的内存分配、数据库进程结构、物理数据库设计、等待事件的观测与处理方法进行了分析。实验结果表明,采用合理的性能优化措施,可以将Oracle数据库系统的性能至少提高50%。

关键词: 麒麟操作系统, 性能优化, TPC-C测试

CLC Number: