Log Writer Consumes 100% CPU in Oracle

Log Writer Consumes 100% CPU with the instance going for Hang and the system

WARNING: inbound connection timed out (ORA-3136)

Check the blocking session:

SELECT sid, blocking_session, username, blocking_session_status FROM v$session ORDER BY blocking_session;

Workaround:

Set parameter ‘_lgwr_async_io=false ‘ to prevent LGWR from spinning.

Note: The problem may manifest even after _lgwr_async_io = false has been set and instance bounced.

Leave a Reply