Log File Sync Wait Event
In the Oracle database, when a user commits or rolls back a transaction, the redo data for the session (that’s currently held in memory) has to be written to the redo log file on disk. The user session tells the LGWR process to write the contents of the log buffer to the redo log file. … Read more