DBA_PROFILES

DBA_PROFILES displays all profiles and their limits.

Column	Datatype	NULL	Description
`PROFILE`	`VARCHAR2(30)`	`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(40)`		Limit placed on this resource for this profile