OracleDBA手册文档信息:文档名称OracleDBA手册V0.1文档编号文档存放文档密级内部发行者技术总部发行日期2007-6-19文档变更记录:修订日期修订说明版本号修订人批准人2007-6-19创建V0.1林强、王凌洁2007-6-29评审V1.0杨疆湖、林强、汤成©上海SUNGARD金仕达计算机有限公司版权所有若非上海SUNGARD金仕达计算机有限公司授权,不得引用本文档或本文档中的任何部分前言......................................................................................................................................................30设计时优化...........................................................................................................................................30规划磁盘I/O........................................................................................................................................30监控表空间的I/O比例..............................................................................................................30监控文件系统的I/O比例...........................................................................................................30对数据量估计.......................................................................................................................................30部署时调优...........................................................................................................................................30系统参数调整...............................................................................................................................30调整DBWR写进程.............................................................................................................30调整Dml_locks....................................................................................................................30调整Open_cursors................................................................................................................30调整Data_links.....................................................................................................................30调整系统进程数Processes...................................................................................................30调整会话Sessions................................................................................................................30调整事务transactions...........................................................................................................30调整Job数量........................................................................................................................30调整读取数据最大块数.......................................................................................................30设置lock_sga:.......................................................................................................................30设置timed_statistics...........................................................................................................30调整最大回退段数...............................................................................................................30设置db_cache_advice:.........................................................................................................30调整优化模式optimizer_mode...........................................................................................30调整优化模式optimizer_index_caching.......