Find all user and their status in Oracle

To view current users in Oracle database and their current status:

select username, account_status from dba_users;