Oracle Script - List of Locked Users

The following SQL script will list out all users with its status:

SELECT username, account_status
FROM dba_users;