"LGWR any worker group" wait event
From: <Jay.Miller_at_tdameritrade.com>
Date: Fri, 17 Nov 2017 21:27:59 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F75475E9A3_at_PRDCTWPEMLMB31.prod-am.ameritrade.com>
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).
Date: Fri, 17 Nov 2017 21:27:59 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F75475E9A3_at_PRDCTWPEMLMB31.prod-am.ameritrade.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 17 2017 - 22:27:59 CET