Skip Headers
DBA_PROFILES displays all profiles and their limits.
DBA_PROFILES
PROFILE
VARCHAR2(30)
NOT NULL
Profile name
RESOURCE_NAME
VARCHAR2(32)
Resource name
RESOURCE_TYPE
VARCHAR2(8)
Indicates whether the resource profile is a KERNEL or a PASSWORD parameter
KERNEL
PASSWORD
LIMIT
VARCHAR2(40)
Limit placed on this resource for this profile