Disk space check
Job details
| Name: | Disk space check |
| Platform: | Oracle |
| Category: | Capacity |
| Description: | Disk space check requiring java support database. (Supports Linux, Solaris, AIX, HPUX and Windows). |
| Long description: | Task checks disk space. This requires java support in the database and supports Linux, Solaris, AIX, HPUX and Windows. This check will react with a warning or an alarm only when BOTH warning pct AND warning mb is reached. |
| Version: | 5.92 |
| Default schedule: | 10 5,17 * * |
| Requires engine install: | Yes |
| Compatibility tag: | .[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & _priv_enable_java = ‘1′] |
Parameters
| Name | Default value | Description |
|---|---|---|
| Delete statistics older than (days) | 365 | Delete old statistics. Parameter value in days. |
| Warning pct | 80 | Percent used disk that will generate warning |
| Alarm pct | 95 | Percent used disk that will generate alarm |
| Warning MB | 1000 | MB free disk that will generate warning |
| Alarm MB | 200 | MB free disk that will generate alarm |
| Ignore mountpoints | Mountpoints you want to ignore. Comma separated. Examples: /boot, /mnt or C:\,D:\ |
Job Summary
- Purpose: The job checks the disk space utilization on database servers to ensure that there is adequate free space available, avoiding system crashes or performance degradation due to insufficient disk space.
- Why: Monitoring disk space is critical in managing database health, as reaching high space utilization could lead to significant issues like database operations being halted. The job triggers warnings and alarms when specified thresholds are reached, allowing proactive management.
- Manual Checking: Disk space usage can be manually checked through direct server access using commands specific to each operating system (e.g., “df” command on Linux).
Description
- A comprehensive task for monitoring disk space on various platforms including Linux, Solaris, AIX, HPUX, and Windows.
- It requires Java support in the database for executing certain operations.
- The task responds with either a warning or an alarm when preset thresholds for percentage use and free space in megabytes are simultaneously reached.
Operation Details
- The job involves checking mounted file systems, ignoring specified mount points as needed.
- Details of each file system like used space, available space, and usage percentage are collected and logged.
- Alarms or warnings are generated based on two parameters: percentage of the used disk and the actual free space remaining in megabytes.
Thresholds and Responses
| Threshold Type | Percentage | Free Space (MB) |
|---|---|---|
| Warning | 80% | 1000 MB |
| Alarm | 95% | 200 MB |
- Both conditions (percentage and available space) must be met for a warning or alarm to be triggered.
Notifications
- Notifications (warnings and alarms) include detailed information such as the mount point, free space left, and the usage percentage at the time of the report.
- This assists in identifying which specific volumes are nearing capacity thresholds and require attention.
Dependencies and Compatibility
- The job is designed to work on Oracle database instances that support Java inside the database.
- Several underlying procedures and checks are implemented to obtain disk information across supported operating systems by respective customized procedures (e.g., DBW_LINUX_DISKINFO).
Reporting and History
- Reports are generated to display current disk space usage and historical disk usage trends.
- Historical data is retained in a database table with provisions to delete data older than a set number of days (default 365 days) to manage space efficiently.
Enhancements and Customization
- Administrators can adapt the thresholds to better fit the operational requirements or specific configurations of their database environment.
- The job allows ignoring certain mount points to focus monitoring on relevant or critical volumes.
By continuously monitoring disk space and providing early warnings and alarms, this job ensures that adequate disk space is maintained, supporting stable and efficient database operations.