Enterprise Manager warns of blocking on LGWR
From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Thu, 07 Dec 2017 15:52:08 -0500
Message-Id: <5A29A9F80200000B0003480D_at_groupwise2014.gcrta.org>
Date: Thu, 07 Dec 2017 15:52:08 -0500
Message-Id: <5A29A9F80200000B0003480D_at_groupwise2014.gcrta.org>
We are running EM 12.1.0.5. For the past several months, since upgrading our agent to 12.1.0.5, across various databases we have been receiving a blocking alert warning with the blocker being LGWR. By the time you log on the database directly or through Enterprise Manager, no blocking locks can be found. In fact, sometimes no active sessions are found or run quickly. After about 15+ minutes the alert clears.
We do correctly receive the alert on user sessions that are causing a locking condition.
Is there a way to bypass LGWR?
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 07 2017 - 21:52:08 CET