引き続き AWR について。最近そんな仕事ばかり。
最初にみるのは
- Top 10 Foreground Events by Total Wait Time
== CPU 消費が高い場合 ==
- Host CPU
- Time Model Statistics
- DB CPU
background cpu time
parse time elapsed - SQL ordered by CPU Time
- SQL ordered by Parse Calls
== I/O の待機が高い場合 ==
- Load Profile
- IO Profile
- SQL ordered by User I/O Wait Time
- SQL ordered by Reads
- SQL ordered by Physical Reads (UnOptimized)
- File IO Stats (Tablespace IO Stats)
- Instance Efficiency Percentages (Target 100%)
Buffer Hit %: - Segments by Physical Reads
- Segments by Physical Read Requests
Segments by * は他にも複数あり、状況に応じて。
個人的には、以下はあまり見ません。
- IOStat by Function summary
- IOStat by Filetype summary
- IOStat by Function/Filetype summary
== 共有プール関連 ==
- Instance Efficiency Percentages (Target 100%)
Soft Parse %:
Latch Hit %: - Memory Statistics
- Shared Pool Statistic
- SQL ordered by Sharable Memory
- SQL ordered by Version Count
- Shared Pool Advisory
- Memory Dynamic Components
- Memory Resize Ops (Memory Resize Operations Summary)
- SGA breakdown difference
== GLOBAL CACHE 関連 ==
- Global Cache Load Profile
- SQL ordered by Cluster Wait Time
- Segments by Global Cache Buffer Busy
- Segments by CR Blocks Received
- Segments by Current Blocks Received
- Other Instance Activity Stats
gc blocks lost
他にもみるポイントはあるかもですが、どちらかというとみるべきポイントをしぼっていきたい。これいらないんじゃね?というものがあれば消していきたい。
実際にまわしてみてから、アップデート予定。