摘要
ORACLE系统结构复杂,性能受多方面因素影响,性能的调整是一项系统工程。文章从ORACLE的系统结构着手,对数据库优化自由结构OFA、数据库系统全局区SGA、规范化与反规范、数据库碎片、回滚段、索引、SQL语句等几方面性能需求给出了优化策略。
The ORACLE has a complex architecture. Many reasons can affect the performance of the system and tuning the ORACLE is a systemetic engineering. Basde on the system structure, the article propses several aspects of function adjustment of optimal strategy for database optimal flexible Architecture, database system global area, standardization and non - standardization, database fragment, rollback segment, index and SQL statement.
出处
《安阳工学院学报》
2006年第3期40-44,共5页
Journal of Anyang Institute of Technology
关键词
ORACLE数据库
优化设计
优化自由结构
系统全局区
规范化与反规范
数据库碎片
回滚段
索引
ORACLE database
optimization design
optimal flexible architecture
system global area
standardization and non- standardization
database fragment
rollback segment
index
