The user$.lcount column does track consecutive failed logins, but only when you have set up a maximum number of failed login attempts (using profiles and the FAILED_LOGIN_ATTEMPTS limit). If you have FAILED_LOGIN_ATTEMPTS UNLIMITED (check DBA_PROFILES), then user$.lcount will remain 0 no matter how many failed attempts a user tries. I suppose that you could, in theory, set FAILED_LOGIN_ATTEMPTS to some very high number (the upper limit in 9iR2 appears to be somewhere between 2.1 and 2.2 million) and that would essentially be unlimited. If you have a user that actually tries to login with an incorrect password 2.1 million times, you should definitely nominate them for the darwin award! :)
Dig Deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.