Enterprise Manager Generic (MOSC)

MOSC Banner

Residual metrics data in targets' dba_outstanding_alerts

edited Oct 17, 2012 6:39AM in Enterprise Manager Generic (MOSC) 1 commentAnswered
OEM appears to write and update the underlying tables supporting dba_outstanding_alerts view (wri$_alert_outstanding,  x$keltsd, x$keltosd,  x$keltgsd, dba_advisor_definitions) when an EM alert is raised and resolved.We clone several of our databases nightly and this data moves with the clone, of course.  Unfortunately when an alert has already been registered in dba_outctanding_alerts the 'child' database does not alert on the same metric (tablespaces in particular).

Is there an emcli verb that allows me to clear these?  I couldn't find one in the Verb Bible E17786-06.

Do I need to manually clear these residual alerts every morning through the console?  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center