After upgrading one of our main transaction heavy RAC databases from 12.1 to
12.2 we had a small but noticeable decrease in overall performance. Looking at
AWR reports I saw a new wait event popped up into the Top Timed Events which I
had never seen before - "LGWR any worker group". Metalink isn't very helpful,
just pointing to an IBM/AIX bug (we're on RedHat Linux running on x86).
I can't find a definition of what the wait event signifies much less what might
cause it.
Anyone here familiar with it?
Thanks!
Jay Miller
Sr. Oracle DBA