Using High Availability Monitors (June 2003)

Monitoring Database Resources
Database Monitor Reference
Chapter 366
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)