Oracle 11gR1DBA_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
|
Note:
1.
select * from DBA_PROFILES where profile = 'DEFAULT';
PROFILE
|
RESOURCE_NAME
|
RESOURCE_TYPE
|
LIMIT
|
DEFAULT
|
COMPOSITE_LIMIT
|
KERNEL
|
UNLIMITED
|
DEFAULT
|
SESSIONS_PER_USER
|
KERNEL
|
100
|
DEFAULT
|
CPU_PER_SESSION
|
KERNEL
|
UNLIMITED
|
DEFAULT
|
CPU_PER_CALL
|
KERNEL
|
UNLIMITED
|
DEFAULT
|
LOGICAL_READS_PER_SESSION
|
KERNEL
|
UNLIMITED
|
DEFAULT
|
LOGICAL_READS_PER_CALL
|
KERNEL
|
UNLIMITED
|
DEFAULT
|
IDLE_TIME
|
KERNEL
|
UNLIMITED
|
DEFAULT
|
CONNECT_TIME
|
KERNEL
|
UNLIMITED
|
DEFAULT
|
PRIVATE_SGA
|
KERNEL
|
UNLIMITED
|
DEFAULT
|
FAILED_LOGIN_ATTEMPTS
|
PASSWORD
|
50
|
DEFAULT
|
PASSWORD_LIFE_TIME
|
PASSWORD
|
UNLIMITED
|
DEFAULT
|
PASSWORD_REUSE_TIME
|
PASSWORD
|
UNLIMITED
|
DEFAULT
|
PASSWORD_REUSE_MAX
|
PASSWORD
|
UNLIMITED
|
DEFAULT
|
PASSWORD_VERIFY_FUNCTION
|
PASSWORD
|
NULL
|
DEFAULT
|
PASSWORD_LOCK_TIME
|
PASSWORD
|
UNLIMITED
|
DEFAULT
|
PASSWORD_GRACE_TIME
|
PASSWORD
|
UNLIMITED
|
Oracle data dictionary views
More Oracle DBA tips, please visit Oracle DBA Tips
No comments:
Post a Comment