Warn on login failure

Hi

We already have a logon audit on our server, but we wish to have more control for some special users, like sys, system and some application schemas we use.

Is there a way to be warned when there´s a failed login attempt using these users? Failed login do nothing on the database, except for writing audit, so, no triggers..

A job or cron to query dba_audit_session each couple of minutes is too heavy as the query execution consume about 45 seconds.

We need the information fastly, because we have some shared machines, and hours laters reports leave us with there´s no way to know who was there on that moment. And we already had some problems, like account locking of these application schemas (some are always locked, but some, third party, are needed to be opened).

Any ideas?

Thanks

Luiz Felipe Rivabem Received on Thu Feb 02 2006 - 11:44:28 CST