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

This article mainly introduces "ORACLE profile management what content", in daily operation, I believe many people in ORACLE profile management what content problems exist doubt, small editor consulted all kinds of information, sorted out simple and easy to use operation method, hope to answer "ORACLE profile management what content" doubts helpful! Next, please follow the small series to learn together!

Oracle system put forward the concept of profile file in order to allocate and use system resources reasonably. A profile is a configuration file that describes how to use the system's resources (mainly CPU resources). A profile is assigned to a database user, and when the user connects and accesses the database server, the system allocates resources to him according to the profile.

Its functions include:

1. Manage database system resources.

2. Manage database password and authentication method.

By default, users are assigned the DEFAULT profile, which is assigned to each user created. However, this file has no restrictions on resources, so administrators often need to create their own profiles according to their database system environment. Here is how to create and manage profiles.

Here is a complete example sql statement for creating profiles:

CREATE PROFILE "TESTPROFILE"

LIMIT CPU_PER_SESSION 1000

CPU_PER_CALL 1000

CONNECT_TIME 30

IDLE_TIME DEFAULT

SESSIONS_PER_USER 10

LOGICAL_READS_PER_SESSION 1000

LOGICAL_READS_PER_CALL 1000

PRIVATE_SGA 16K

COMPOSITE_LIMIT 1000000

FAILED_LOGIN_ATTEMPTS 10

PASSWORD_LOCK_TIME 10

PASSWORD_GRACE_TIME 120

PASSWORD_LIFE_TIME 60

PASSWORD_REUSE_MAX UNLIMITED

PASSWORD_REUSE_TIME 120

PASSWORD_VERIFY_FUNCTION DEFAULT

Example of changing parameters:

alter profile "testprofile" limit LIMIT CPU_PER_SESSION 5000

Delete profile:

drop profile testprofile

Assign a profile to a specific user

alter user testuser profile testprofile

View profile information, query

SYS.DBA_PROFILES

SYS.USER_RESOURCE_LIMITS

SYS.USER_PASSWORD_LIMITS

At this point, on the "ORACLE profile management what content" learning is over, I hope to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.