Multiple choice

What causes session waits in the log buffer?

  1. The rollback tablespace extends.

  2. Data has not been committed to the database.

  3. Data is written into the log buffer faster than LGWR can write it out.

  4. A transaction has an exclusive lock on a row.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Session waits occur when processes must wait for resources. Log buffer waits happen when DML generates redo faster than LGWR (Log Writer) can flush it to disk. When the buffer fills, sessions must wait for space to become available. Rollback extension, uncommitted data, or row locks don't directly cause log buffer waits.

Keep practicing — related questions