DOYENSYS Knowledge Portal

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

Friday, January 30, 2015

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

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.

This is the bug in 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, So the database should upgrade to minimum

No comments: