DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, January 30, 2015

CPU Usage is 100%
Problem:
Oracle Process shows 100% CPU Usage continuously on Database version 11.2.0.1

Root Cause:
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.

Observation:
This is the bug in 11.2.0.1. Range of versions believed to be affected from 11.1 but BELOW 12.1 on Generic (all / most platforms affected) platform.

Work Around:
Clear "latch: cache buffers chains" sessions at regular interval based on identified condition.

Fix/Permanent Solution:
This issue is fixed on database version 11.2.0.2, So the database should upgrade to minimum 11.2.0.2.

No comments: