6.256 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 the profile

COMMON

VARCHAR2(3)

Indicates whether the profile is common. Possible values:

  • YES if a profile is common

  • NO if a profile is local (not common)

INHERITED

VARCHAR2(3)

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

IMPLICIT

VARCHAR2(3)

Indicates whether the profile was created by an implicit application (YES) or not (NO)

MANDATORYFoot 1

VARCHAR2(3)

Indicates whether the profile is a mandatory user profile (YES) or not (NO)

See Also: The MANDATORY_USER_PROFILE initialization parameter

Footnote 1 This column is available starting with Oracle Database 21c.