CREATE PROFILE user_max_sess_profile LIMIT session_per_user 5;Once the profile has been created, assign this profile to the user:
ALTER USER scott PROFILE user_max_sess_profile;There are many other options you can configure for the profile. Please look at this document for more details.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.