How to find users with default passwords in Oracle

Find accounts still using a known default password. Oracle ships this check as the DBA_USERS_WITH_DEFPWD view.

SELECT d.username, u.account_status, u.profile
FROM   dba_users_with_defpwd d
JOIN   dba_users u ON u.username = d.username
ORDER  BY d.username;