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

profileCHARACTER VARYING(128)The name of the profile.
resource_nameCHARACTER VARYING(32)The name of the resource associated with the profile.
resource_typeCHARACTER VARYING(8)The type of resource governed by the profile; currently 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.