You can change those limits with the ALTER PROFILE statement.Īny user who is not explicitly assigned a profile is subject to the limits defined in the DEFAULT profile. The DEFAULT profile initially defines unlimited resources. A user assigned this profile is subject to the limit for this resource specified in the DEFAULT profile.
Specify DEFAULT if you want to omit a limit for this resource in this profile. When specified with a password parameter, UNLIMITED indicates that no limit has been set for the parameter. When specified with a resource parameter, UNLIMITED indicates that a user assigned this profile can use an unlimited amount of this resource. If a user attempts to perform an operation that exceeds the limit for a single call, then the database aborts the operation, rolls back the current statement, and returns an error, leaving the current transaction intact. The user can then commit or roll back the current transaction, and must then end the session.
If a user attempts to perform an operation that exceeds the limit for other session resources, then the database aborts the operation, rolls back the current statement, and immediately returns an error.
When the user process next issues a call, the database returns an error. If a user exceeds the CONNECT_TIME or IDLE_TIME session resource limit, then the database rolls back the current transaction and ends the session. Oracle Database enforces resource limits in the following ways: Use profiles to limit the database resources available to a user for a single call or a single session. Specify the name of the profile to be created. Oracle Database Reference for information on the RESOURCE_LIMIT parameterĬREATE USER and ALTER USER for information on profilesĭescription of the illustration create_profile.gifĭescription of the illustration resource_parameters.gifĭescription of the illustration password_parameters.gif ALTER SYSTEM for information on enabling resource limits dynamically
0 kommentar(er)
