Are there waiting for log buffer space
SELECT sid, event, seconds_in_wait, state FROM v $ session_wait WHERE event = 'log buffer space'; Example 1: SQL> SELECT sid, event, seconds_in_wait, state 2 FROM v $ session_wait 3 WHERE event = 'log buffer space'; no rows selecte ...