Using High Availability Monitors (June 2007)

Monitoring Database Resources
Database Monitor Reference
Chapter 3 69
1. The Oracle implementation supports only UP and DOWN.
The minimum polling interval for all database server resources is 30
seconds. You may want a longer interval, especially if system
performance is affected.
usage a floating-point number
expressed as a percentage
a value of 100 indicates
that all available
connections are active
a value of -1 indicates
that the number of
connections is unlimited
This resource class
describes the percentage of
maximum allowed
connections to the database
server currently in use.
write_
cache_
hit_rate
a floating-point number,
expressed as a percentage
a value of 100 would
imply that all writes are
from the cache; in other
words, the closer to 100,
the better the
performance
a value of -1 implies that
no logical writes have
occurred
This resource class
describes the ratio of logical
writes less physical writes
to logical writes, done by the
database server:
this is a measure of the
effectiveness of the write
cache.
Table 3-2 Interpreting Server Resource Classes (Continued)
Resource Name: /rdbms/server/resource_class/server_name
resource
_
class
Condition Description
(logical_writes) - (physical_writes
)
(logical_writes)