Name
ALTER PROFILE
Synopsis
ALTER PROFILEprofile_nameLIMIT [SESSIONS_PER_USER {integer| UNLIMITED | DEFAULT}] [CPU_PER_SESSION {integer| UNLIMITED | DEFAULT}] [CPU_PER_CALL {integer| UNLIMITED | DEFAULT}] [CONNECT_TIME {integer| UNLIMITED | DEFAULT}] [IDLE_TIME {integer| UNLIMITED | DEFAULT}] [LOGICAL_READS_PER_SESSION {integer| UNLIMITED | DEFAULT}] [LOGICAL_READS_PER_CALL {integer| UNLIMITED | DEFAULT}] [PRIVATE_SGA {integer[K | M] | UNLIMITED | DEFAULT}] [COMPOSITE_LIMIT {integer| UNLIMITED | DEFAULT}] [FAILED_LOGIN_ATTEMPTS {integer| UNLIMITED | DEFAULT}] [PASSWORD_LIFE_TIME {integer| UNLIMITED | DEFAULT}] [PASSWORD_LOCK_TIME {integer| UNLIMITED | DEFAULT}] [PASSWORD_GRACE_TIME {integer| UNLIMITED | DEFAULT}] [PASSWORD_REUSE_TIME {integer| UNLIMITED | DEFAULT}] [PASSWORD_REUSE_MAX {integer| UNLIMITED | DEFAULT}] [PASSWORD_VERIFY_FUNCTION {function| NULL | DEFAULT}]
Adds, changes, or removes a resource limit from an existing profile (profile_name). For many of the following keywords you can specify:
Keywords
- SESSIONS_PER_USER
Limits the number of concurrent sessions for a user. Note that each slave process in a parallel query uses one slot.
- CPU_PER_SESSION
Limits the amount of CPU time (in hundredths of a second) that can be used in a session.
- CPU_PER_CALL
Limits the amount of CPU time (in hundredths of a second) for a parse, execute, or fetch call.
- CONNECT_TIME
- IDLE_TIME
Limits the amount of continuous inactive time (in minutes) during a session.
- LOGICAL_READS_PER_SESSION
Limits the number of database blocks read in a session, including those read from memory and disk.
- LOGICAL_READS_PER_CALL
Limits the number of database blocks read for a parse, execute, or fetch call.
- PRIVATE_SGA
Limits the amount of memory (in bytes) a session can allocate in the shared pool of the SGA.
- COMPOSITE_LIMIT
Limits the total resource cost (in service units) for a session. See ALTER RESOURCE COST for additional information.
- FAILED_LOGIN_ATTEMPTS
Limits the number of failed login attempts before the account is locked.
- PASSWORD_LIFE_TIME
Limits the lifetime of the password. The value is specified in fractions of a day.
- PASSWORD_LOCK_TIME
Specifies the number of days for which the account will be locked after failed login attempts.
- PASSWORD_GRACE_TIME
Specifies the number of days the user has to change the password after the password has expired.
- PASSWORD_REUSE_TIME
Specifies the minimum number of days before a password can be reused. If this value is set, the PASSWORD_REUSE_MAX must be unlimited.
- PASSWORD_REUSE_MAX
Specifies the number of password changes that must occur before the current password can be reused. If this value is set, the parameter PASSWORD_REUSE_TIME must be unlimited.
- PASSWORD_VERIFY_FUNCTION
Specifies the name of a function that will validate a new password. The function must be owned by SYS.
Notes
This command will only affect subsequent sessions; sessions already established will not be subject to the new limits. You must have the ALTER PROFILE privilege to issue this command.
The parameters that support password aging are specified in days. You can specify a fraction of a day by using standard fraction notation. For example, you can use 1/24 to specify an hour.