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: '_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
Advertisements
