Operating-system tools
The database server relies on the operating system of the host computer to provide access to system resources such as the CPU, memory, and various unbuffered disk I/O interfaces and files. Each operating system has its own set of utilities for reporting how system resources are used.
Different implementations of some operating systems have monitoring utilities with the same name but different options and informational displays.
UNIX Only
The following table lists some UNIX utilities that monitor system resources.
| UNIX Utility | Description |
|---|---|
| vmstat utility | Displays virtual-memory statistics |
| iostat utility | Displays I/O utilization statistics |
| sar utility | Displays a variety of resource statistics |
| ps utility | Displays active process information |
For details on how to monitor your operating-system resources, consult the reference manual or your system administration guide.
To capture the status of system resources at regular intervals, use scheduling tools that are available with your host operating system (for example, cron) as part of your performance monitoring system.
Windows Only
You can often use the Performance Logs and Alerts that the Windows operating system supplies to monitor resources such as processor, memory, cache, threads, and processes. The Performance Logs and Alerts also provide charts, alerts, reports, and the ability to save information to log files for later analysis.
For more information about how to use the Performance Logs and Alerts, consult your operating-system manuals.