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:
The following table lists the records and fields related to the frequency of wait events concerning REDO log file.
Table 1-5 Records and fields related to wait events concerning REDO log file
Record used | Field used | Value measured (example) |
---|---|---|
PI | Redo Log Space Requests | Number of waiting until the disk space is allocated to a redo entry because the active redo log file is full. |