Re: Enterprise Manager warns of blocking on LGWR

From: Kellyn Pot'Vin-Gorman <>
Date: Fri, 08 Dec 2017 14:39:28 +0000
Message-ID: <>

If these alerts are creating “white noise” for your DBA Group, please consider using one or more methods to properly silence the noise. This is a six part blog post, (which the bellow link is only one of) but should help you get a handle on the alerting and address it for the affected targets.

Good luck,

On Thu, Dec 7, 2017 at 1:53 PM Jeffrey Beckstrom <> wrote:

> We are running EM For the past several months, since upgrading
> our agent to, 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
> <,+Ohio+44113&entry=gmail&source=g>
> Cleveland, Ohio 44113
> <,+Ohio+44113&entry=gmail&source=g>
> --

[image: Kellyn Pot'Vin on]

Kellyn Pot'Vin-Gorman

Received on Fri Dec 08 2017 - 15:39:28 CET

Original text of this message