摘要: 讨论了麒麟操作系统上Oracle数据库系统性能优化与调整技术,以TPC-C测试程序作为手段,对不同的内存分配、数据库进程结构、物理数据库设计、等待事件的观测与处理方法进行了分析。实验结果表明,采用合理的性能优化措施,可以将Oracle数据库系统的性能至少提高50%。
关键词:
麒麟操作系统,
性能优化,
TPC-C测试
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数据库性能调优技术与实现[J]. 计算机工程, 2006, 32(19): 82-84,8.
GUO Haifeng; YANG Guogui. Skill and Implementation for the Oracle Performance Tuning[J]. Computer Engineering, 2006, 32(19): 82-84,8.