Friday, January 30, 2015
CPU Usage is 100%
Oracle Process shows 100% CPU Usage continuously on Database version 18.104.22.168
Most of the sessions are waiting on "latch: cache buffers chains" from long time even though those sessions are not processing any of the information.
This is the bug in 22.214.171.124. Range of versions believed to be affected from 11.1 but BELOW 12.1 on Generic (all / most platforms affected) platform.
Clear "latch: cache buffers chains" sessions at regular interval based on identified condition.
This issue is fixed on database version 126.96.36.199, So the database should upgrade to minimum 188.8.131.52.