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)

INHERITEDFoot 1

VARCHAR2(3)

Indicates whether the profile definition was inherited from another container (YES) or not (NO)

IMPLICITFootref 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).