摘要： Oracle数据库是当前应用最广泛的大型数据库之一,而其性能优化直接关系到系统的正常运行效率。该文以数据库性能优化的基本 原则为出发点。阐述了在数据库设计阶段如何避免竞争和如何优化数据访问,在数据库运行阶段如何从操作系统和数据库实例级别上调整内 存和I/O来达到数据库性能优化的各种技术。

关键词: oracle数据库, 性能优化, 内存, I/O

Abstract: Oracle is the most widely used large-scale database at present,and its performance optimization concerns systematic operational efficiency directly. This paper starts with the basic principles of performance optimizing of databse, then presents some technology about optimizing database:how to avoid the competition and how to optimize the data access on database design phase;how to adjust memory and I/O from operating system and instance rank of the database in database run phase.

中图分类号: 

• TP311.13