Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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 |