Meaning of different status in DBA_USERS

Basically there are only three different status :-
Open :- Account is open
Expired :- Password has expired and needs to be changed
Locked :- Explicitly locked by DBA or locked because of wrong password being enterd for login for "N" number of times.

Account_status in DBA_USERS

OPEN :- No DBA action required

     Open Account

LOCKED :- DBA needs to unlock the account

     An account locked by a DBA

EXPIRED(GRACE) & LOCKED :- DBA needs to unlock the account

     This is caused grace period defined by PASSWORD_GRACE_TIME and the administrator has locked the account.

EXPIRED & LOCKED :- DBA needs to unlock the account

     This is caused by the password not being changed before the PASSWORD_LIFE_TIME profile hence limit is exceeded and the administrator has locked the account.

LOCKED(TIMED) :- No DBA action required based on profile

     Locked automatically after a number of failed login attempts. When a PASSWORD_LOCK_TIME is defined, the account unlocks automatically after the set time.

EXPIRED(GRACE) & LOCKED(TIMED) :- No DBA action required based on profile :-

     This is caused grace period defined by PASSWORD_GRACE_TIME and locked automatically after number of failed logins.

EXPIRED(GRACE) :- No DBA action required based on profile

     During the grace period defined by PASSWORD_GRACE_TIME in profile a warning is issued at time of login and the ACCOUNT_STATUS is set to EXPIRED(GRACE).

EXPIRED & LOCKED(TIMED) :- No DBA action required based on profile

     This is caused by the password not being changed before the PASSWORD_LIFE_TIME profile limit is exceeded and account is locked after number of failed login attempts.

EXPIRED :- No DBA action required based on profile

User is prompted for a new password upon the next login attempt.