| status1 | The values are: | This resource class describes the
state of the database server supporting the database instance. |
| UP | the database server is operational and available
for processing requests |
| DOWN | the database server is not available for processing requests |
| HALTED | the database server is temporarily unavailable
for administrative reasons |
| status1 | The values are: (continued) | This resource class describes the
state of the database server supporting the database instance. |
CON-
GESTED | the database server is not accepting requests
due to resource limitations |
RE-
STARTING | the database server was restarted and will
be available soon |
allowed_
max_
connects | an integer value from the database
server configuration
a value of zero (0) indicates that
the number of connections is unlimited | This resource class describes the maximum number
of simultaneous connections allowed by the database server. |
| commits | an integer | This resource class describes the number of
transactions that have been completed by the database server. |
commits_
per_sec | a floating-point number | This resource class describes the number of
transactions per second completed by the database server. |
| connects | an integer | This resource class describes the current number
of simultaneous connections to the database server. |
disk_
reads | an integer | This resource class describes the number
of disk reads on the database server since it started. |
disk_
reads_
per_sec | a floating-point number | This resource class describes the number
of disk reads per second on the database server |
disk_
writes | an integer | This resource class describes the number
of disk writes on the database server since it started. |
disk_
writes_
per_sec | a floating-point number | This resource class describes the number
of disk writes per second on the database server. |
logical_
reads | an integer | This resource class describes the number
of logical reads on the database server since it started. |
logical_
reads_
per_sec | a floating-point number | This resource class describes the number
of logical reads per second on the database server. |
logical_
writes | an integer | This resource class describes the number of
logical writes on the database server since it started. |
logical_
writes_
per_sec | a floating-point number | This resource class describes the number of
logical disk writes per second on the database server. |
peak_
connects | an integer
if
it keeps increasing over time, this could be an indication that
a configuration parameter needs to be increased | This resource class describes the greatest
number of simultaneous connections made to the database server since
the database server started. |
read_
cache_
hit_rate | a floating-point number, expressed
as a percentage
a value of 100 would imply that
all reads are from the cache; in other words, the closer to 100,
the better the performance
a value of -1 implies
that no logical reads have occurred | This resource class describes the ratio
of logical reads less physical reads to logical reads, done by the
database server: this
is a measure of the effectiveness of the read cache. |
| started | character numbers in the following
format (year, month, day, hour, minute, and second):
YYYY/MM/DD HH:MM:SS.S | This resource class describes date and time
when the database server was last started. |
| uptime | a floating-point value in seconds
a
value of minus one (-1) might indicate that the database server
started before the SNMP subagent | This resource class describes length of time
the database server has been running. |
| 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. |
Printable version
