DBA_PROFILES

DBA_PROFILES displays all profiles and their limits.

Column	Datatype	NULL	Description
`PROFILE`	`VARCHAR2(128)`	`NOT NULL`	Profile name
`RESOURCE_NAME`	`VARCHAR2(32)`	`NOT NULL`	Resource name
`RESOURCE_TYPE`	`VARCHAR2(8)`		Indicates whether the resource profile is a `KERNEL` or a `PASSWORD` parameter
`LIMIT`	`VARCHAR2(128)`		Limit placed on this resource for this profile
`COMMON`	`VARCHAR2(3)`		Indicates whether a given profile is common. Possible values: `YES` if a profile is common `NO` if a profile is local (not common)