Shulou(Shulou.com)05/31 Report--

Editor to share with you what are the daily operations of the user profile profile in Oracle12C. I hope you will gain something after reading this article. Let's discuss it together.

In Oracle12C, a lot of things have been added to the user profile, which is more practical and more powerful. Here is a list of daily operations:

1. Query the number of profile in the database in CDB:

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-in a single session Total resource cost SESSIONS_PER_USER KERNEL UNLIMITED-user concurrent session unlimited CPU_PER_SESSION KERNEL UNLIMITED-CPU time that users can use in a single session Unlimited CPU_PER_CALL KERNEL UNLIMITED-users cannot call CPU for more than 30 seconds LOGICAL_READS_PER_SESSION KERNEL UNLIMITED-the number of blocks read from memory and disk in a single session is unlimited LOGICAL_READS_PER_CALL KERNEL UNLIMITED-the limit of block memory and disk read by a single call made by the user. IDLE_TIME KERNEL UNLIMITED-session idle time (minutes), exceeding the limit of CONNECT_TIME KERNEL UNLIMITED to be disconnected-a single session time limit PRIVATE_SGA KERNEL UNLIMITED-limits the memory allocated by a single session in the SGA. FAILED_LOGIN_ATTEMPTS PASSWORD 10-number of attempts and errors before being locked PASSWORD_LIFE_TIME PASSWORD 180-password usage days Default 180d PASSWORD_REUSE_TIME PASSWORD UNLIMITED-password reusable interval (combined with PASSWORD_REUSE_MAX) PASSWORD_REUSE_MAX PASSWORD UNLIMITED-maximum number of password changes PASSWORD_VERIFY_FUNCTION PASSWORD NULLPASSWORD_LOCK_TIME PASSWORD 1-number of days locked after exceeding the number of trial and error Default 1 day PASSWORD_GRACE_TIME PASSWORD 7-the number of days after the password expires and the original password can be used INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED-specifies the number of times the user account is allowed not to log in for several consecutive days, after which the account will be locked. The minimum value is 15 days, and the default is unlimited 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-CPU time that users can use in a single session Unlimited CPU_PER_CALL 3000-users cannot call CPU for more than 30 seconds CONNECT_TIME 45-a single session cannot exceed 45 minutes LOGICAL_READS_PER_SESSION DEFAULT-the number of blocks read from memory and disk in a single session 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 disks. PRIVATE_SGA 15K-restricts a single session to allocate no more than 15 kb of memory in SGA. COMPOSITE_LIMIT 5000000;-the total resource cost cannot exceed 5 million service units in a single session. Note that the test_profile name can only be used in pdb. If you create a profile in cdb, the name must start with clocked #

4. Modify a profile, such as:

ALTER PROFILE new_profile LIMIT PASSWORD_REUSE_TIME 90 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. Daily use of profile:

①: modify a user's profile file in pdb

Alter user test_zhang profile test_profile

②: in pdb, modify the user's profile to a file in cdb

Alter user test_zhang profile c##test_b

After reading this article, I believe you have a certain understanding of "what are the daily operations of the user profile profile in Oracle12C". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.