Oracle Tips by Burleson

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

Monitoring RAC with Grid Control

Let us select the Wait by Session Metrics group (which is in fact at the bottom of the Metrics Screen. Now you are presented with the next screen:

Figure 9.11: List of the selected metrics 

When you click on Average Instance CPU (%), you would see a graphical representation of the CPU activity as shown in Fig 9.12

Figure 9.12: Graphical Representation of average CPU activity

Another Interesting Metrics to study is the “throughput”. It has many items to display and some of them are shown in Figure 9.13:

Figure 9.13: List of items under the throughput category

 Let us pick the item ‘redo generated (per second)’ as an example. The next screen shows the redo-generation rate for last 24 hours period (as shown in Figure 9.14).

Figure 9.14: Redo Generation – shown for last 24 hours

 In another example, let us check if the instance is doing heavy check pointing; check out the next screen, which shows the DB writer activity (Fig 9.15):

Figure 9.15: Graphical Representation of average CPU activity