SQL>
SQL> SELECT username, account_status
2 FROM dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
RNTSOFT OPEN
SYS OPEN
SYSTEM OPEN
ANONYMOUS OPEN
MDSYS EXPIRED & LOCKED
OUTLN EXPIRED & LOCKED
DIP EXPIRED & LOCKED
TSMSYS EXPIRED & LOCKED
FLOWS_FILES EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED
DBSNMP EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
FLOWS_020100 EXPIRED & LOCKED
XDB EXPIRED & LOCKED
HR EXPIRED & LOCKED
14 rows selected.