Description
If your Oracle database is configured for auditing, this alert will monitor for logon failures using the DBA_AUDIT_SESSION view.
Alert Definition
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert as needed and past in the attached query.