The user using some application to login. The problem is whenever the user enters wrong password, the application hits the database two times it seems. Because of that the user account locks at second attempt itself even though I set failed_login_attempts as 3 for their profile.

I believe that oracle holds the failed login attempt counts and that can be viewed, I am not sure which table/view to query.

I got into one of the site and they told to query user$, but there is no such view available.