1.3.7 Monitoring wait events concerning REDO log file
When the size of REDO log file is small on an Oracle server, wait events may occur. Thus, it is crucial to monitor the frequency of wait events concerning REDO log file:
-
Monitoring the frequency of wait events concerning REDO log file
- Organization of this subsection
(1) Records and fields related to the frequency of wait events concerning REDO log file
The following table lists the records and fields related to the frequency of wait events concerning REDO log file.
|
Record used |
Field used |
Value measured (example) |
|---|---|---|
|
PI |
Redo Log Space Requests |
Number of times that waiting is required until the disk space is allocated to a REDO log entry because the active redo log file is full. |
(2) Monitoring methods
- Monitoring wait events concerning REDO log file
-
Wait events concerning REDO log file can be monitored by using the Redo Log Contention alarm provided with the monitoring template.
When Redo Log Contention is at or above its threshold, wait events concerning REDO log file occurs, often because the REDO log file is too small.
This problem can be handled by increasing the size of the REDO log file.