Login Failures

SQL Statement

select count(*) from dba_audit_session@#DBLINK#
where action_name = 'LOGON'
and returncode <> 0
and timestamp > sysdate - 1/24;

Description

If your Oracle database is configured for auditing, this alert will monitor for logon failures and alert the DBA group. It runs once every hour and looks for logon failures from the last hour.

Check for Hung Monitor

PDF Icon For more information about Writing Custom Alerts, see PG110.
Tech Links (top)
What We Do
Download Free Trials
Specifications and Datasheets
Technology Whitepapers
Frequently Asked Questions
Tech Links (bottomn)