Statspack 报告的分析经验
不需要通读、有重点地看、看以下 10 点:
① Load Profile
② Instance Efficiency Percentages
③ Top 5 Wait Events
④ SQL ordered by Gets
⑤ SQL ordered by Reads
⑥ Tablespace IO Stats
⑦ Enqueue activity
⑧ PGA Aggr Target Stats
⑨ Rollback Segment Stats
⑩ Latch
By David Lin
2013-06-14
Good Luck