All Databases

The Databases window shows information about the databases activity. 

The grid located at the top of the window shows each individual database with the following information for each one:

Name Database name
Processes number of active server processes connected to that database
Commits/s Number of transactions commited per second
Rollbacks/s Number od transactions rollbacked per second
Hit ratio (%) data cache hit ratio: percentage of time a required data block is found in the data cache
Disk reads (blocks) number of disk blocks read
Cache reads (blocks) number of blocks read from cache (i.e., block read requests avoided by finding the block already in buffer cache)
rows returned/s number of rows returned per second
rows inserted/s number of rows inserted per second
rows updated/s number of rows updated per second
rows deleted/s number of rows deleted per second

By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Update" button must be unchecked to be able to navigate through the collected snapshots.

Select one or more databases in the grid (Check box at the left of the grid) to update the graphes located at the bottom of the window. If several databases are selected, the statistics are aggregated.

Number of processes

number of active server processes connected to that database

Rows returned / sec

number of rows returned per second

Rows inserted/updated/deletes /sec

ins. number of rows inserted per second
upd. number of rows updated per second
del. number of rows deleted per second

Transactions /sec

Commits Number od transactions commited per second
Rollbacks Number od transactions rollbacked per second

Cache hit ratio

Percentage of time a required data block is found in the data cache

Block reads /sec

Disk number of disk blocks read per second
Cache number of blocks read from cache per second (i.e., block read requests avoided by finding the block already in buffer cache)

 

See also:

 





Go back to the Learning center:


Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap