How to identify a user (Oracle) that is locked due to unsuccessful login attempts How to differentiate in oracle a user deliberately locked by the security administrator and locked due to unsuccessful login attempts
Select the user information from dba_users and look at the ACCOUNT_STATUS. If the status is LOCKED then the user was deliberately locked. If it is LOCKED(TIMED) then it is locked because of multiple wrong passwords. If you have set the PASSWORD_LOCK_TIME then the user will be unlocked after this time is reached.

select   username, account_status
from     dba_users
where    username='A-USERNAME'
/