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

 

posted @ 2013-06-15 15:38  爱生活,爱编程  阅读(149)  评论(0编辑  收藏  举报