Check userstatus in oracle db

su - oracle
sqlplus /nolog
connect / as sysdba
Get list of status for users:
select username, account_status from dba_users;
Locking up a user:
alter user system account lock;