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>





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-l
Received on Thu Dec 07 2017 - 21:52:08 CET

Original text of this message