【摘要】 Oracle系统结构复杂,性能受多方面因素影响,性能的调整是一项系统工程,数据库管理员必须通过优化 措施保证数据库以最优的性能运行。本文从Oracle体系结构入手,结合实际应用的数据库讲解了优化策略的选取、 内存SGA优化、磁盘I/O优化、SQL语句优化等方面的技巧。更多还原

【Abstract】 The Oracle9i has a complex architecture. Many reasons can affect the performance of the system. Tuning the Oracle is a systems engineering. The database administrator must make sure the system is running optimized by every means. From the architecture of Oracle,an applied database is given to demonstrate the technique of choosing a performance tuning tactic, the SGA memory tuning technique, disk I/O tuning technique and SQL statement optimizing technique.更多还原