This Oracle 10g RAC
book is the best source for Oracle RAC monitoring scripts with
an immediate download of RAC monitoring scripts.
The following are a few general
guidelines for RAC monitoring:
The cluster interconnect network
should be tuned to get an optimal transfer rate and buffering.
RAC objects should be tuned for:
n
initrans.
n
Freelists.
n
Rows per block (pctfree).
n
Freelists and
init_trans should be
used whenever possible.
n
Larger shared pools should
be used rather than those used with normal Oracle, to allow for
the Global Directory.
n
Cache transfer speeds and
intra-instance pings should be monitored to determine latencies.
n
Holistic monitoring should
be performed at all times
Using these RAC monitoring guidelines, and
the scripts and techniques covered in this chapter, the RAC
environment can be made to perform optimally.
