This system table contains the monthly aggregated monitoring information (of values from EXA_MONITOR_LAST_DAY) for a cluster, sorted by the interval start and cluster name. 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 |
|---|---|
| CLUSTER_NAME | Name of the cluster |
| INTERVAL_START | Timestamp at the start of the aggregation interval |
| LOAD_AVG | Average system load (equals the 1-minute load value of program up time) |
| LOAD_MAX | Maximum system load (equals the 1-minute load value of program up time) |
| CPU_AVG | Average CPU utilization in percentage (of the database instance) |
| CPU_MAX | Maximum CPU utilization in percentage (of the database instance) |
| TEMP_DB_RAM_AVG | Average usage of temporary DB memory in MiB (of the database instance) |
| TEMP_DB_RAM_MAX | Maximum usage of temporary DB memory in MiB (of the database instance) |
| PERSISTENT_DB_RAM_AVG | Average usage of modified, persistent DB memory in MiB (of the database instance) |
| PERSISTENT_DB_RAM_MAX | Maximum usage of modified, persistent DB memory in MiB (of the database instance) |
| HDD_READ_AVG | Average hard disk read ratio in MiB per second |
| HDD_READ_MAX | Maximum hard disk read ratio in MiB per second |
| HDD_WRITE_AVG | Average hard disk write ratio in MiB per second |
| HDD_WRITE_MAX | Maximum hard disk write ratio in MiB per second |
| LOCAL_READ_SIZE_AVG | Average data size read from local (non-cache) storage in MiB |
| LOCAL_READ_SIZE_MAX | Maximum data size read from local (non-cache) storage in MiB |
| LOCAL_READ_DURATION_AVG | Average duration spent reading data from local (non-cache) storage in seconds |
| LOCAL_READ_DURATION_MAX | Maximum duration spent reading data from local (non-cache) storage in seconds |
| LOCAL_WRITE_SIZE_AVG | Average data size written to local (non-cache) storage in MiB |
| LOCAL_WRITE_SIZE_MAX | Maximum data size written to local (non-cache) storage in MiB |
| LOCAL_WRITE_DURATION_AVG | Average duration spent writing data to local (non-cache) storage in seconds |
| LOCAL_WRITE_DURATION_MAX | Maximum duration spent writing data to local (non-cache) storage in seconds |
| CACHE_READ_SIZE_AVG | Average data size read from cache in MiB |
| CACHE_READ_SIZE_MAX | Maximal data size read from cache in MiB |
| CACHE_READ_DURATION_AVG | Average duration spent reading data from cache in seconds |
| CACHE_READ_DURATION_MAX | Maximum duration spent reading data from cache in seconds |
| CACHE_WRITE_SIZE_AVG | Average data size written to cache in MiB |
| CACHE_WRITE_SIZE_MAX | Maximum data size written to cache in MiB |
| CACHE_WRITE_DURATION_AVG | Average duration spent writing data to cache in seconds |
| CACHE_WRITE_DURATION_MAX | Maximum duration spent writing data to cache in seconds |
| REMOTE_READ_SIZE_AVG | Average data size read from remote storage in MiB |
| REMOTE_READ_SIZE_MAX | Maximum data size read from remote storage in MiB |
| REMOTE_READ_DURATION_AVG | Average duration spent reading data from remote storage in seconds |
| REMOTE_READ_DURATION_MAX | Maximum duration spent reading data from remote storage in seconds |
| REMOTE_WRITE_SIZE_AVG | Average data size written to remote storage in MiB |
| REMOTE_WRITE_SIZE_MAX | Maximum data size written to remote storage in MiB |
| REMOTE_WRITE_DURATION_AVG | Average duration spent writing data to remote storage in seconds |
| REMOTE_WRITE_DURATION_MAX | Maximum duration spent writing data to remote storage in seconds |
| NET_AVG | Average network traffic ratio in MiB per second |
| NET_MAX | Maximum network traffic ratio in MiB per second |
| SWAP_AVG |
Average
swap ratio in MiB per
second.
If this value is higher than 0, a system configuration problem may exist. |
| SWAP_MAX |
Maximum swap ratio in MiB per
second.
If this value is higher than 0, a system configuration problem may exist. |
