Purpose
The DBA_PROFILES view displays all the profiles and their limitations.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_PROFILES
USER_PROFILES
Columns
| Column | 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. |