Database Reference
In-Depth Information
Things to Remember Before Moving Ahead
1)
Collection of Statistics Using AWR (Automatic Workload
Repository).
2)
Identifying the Problematic areas using ADDM.
3)
Advisor Central page of Oracle EM Database Control
as shown in Figure 11-3.
4)
Oracle has a built-in performance alerts mechanism
relating to tablespace usage, recovery area low in free
space, snapshot too told etc. Whenever an alert is
generated it appears in the Alerts section of EM
Database Control Home page as shown in Figure 11-23.
5)
Understanding of Oracle Active Session History (ASH).
Although the topic ends here but the Oracle story has just begun!
