AWR Report Detailed Analysis AWR报告细节分析

Maclean Liu(刘相兵

Ault_AWR.pdf (554.93 KB, 下载次数: 614, 售价: 2 金钱)

2011-12-16 22:05 上传

点击文件名下载附件
售价: 2 金钱  [记录]

Top-Down Approach
Report starts with settings overview
Next provides Top-5 waits
Use the Waits to guide further investigation


Know Your Load Type!
Online Transaction Processing
Few reads
Many writes
Many small transactions
Look for redo/undo and sequential read issues
Decision Support/Data Warehouse
Many reads
Few writes (other then possible temp)
Few transactions
Look for sort/workareaand scattered read issues
Mixed or Hybrid

Maclean Liu(刘相兵

可以正常 下载和 打开， 检查自己的浏览器