Purpose
DBA_PROFILES displays all the profiles and their limitations.
Related views
ALL_PROFILES
USER_PROFILES
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| PROFILE | VARCHAR2(30) | NO | The name of the profile. |
| RESOURCE_NAME | VARCHAR2(32) | NO | The name of the resource. |
| RESOURCE_TYPE | VARCHAR2(8) | NO | Indicates whether the resource profile is a KERNEL parameter or a PASSWORD parameter. |
| LIMIT | VARCHAR2(40) | NO | The limitation on the resource for the profile. |
