EXA_MONITOR_LAST_DAY
This system table describes monitoring information (the maximum values in the cluster). All users have access to the table.
The data ratios don't indicate the hardware performance. They are introduced to improve the comparability in case of variations of the measure intervals. If you multiply the ratio with the last interval duration, you get the real data volumes.
Column Name | Description |
---|---|
MEASURE_TIME | Timestamp of the measurement |
LOAD | System load (equals the load value of program up time) |
CPU | CPU utilization in percentage (of the database instance, averaged over the last measure interval) |
TEMP_DB_RAM | Usage of temporary DB memory in MiB (of the database instance, maximum over the last measure interval) |
PERSISTENT_DB_RAM | Usage of modified, persistent DB memory in MiB (of the database instance, maximum over the last measure interval) |
HDD_READ | Hard disk read ratio in MiB per second (per node, averaged over the last measure interval) |
HDD_WRITE | Hard disk write ratio in MiB per second (per node, averaged over the last measure interval) |
NET | Network traffic ratio in MiB per second (sum of send/receive, per node, averaged over the last measure interval) |
SWAP | Swap ratio in MiB per second (averaged over the last measure interval). If this value is higher than 0, a system configuration problem may exist. |