DBA_PROFILES displays all profiles and their limits.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PROFILE |
VARCHAR2(30) |
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(40) |
Limit placed on this resource for this profile |