oracle12c-User profile Profiles daily operations

In the oracle12c, the user profile has added a lot of things, more practical, more powerful, the following list of daily operations often:

1, in the CDB query database in the number of profiles:

Sql> SELECT distinct profile from Dba_profiles; Profile--------------------------------------------------------------------------------Ora_stig_profiledefault

2. View the contents of the specified profile:

Sql> select resource_name,resource_type,limit from dba_profiles where profile = ' DEFAULT '; resource_name                     resource limit-------------------------------- --------composite_limit                   kernel    UNLIMITED    ----Total resource cost sessions_per_user     in a single session             kernel   unlimited     ----User Concurrent session Unlimited cpu_per_session                   KERNEL   UNLIMITED     ----A single session, the user can use the CPU time, unlimited cpu_per_call                      KERNEL   UNLIMITED    ---- User single call CPU cannot exceed 30 seconds logical_reads_per_session        kernel    UNLIMITED    -----Unlimited number of data blocks read from memory and disk in a single session logical_reads_per_call            KERNEL   UNLIMITED    ---- The user makes a single call to read the data block memory and disk limits. idle_time                         KERNEL   UNLIMITED    ---- Session idle time (minutes), exceeding will disconnect connect_time                      KERNEL   UNLIMITED    --- The limit of a single session time private_sga                       kernel   unlimited    ------ Limits the memory allocated by a single session in the SGA. Failed_login_attempts            password 10            -----The number of trial errors before being locked password_life_time                PASSWORD 180           -----Password usage days, default 180 days password_reuse_time               PASSWORD UNLIMITED    --- --Password reusable time interval (combined with Password_reuse_max) password_reuse_max                PASSWORD UNLIMITED    -----The maximum number of password changes Password_ Verify_function         password nullpassword_lock_time                PASSWORD 1             -----Number of days to be locked after the number of trial errors, default 1 days password_grace_time               PASSWORD 7             -----The number of days after password expiration to use the original password inactive_account_time             PASSWORD UNLIMITED    ----- Specifies the number of times a user account is allowed to not log in for several days, after which the account is locked. The minimum value is 15 days, and the default is infinite 17 rows selected.

3. Create a new profile, such as:

create profile test_profile limitsessions_per_user unlimited         ---User concurrent session unlimited cpu_per_session unlimited           ---A single session, the user can use the CPU time, unlimited cpu_per_call 3000                   ---User single call CPU cannot exceed 30 seconds connect_time 45                      -a single session cannot exceed 45 minutes logical_reads_per_session default  ---in a single session, The number of data blocks read from memory and disk is the limit specified in the default profile. logical_reads_per_call 1000        --- A single call made by a user cannot read more than 1000 blocks of memory and disk. private_sga 15k                     ---Limit the amount of memory that a single session can allocate in the SGA that cannot exceed 15 kb. composite_limit 5000000;           ---in a single session, the total resource cost cannot exceed 5 million service units. Note that the Test_profile name    can only be used in the PDB, if the profile is created in the CDB, the name must be #开头 in C #;

4, modify a profile, such as:

ALTER profile New_profile LIMIT password_reuse_time Password_reuse_max UNLIMITED; ALTER profile App_user LIMIT password_reuse_time DEFAULT Password_reuse_max UNLIMITED;

5. Delete a profile file:

DROP profile App_user CASCADE;

6, the daily use of profile:

①: Modifying the user's profile file in the PDB

Alter user Test_zhang profile Test_profile;

②: In the PDB, modify the file in the user's profile to CDB

Alter user Test_zhang profile C # #test_b;

This article is from the "stupid Child's DBA path" blog, please be sure to keep this source http://fengfeng688.blog.51cto.com/4896812/1949840

oracle12c-User profile profiles daily operations