ALTER PROFILE
ALTER PROFILEprofile_name
LIMIT [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:
Limits the number of concurrent sessions for a user. Note that each slave process in a parallel query uses one slot.
Limits the amount of CPU time (in hundredths of a second) that can be used in a session.
Limits the amount of CPU time (in hundredths of a second) for a parse, execute, or fetch call.
Limits the amount of continuous inactive time (in minutes) during a session.
Limits the number of database blocks read in a session, including those read from memory and disk.
Limits the number of database blocks read for a parse, execute, or fetch call.
Limits the amount of memory (in bytes) a session can allocate in the shared pool of the SGA.
Limits the total resource cost (in service units) for a session. See ALTER RESOURCE COST for additional information.
Limits the number of failed login attempts before the account is locked.
Limits the lifetime of the password. The value is specified in fractions of a day.
Specifies the number of days for which the account will be locked after failed login attempts.
Specifies the number of days the user has to change the password after the password has expired.
Specifies the minimum number of days before a password can be reused. If this value is set, the PASSWORD_REUSE_MAX must be unlimited.
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.
Specifies the name of a function that will validate a new password. The function must be owned by SYS.
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.