Use this Knowledge Script to monitor the amount of disk space available for the archive log file, the background process log file, and user log files for a database. You can monitor the space available for all three, or for any combination of the three. For example, you could turn off monitoring for the archive log and background process log files and monitor just the disk space available for the user logs.
You can set a minimum threshold for each type of log file. If the amount of available disk space falls below any threshold, the job raises an event.
This Knowledge Script supports Automatic Storage Management (ASM).
The account you use to run this script must have SELECT permissions for the following tables:
V_$ARCHIVE_DEST
V_$PARAMETER
V_$VERSION
Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and monitors only that database.
The default interval for this script is Every hour.
Set the following parameters as needed:
|
Description |
How to Set It |
|---|---|
|
Oracle Username |
Enter the username that this script needs to access the target databases. If you run this script on more than one database, configure each database with the same username. To use SYSDBA authentication, leave this parameter blank. The default is blank. |
|
Collect data for available disk space? |
Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the amount of free disk space for each type of log file that you are monitoring. The default is unselected. |
|
Monitor space available for the archive log? |
Select Yes to monitor the amount of disk space available for the archive log file of the database. The default is Yes. |
|
Ignore unknown archive location paths? |
Select Yes if you do not want AppManager to raise an error when an archive log file location is not defined or not accessible. You can use this parameter when monitoring a database used as a backup for disaster recovery. The default is unselected. |
|
Raise event if threshold is not met? |
Select Yes to raise an event if space available for the archive log falls below the minimum threshold. The default is Yes. |
|
Threshold - Minimum archive log space |
Enter a threshold for the minimum available disk space for the archive log file. If the available space falls below this threshold, the job raises an event. The default is 100. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator). |
|
Monitor space available for background process log? |
Select Yes to monitor the amount of space available for the background process log file of the database. The default is Yes. |
|
Raise event if threshold is not met? |
Select Yes to raise an event if space available for the background process log file falls below the threshold. The default is Yes. |
|
Threshold - Minimum background process log space |
Enter a threshold for the minimum available disk space for the background process log file. If the amount of available space falls below this threshold, the job raises an event. The default is 100. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator). |
|
Monitor space available for user logs? |
Select Yes to monitor the amount of space available for the user log files of the database. The default is Yes. |
|
Raise event if threshold is not met? |
Select Yes to raise an event if space available for the user log file falls below the threshold. The default is Yes. |
|
Threshold - Minimum user log space |
Enter a threshold for the minimum available disk space for user log files. If the amount of available space falls below this threshold, the job raises an event. The default is 100. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator). |
|
Event severity for internal failure |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator). |