What is a profile and how to use it?

What is a profile and how to use it?

The role of group ()

 

 

In order to rationally allocate and use system resources, the Oracle system puts forward the concept of profiles. A summary file is a configuration file that describes how to use system resources (mainly CPU resources. Assign the profile to a database user. When the user connects to and accesses the database server, the system allocates resources to the user according to the profile.

In some books, it is translated as a configuration file. Its functions include.

1. Manage database system resources.

Use profile to allocate resource quotas. You must set the initialization parameter resource_limit to true.

Alter system set resource_limit = true scope = both;

2. Manage database passwords and verification methods.

By default, the user is assigned the default profile, which is assigned to each created user. However, this file has no restrictions on resources. Therefore, administrators often need
The following describes how to create and manage profiles in the environment of the data warehouse system.

Example:

Create profile pro_test
Limit cpu_per_session 1000
-- Number of CPU sessions per second
CPU time consumed by any session (the time is 1/100 seconds)
CPU _ per_call 1000
-- Number of CPU calls per second
CPU time consumed by any single database call in any session (1/100 seconds)
Connect_time 30
-- Allowed connection time
The connection time of any session is limited to a specified number of minutes.
Idle_time default
-- Allow idle time
Sessions_per_user 10
-- Maximum number of parallel sessions of a user (specify the number of sessions of a user)
Logical_reads_per_session 1000 -- read count/SESSION (unit: Block)
Logical_reads_per_call 1000 -- read count/call (unit: Block)
Private_sga 16 k -- dedicated SGA
Composite_limit 1000000 -- Combination limit (unit: Unit)
Failed_login_attempts 10 -- after several logins
Password_lock_time 10 -- lock time (unit: Day)
Password_grace_time 120 -- how many days are locked
Password_life_time 60 -- password validity period (days)
Password_reuse_max unlimited -- password retention history: Number of times (unit: Times)
Password_reuse_time 120 -- password retention history: retention time (in days)
Password_verify_function default -- Enable Password Complexity function (null or default)

Modify parameter instance:

Alter profile pro_test limit cpu_per_session 5000

Delete the profile:

Drop profile pro_test

Assign a profile to a specific user

Alter user test profile pro_test;

Change the profile to the default one.

Alter user test profile default;

View profile information

Select * From SYS. dba_profiles;

Select * From SYS. user_resource_limits;