Use this Knowledge Script to monitor the total number of physical read/write (I/O) operations per second and/or the total memory usage for Oracle RDBMS background processes. If the total number of read/write operations per second or the total memory usage for the list of specified processes exceeds the threshold, the job raises an event.
Oracle RDBMS background processes include CKPT, DBW0, LGWR, PMON, RECO, SMON, SNP0, and others. You can monitor all or individual background processes.
The account you use to run this script must have SELECT permissions for the following tables:
V_$BGPROCESS
V_$PROCESS
V_$SESSION
V_$SESSTAT
V_$STATNAME
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 30 minutes.
Set the following parameters as needed:
|
Description |
How to Set It |
|---|---|
|
Oracle Username |
Enter the username that this script needs to access the target Oracle RDBMSs. 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 memory usage and I/O of Oracle processes? |
Select Yes to collect data for charts and reports. If data collection is enabled, returns the number of read/write operations per second, or the total memory usage for all monitored background processes. The default is unselected. |
|
Oracle background processes to monitor |
Enter the names of the background processes you want to monitor. Separate the names with commas; do not use spaces. To monitor all Oracle RDBMS background processes, enter an asterisk (*). Possible valid background process names include:
The default is (*) (all background processes). |
|
Monitor read/write operations? |
Select Yes to monitor the number of physical read/write operations per second by background processes. The default is Yes. |
|
Raise event if threshold is exceeded? |
Select Yes to raise an event when the number of physical read/write operations per second exceeds the threshold you set. The default is Yes. |
|
Threshold - Maximum read/write operations rate |
Enter a threshold for the maximum number of physical read/write operations per second. The default is 5. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 15 (yellow event indicator). |
|
Monitor memory usage? |
Select Yes to monitor the total memory usage by background processes. The default is Yes. |
|
Raise event if threshold is exceeded? |
Select Yes to raise an event when the memory utilization of the monitored processes exceeds the threshold you set. The default is unselected. |
|
Threshold - Maximum memory usage |
Enter a threshold (in MB) for the maximum amount of memory used by all background processes you are monitoring. The default is 15. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 15 (yellow 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). |