Limit the Number of Sessions per User

To prevent any one user from potentially tying up all resources, limit the number of sessions any user can open concurrently.

To do this, do one of the following:

• Create a new profile, following instructions in the Oracle Clinical Administrator's Guide section Creating a New Profile, and set SESSIONS_PER_USER to whatever number you choose. RDC Onsite users routinely use three sessions at once, so set the value to at least three. Assign the new profile to users, following instructions in the Oracle Clinical Administrator's Guide.
• Edit the DEFAULT profile that is assigned to all users by default. The DEFAULT profile initially defines unlimited resources, including for SESSIONS_PER_USER. You can change those limits with the ALTER PROFILE statement. See the Oracle Database SQL Language Reference.