Re: Enterprise Manager warns of blocking on LGWR
Date: Fri, 08 Dec 2017 14:39:28 +0000
Message-ID: <CAN6wuX1FbveAdc4nbtUEtXzz7U5-nZTD4ANZdsAcV_izBkTS9w_at_mail.gmail.com>
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.
http://dbakevlar.com/2013/12/em12c-managing-incidents-stop-the-insanity-part-ii/
Good luck,
Kellyn
On Thu, Dec 7, 2017 at 1:53 PM Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:
> 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
> <https://maps.google.com/?q=1240+W.+6th+Street+Cleveland,+Ohio+44113&entry=gmail&source=g>
> Cleveland, Ohio 44113
> <https://maps.google.com/?q=1240+W.+6th+Street+Cleveland,+Ohio+44113&entry=gmail&source=g>
>
> --
[image: Kellyn Pot'Vin on about.me]
Kellyn Pot'Vin-Gorman
about.me/dbakevlar
<http://about.me/dbakevlar>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 08 2017 - 15:39:28 CET