— to count failed log in attempts:
SELECT name, lcount FROM user$ WHERE lcount <> 0;
Posts Tagged ‘FAILED_LOGIN_ATTEMPTS’
Query to count failed log in attempts
Posted: April 3, 2013 in DBA Useful ScriptsTags: failed login, failed login attempts, FAILED_LOGIN_ATTEMPTS, lcount, oracle, profile
0
Finny's Oracle Blog 