摘要
讨论了麒麟操作系统上Oracle数据库系统性能优化与调整技术,以TPC-C测试程序作为手段,对不同的内存分配、数据库进程结构、物理数据库设计、等待事件的观测与处理方法进行了分析。实验结果表明,采用合理的性能优化措施,可以将Oracle数据库系统的性能至少提高50%。
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.
出处
《计算机工程》
EI
CAS
CSCD
北大核心
2006年第19期82-84,87,共4页
Computer Engineering
