Enterprise Manager Generic (MOSC)

MOSC Banner

How could you disable the Failed Logon alert in EM as it is causing very heavy loads

edited Aug 27, 2020 2:50PM in Enterprise Manager Generic (MOSC) 2 commentsAnswered ✓

Failed Logon is a delivered metric by EM 13.3c.  Because our aud$ table has a few million rows (less than 10 Million), this statement is taking several hours to run causing huge disk reads and buffer gets.  It is set to run every 30 minutes.  I have tried many things to disable this event and all of the attempts have failed:

1) Tried to disable this event altogether
2)  Set it to run ever 999999 minutes so it does not run very often

If the only solution is to trim the aud$ table, please let me know the safest way.  We still want to keep at least one year's worth of data in it.

Tagged:

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