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.