Result_cache blocking II

Following on from my post yesterday, it belatedly occurred to me that I should have included some more information. Rather than add an addendum to the original where it might be missed by anyone interested that had already read it, I’m going kick off another post.

By the time, I got involved the problem had been ongoing for 25 minutes. All-in-all, the “incident” lasted 40 minutes. To get an accurate report, we need a snap that spans the problem, i.e. start snap is before problem started, end snap is post incident resolution. So, what follows are selected highlights from from a two hour AWR report.

Note the RC enqueues.

Apologies for the formatting – can’t see to find a combination which works well.