Introduction
Whenever you create a user in Oracle, A default profile is assigned to it. Profile is nothing but a set of restrictions and Settings which can be applied to one or more than one user. In oracle, you can create User Defined Profiles also. The details are following.
Creating a Profile in Oracle
CREATE PROFILE app_user LIMIT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL 3000
CONNECT_TIME 45
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL 1000
PRIVATE_SGA 15K
COMPOSITE_LIMIT 5000000;
If you then assign the app_user profile to a user, the user is subject to the following limits in subsequent sessions:
• The user can have any number of concurrent sessions.
• In a single session, the user can consume an unlimited amount of CPU time.
• A single call made by the user cannot consume more than 30 seconds of CPU time.
• A single session cannot last for more than 45 minutes.
• In a single session, the number of data blocks read from memory and disk is subject to the limit specified in the DEFAULT profile.
• A single call made by the user cannot read more than 1000 data blocks from memory and disk.
• A single session cannot allocate more than 15 kilobytes of memory in the SGA.
• In a single session, the total resource cost cannot exceed 5 million service units.
The formula for calculating the total resource cost is specified by the ALTER RESOURCE COST statement.
Thanks,
Vijay Kumar (Win)
|
No responses found. Be the first to respond and make money from revenue sharing program.
|