3.28 RedoLogSpaceWaitRatio

Use this Knowledge Script to monitor the redo log space wait ratio. The redo log space wait ratio measures memory allocation. The ratio reflects the number of times the background process was requested to allocate space within the redo file per number of redo log entries. If this ratio increases, you might want to increase the size of the redo log buffer.

When the redo log space wait ratio exceeds the threshold you set, the job raises an event.

The account you use to run this script must have SELECT permissions for the following tables:

V_$SYSSTAT
V_$VERSION

3.28.1 Resource Objects

Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and monitors only that database.

3.28.2 Default Schedule

The default interval for this script is Every 10 minutes.

3.28.3 Setting Parameter Values

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 redo log space wait ratio?

Set to y to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the redo log space wait ratio. The default is n.

Raise event if threshold is exceeded?

Select Yes to raise an event if the redo log space wait ratio exceeds the threshold you set. The default is Yes.

Threshold - Maximum redo log space wait ratio

Enter a maximum threshold for the redo log space wait ratio. The default is 0.0002.

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator).

Ignore agent’s blackout state and keep monitoring?

Select Yes to collect data during the blackout window for scheduled maintenance that you set using the AppManager for UNIX AMAdminUNIX_ SchedMaint Knowledge Script. The default is unselected.

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).