SQL> col table_name format a20
SQL> col comments format a80
SQL> select * from dict where lower(comments) like '%profile%';
TABLE_NAME           COMMENTS
-------------------- -----------------------------------------------
DBA_PROFILES         Display all profiles and their limits
DBA_SQL_PROFILES     set of sql profiles

select a.username,a.profile,b.resource_name,b.limit
from dba_profiles b,dba_users a
where a.profile = b.profile
and b.resource_type = 'PASSWORD'
ORDER BY A.USERNAME,B.RESOURCE_NAME;