Oracle9i Performance Tuning
Course Schedule
Day 1
Lesson 1: Overview of Oracle9i Performance Tuning Oracle9i优化纵览
Lesson 2: Diagnostic and Tuning Tools 诊断性能调整工具: Oracle Enterprise
Manager 和 Statspack
Lesson 3: Sizing the Shared Pool 制定Shared Pool大小
Lesson 4: Sizing the Buffer Cache 制定Buffer Cache大小
Day 2
Lesson 5: Sizing Other SGA Structures 制定SGA其他结构
大小
Lesson 6: Database Configuration and I/O Issues 数据库配置I/O
Lesson 7: Optimizing Sort Operations 优化Sort操作
Lesson 8: Diagnosing Contention for Latches 冲突诊断
Day 3
Lesson 9: Tuning Rollback Segments 回滚段调优
Lesson 10: Monitoring and Detecting Lock Contention 监控Lock Contention
Lesson 11: Tuning the Oracle Shared Server 调整Oracle共享服务器
Lesson 12: Application Tuning 优化应用
Day 4
Lesson 13: Using Oracle Blocks Efficiently 有效使用Oracle Blocks
Lesson 14: SQL Statement Tuning SQL语句优化
Lesson 15: Tuning the Operating System and 使用操作管理器
Using Resource Manager 优化操作系统
Lesson 16: Workshop Overview Workshop简介
Day 5
1. Alert 日志分析
2. 数据字典使用
3. 存储过程及其他 PL/SQL 对象介绍
4. Exp/imp 工具介绍
5. RMAN 备份及恢复
评论0