DBA_PROFILES

Display all profiles and their limits

Columns
   ___________________________
 
   PROFILE
      Profile name
   RESOURCE_NAME
      Resource name
   RESOURCE_TYPE
      --
   LIMIT
      Limit placed on this resource for this profile

Related: