摘要
Oracle数据库是当前应用最广泛的大型关系数据库之一,其性能直接关系到整个应用系统的运行效率。介绍了Oracle 10g数据库系统性能优化与调整的原则、影响系统性能的因素,讨论了数据库配置优化问题,包括SGA、PGA的优化、磁盘I/O优化以及磁盘碎片的调整等问题,最后介绍了Oracle 10g提供的几种用于系统性能优化与调整的工具。
Oracle is the most widely used large- scale relational database, and its performance concerns the operational efficiency of the ap-plieation system directly. At first, introduces the basic principles and elements of performance optimizing of Oracle 10g database, system. Then discusses the optimizing of database configuration in detail, including the optimizing of SGA and PGA ,optimizing of disk input andoutput, and the tuning of disk segment. At last, several tools of performance optimizing and tuning are introduced in Oracle 10g database.
出处
《计算机技术与发展》
2009年第2期83-86,共4页
Computer Technology and Development
关键词
性能优化与调整
内存优化
磁盘I/O
磁盘碎片
performance optimizing and tuning
memory optimizing
disc input and output
disc scgment
