How to check user account status in oracle

SQL> SELECT username, account_status, created, lock_date, expiry_date from dba_users where default_tablespace not in ('SYSTEM','SYSAUX','SYS','SYSMAN') and account_status != 'OPEN';

USERNAME            ACCOUNT_STATUS          CREATED     LOCK_DATE     EXPIRY_DATE
--------------- -------------------------------- --------- --------- -------------------------------------------------
DRUSAH                LOCKED(TIMED)               11-OCT-14      23-FEB-15         27-JUN-15
RNSIJO                  LOCKED(TIMED)               11-OCT-14      09-NOV-14        09-APR-15
RTHASA                 LOCKED(TIMED)               11-OCT-14      14-OCT-14         09-APR-15



3 rows selected.



Happy Learning ...