| isAlive |
Checks if the connection
to the server instance can be established |
| user_cpu |
Total
user CPU time used by all user threads expressed
in seconds |
| system_cpu |
Total system CPU time used by all
user threads expressed in seconds |
| perc_phys_log_used |
Percentage of used physical log |
| user_session_count |
Number of users connected to the
server |
| buffer_wait_ratio |
Buffer wait ratio (buffwts/(pagreads+bufwrites))*100 |
| bufreads_writes_ratio |
Buffered reads to buffered writes
ratio (bufreads/bufwrites) |
| rollback_commits_ratio |
Rollback to commit ratio (isrollbacks/iscommits) |
| isam_seqscan_ratio |
ISAM total to sequential scan ration
(isamtot/seqscans/) |
| perc_cached_read |
Read cache percentage (100*(bufreads-dskreads)/bufreads) |
| perc_cached_write |
Write cache percentage (100*(bufwrites-dskwrites)/dskwrites) |
| dskreads |
Number of actual reads from disk |
| pagreads |
Number of pages read |
| bufreads |
Number of reads from shared memory |
| dskwrites |
Number of actual physical writes to
disk. It includes the writes for the physical and
logical logs. |
| pagwrites |
Number of pages written. |
| bufwrites |
Number of writes to the shared
memory buffers |
| isamtot |
Total number of ISAM calls made |
| isopens |
Number of times a tablespace is
opened |
| isstarts |
Number of times an index position
was changed |
| isreads |
Number of times the ISAM read
function is called |
| iswrites |
Number of times the ISAM write
function is called |
| isrewrites |
Number of times the ISAM update
function is called |
| isdeletes |
Number of times the ISAM delete
function is called |
| iscommits |
Number of times the ISAM iscommit()
function was called |
| isrollbacks |
Number of times transactions rolled
back |
| ovlock |
Number of times the database server
attempted to exceed the maximum number of locks
(specified as LOCKS in the ONCONFIG file) |
| ovuser |
Number of times that a user
attempted to exceed the maximum number of user
threads |
| ovtrans |
Overflow
transaction table |
| latchwts |
Increments when a thread waits to
gain access to a shared-memory resource |
| buffwts |
Number of times user threads have to
wait for a buffer |
| lockreqs |
Number of total requests for locks |
| lockwts |
Number of times user threads wait to
aquire a lock |
| lktouts |
Number
of deadlock timeouts |
| deadlks |
Number of times that deadlocks were
detected and cured |
| ckptwts |
Number
of times checkpoint waits |
| chunkwrites |
Writes
during a checkpoint |
| plgpagewrites |
Physical-log
pages written |
| plgwrites |
Physical-log
writes |
| llgrecs |
Logical-log
records |
| llgpagewrites |
Logical-log
pages written |
| llgwrites |
Logical-log
writes |
| flushes |
Number
of times that the buffer pool has been flushed to
the disk |
| compress |
Number of pages compressions |
| seqscans |
Number of sequential scans executed |
| totalsorts |
Total
number of sorts |
| memsorts |
Number
of memory sorts (sorts that fit in memory) |
| disksorts |
Number
of disk sorts (sorts that did not fit in memory) |
| maxsortspace |
Maximum disk space used by a sort |
| lruwrites |
Least-recently
used (LRU) writes |
| btradata |
Data
pages read ahead though leaf |
| btraidx |
Leaf
read ahead though leaf |
| dpra |
Data-page
read aheads |
| rapgs_used |
Read-ahead
pages used |
