Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 9 -Managing and Using Oracle Grid Control

Monitoring RAC with Grid Control

Figure 9.5: Grid Cluster Database Monitor Screen

As you can see this screen contains a great deal of information. Each underlined item provides drill down capability to more and more detailed information. Notice there is the Home, Performance and Targets subscreens available from this top level screen along with the usual Alert History, Blackouts (time when monitoring is specifically turned off) and Deployments screens.

 In another example, the Performance screen gives cluster specific performance metrics. The Performance Screen is shown in Figure 9.6 for the clustered database “MAIL” which is a 2-Node Cluster.

Figure 9.6: Cluster Database Top Level Performance Screen

 From the Cluster Performance Screen you can drill down into 4 additional performances related screens, which are shown below:

• Cluster Cache Coherency
   

• Top Sessions
   

• Database Locks
   

• Top Consumers
  
  The Top Sessions, Database Locks and Top Consumers pages are the standard Oracle Grid Control (Enterprise Manager) performance screens; the only one, which specifically deals with RAC is the Cluster Cache Coherency page, shown in Figure 9.7.