Re: Blocking Session alert in EM 12C

From: Rich Jesse <>
Date: Thu, 24 Apr 2014 12:56:31 -0500 (CDT)
Message-ID: <>

Jeffrey posts:

> Just installed EM 12C and created a blocking session to test alerts. EM is
> not generating an alert even though a lock is existing in the database.
> Does some metric have to be turned on to enable blocking session alerts?

I have the opposite problem, where it's reporting blocking locks when there are none. On your target DB (version?), if you have them, check DBA_OUTSTANDING_ALERTS and potentially -- is this a Diagnostic Pack licensable view? -- DBA_ALERT_HISTORY.

Are you on EM with Oracle Database plugin (aka "Latest'n'Greatest")? If not, you can guess where you're going to be directed next, whether the newer patches address your issue directly or not.  Such is life...


Received on Thu Apr 24 2014 - 19:56:31 CEST

Original text of this message