Hi there,
(DB 11.2- Solaris 11)
The number of active redologs in our database suddenly increased. I know that after all redologs get active the database will suffer from some blocking session due to "checkpoint incomplete" wait event. So I decide to force the db to checkpoint. I issued "alter system checkpoint" and after 3 hours it does not completed yet. I took a look at the activity tab in the related session in OEM and I found that almost all of the wait event of that session is "enq: CI - contention". What does this mean?
thanks in advance.
Regards.