5.246 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)
`INHERITED`^Foot 1	`VARCHAR2(3)`		Indicates whether the profile definition was inherited from another container (`YES`) or not (`NO`)
`IMPLICIT`^Footref 1	`VARCHAR2(3)`		Indicates whether this profile was created by an implicit application (`YES`) or not (`NO`)

^Footnote 1

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).