Edit the resource limits associated with a user profile
Syntax:
ALTER PROFILE profile_name LIMIT limit(s) range
KEY
limit = SESSIONS_PER_USER
CPU_PER_SESSION
CPU_PER_CALL
CONNECT_TIME
IDLE_TIME
LOGICAL_READS_PER_SESSION
LOGICAL_READS_PER_CALL
COMPOSITE_LIMIT
PRIVATE_SGA
range = UNLIMITED | DEFAULT | integer
for PRIVATE_SGA specify K or M
e.g.
ALTER PROFILE MyProfile LIMIT PRIVATE_SGA 50 K
New with Oracle 8 are password related profile limits…
Syntax:
ALTER PROFILE profile_name LIMIT pw_limit(s) range
KEY
pw_limit = PASSWORD_LIFE_TIME
PASSWORD_GRACE_TIME
PASSWORD_REUSE_TIME
PASSWORD_REUSE_MAX
FAILED_LOGIN_ATTEMPTS
PASSWORD_LOCK_TIME
range = UNLIMITED | DEFAULT | expression
Syntax to customise password verification:
ALTER PROFILE profile_name LIMIT PASSWORD_VERIFY_FUNCTION {plsql_function | NULL | DEFAULT}
Definitions
CONNECT_TIME - Max. time user can stay connected
IDLE_TIME - Max. time user can stay connected & idle
PRIVATE_SGA - Session space in the shared pool - K or M (bytes)
COMPOSITE_LIMIT - A weighted sum of CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION, and PRIVATE_SGA.
PASSWORD_LIFE_TIME - Expire password after X no of days
PASSWORD_GRACE_TIME - Lock account X days after LIFE_TIME expires.
PASSWORD_REUSE_TIME - Min. no. days before the same pw can be reused
PASSWORD_REUSE_MAX - Min. no. of number of pw changes before the current password can be reused
FAILED_LOGIN_ATTEMPTS - Max no. of incorrect logins before account is locked
PASSWORD_LOCK_TIME - Max. no. of days an account will be locked
DEFAULT refers to values set in the DEFAULT user profile.
"Oh judge! Your damn laws! The good people don’t need them, and the bad people don’t obey them” ~ Ammon Hennacy
Related Oracle Commands:
PROFILE - CREATE PROFILE
PROFILE - DROP PROFILE
ROLE - SET ROLE
ROLE - ALTER ROLE
Related Views:
DBA_PROFILES
DBA_SYS_PRIVS USER_SYS_PRIVS ROLE_SYS_PRIVS
V$SESSION
V$SESSION_CONNECT_INFO
V$SESSTAT
V$SESS_IO