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.