These reports contain information about the usage of the available capacity of the selected database. These reports therefore give you information about the capacity that is still free, for example, in the usage of different memory, or of the available CPUs. Host-specific reports relate exclusively to the database host, and not to all hosts on which there are instances of the system of the selected database. In the context of interactive reporting, the following reports give you a quick overview of the development of these metrics over time:
Database Usage (
)The report shows the size and growth of the chosen database; for the database size, the following metrics are output in gigabytes:
Database memory used
Free memory in the database
Memory available to the database in the file system
Note
For the metrics mentioned, the last reported value of the respective time period is output in each case.
Log Area Usage (
)The report shows the load and remaining free memory space in the log memory, that is, the memory space that is used for logs in the database. The corresponding sizes are output in gigabytes.
CPU (
)The report shows the CPU load of the selected database host. The value relates to the general CPU load of the host, not to the CPU load due to the database itself. For mor information about these values, seeOperating System Monitor, in which these performance values are described in the context of the Alert Monitor. It shows how intensively the CPU is used, and how much processing capacity is still available.
The report shows two metrics per system — the mean and maximum CPU load in the specified period.
In the detail view, a time profile that shows the distribution of the CPU load by time of day, is also shown.
File System (
)The report shows the mean load of all file systems of the above host, as a percentage. The detail view shows the mean file system load as a percentage, and the free memory in megabytes, for the ten file systems with the highest load.
You can also filter by file systems. These performance values are described in the alert monitor under File Systems Monitor.
Main Memory (
)The report shows the metrics relating to the size and load of the main memory of the database host. The value relates to the general main memory load of the host, not to the load due to the database itself. For mor information about these values, seeOperating System Monitor, in which these performance values are described in the context of the Alert Monitor.
The detail view shows the absolute values of the total available and free memory, in megabytes, as well as the main memory load in percent.
Paging Rate (
)The report shows the page-out and page-in rate in kilobytes per second. You can restrict the display to just one of these processes, in the Detail view.
Main memory usage and paging, together, indicate whether the main memory size is sufficient for the host load. For further information about these values, see Operating System Monitor.
Note
For information about how you can specify the desired databases and the time interval to be displayed, and how to call interactive reporting, see Using Interactive Reporting.
For information about the different display options for the reports for databases with regard to metrics and threshold values, see Interactive Reports for Databases.