▶ (1)性能优化概览与方法论
▶ (2)统计数据和等待事件
▶ (3)指标、预警和基准
▶ (4)使用Statspack,AWR,ADDM,了解其功能和原理
▶ (5)自动收集优化统计信息
▶ (6)熟悉各种与优化相关的建议器(如,SQL Tuning Advisor,SQL Access Advisor)
▶ (7)优化共享池
▶ (8)创建和管理资源组
▶ (9)优化缓冲区高速缓存
▶ (10)自动共享内存管理
▶ (11)检查点和重做日志优化
▶ (12)优化I/O
▶ (13)优化PGA和临时空间
▶ (14)优化块空间的使用量
▶ (15)使用SQL Performance Analyzer
▶ (16)配置SQL Plan Management
▶ (17)使用DB Replay
▶ (18)使用result cache功能
▶ (19)使用Resource Manager
▶ (20)管理baseline template
▶ 工具软件:Oracle12c Database、AWR、Statspack、EM
上海速文Oracle授权培训中心