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