Oracle redo log wait events

Oracle redo log wait events these two days found that the development database, when running some small DML transactions, will often appear log buffer space events, then, four groups of redo logs are increased to 300 mb. After the log buffer parameter is adjusted, the redo logs still appear. I asked the experts to say that the disk I/O is slow. Www.2cto.com didn't come up with any good solutions. Oracle interpretation of redo log wait events: 1.log buffer space Waiting for space in the log buffer because the session is writing data into the log buffer faster than LGWR can write it out. consider making the log buffer bigger if it is small, or moving the log files to faster disks such as striped disks. www.2cto.com waits for the space of the log buffer, because the session writes data to the log buffer faster than the LGWR process writes the data of the log buffer to the log file. we recommend that you increase the log buffer, or Put log files on a fast disk. Wait Time: Usually 1 second, but 5 seconds if it is waiting for a Switch Logfile to complete completed ---------- 2.log file switch (checkpoint incomplete) waiting for a log switch because the session cannot wrap into the next log. wrapping cannot be writable med because the checkpoint f Or that log has not completed. wait for the log switch because the log has not written the corresponding data to the disk. wait Time: 1 second Parameters: None before ------------- 3.log file switch completion Waiting for a log switch to complete. wait until the log switch is complete. Wait Time: 1 second Parameters: None ----------------------------------------------------- 4.log file sync When a user session commits, the session's redo information needs to be flushed to the redo logfile. the user session will post the LGWR to write the log buffer to the redo log file. when the LGWR has finished writing, it will post the user session. when a user issues the commit command, the redo information in the redo log file needs to be overwritten. The LGWR process writes the content in the log buffer to the redo log. Wait Time: The wait time when des the writing of the log buffer and the post. Parameter Descriptionbuffer # The number of the physical buffer in the redo log buffer that needs to be synchronized