Overview of Oracle profiles

The overview file of Oracle is also called a resource file. It is a concept proposed by Oracle to rationally allocate and use system resources. When a DBA creates a user, Oracle automatically creates an associated default profile for the user. The profile contains a set of constraints and configuration items that can restrict resources that can be used by users. The profile mainly limits the following indicators of the database system. 1) User's maximum number of concurrent sessions (SESSION_PER_USER) 2) CPU clock limit for each session (CPU_PER_SESSION) 3) CPU clock limit for each call, calls include parsing, executing commands, and obtaining data. (CPU_PER_CALL) 4) maximum connection time. After the connection time of a session exceeds the specified time, Oracle will automatically disconnect (CONNECT_TIME) 5) the maximum idle time. If a session is idle for more than the specified time, Oracle will automatically disconnect (IDLE_TIME) www.2cto.com 6) the maximum number of data blocks that each session can read (LOGICAL_READS_PER_SESSION) 7) the maximum number of data blocks that can be read by each call (LOGICAL_READS_PER_CALL) 8) the maximum capacity of the SGA private region (PRIVATE_SGA) profile defines and limits the password as follows: 1) maximum number of failed logon attempts (FAILED_LOGIN_ATTEMPTS) 2) Maximum Password validity period (PASSWORD_LIFE_TIME) 3) Number of times the password must be modified before it can be reused (PASSWORD_REUSE_MAX) 4) the number of days (PASSWORD_REUSE_TIME) required before the password can be reused 5) after the maximum number of failed logon attempts is exceeded, the number of days for the account to be locked 6) specify the name of the function used to determine the password complexity. After the profile is specified, the DBA can manually assign the profile Each user. However, the profile does not take effect immediately. Instead, the profile takes effect only after the parameter RESOURCE_LIMIT in the initialization parameter file is set to TRUE.