Find User Account Status in Oracle

In Oracle, you can find your account status. Login in SQL and execute below command.

SQL> select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SAPSR3                         OPEN
SYS                            OPEN
ITSITII                        OPEN
AYAMAS                         EXPIRED(GRACE)
SYSTEM                         LOCKED(TIMED)
OUTLN                          LOCKED(TIMED)

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
ORACLE_OCM                     LOCKED
DBSNMP                         LOCKED
DIP                            LOCKED
KACIPKAMB                      EXPIRED & LOCKED

10 rows selected.