How to review password and lockout policy per profile in Oracle

Review the password and lockout limits set on each profile: failed-login lockout, password lifetime, reuse rules, and the complexity function.

SELECT profile, resource_name, limit
FROM   dba_profiles
WHERE  resource_type = 'PASSWORD'
ORDER  BY profile, resource_name;