The DBA_PROFILES view provides information about existing profiles. The table includes a row for each profile/resource combination.

profileCHARACTER VARYING(128)Name of the profile.
resource_nameCHARACTER VARYING(32)Name of the resource associated with the profile.
resource_typeCHARACTER VARYING(8)Type of resource governed by the profile. PASSWORD for all supported resources.
limitCHARACTER VARYING(128)The limit values of the resource.
commonCHARACTER VARYING(3)YES for a user-created profile, NO for a system-defined profile.