Multiple choice technology databases

The database users are connecting the PROD database from different applications thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connection to be the reason for low performance and ask you to restrict the number of concurrent connections per database user to one. Which action would you take to achieve this objective?

  1. Set the SESSION to 1 in the parameter file.

  2. Grant SINGLE SESSION privileges to all of the users.

  3. Set SESSION_PER_USER to 1 in user’s profile.

  4. Grant RESTRICTED SESSION to all of the database users.

  5. Create a role with SINGLE SESSION privilege and assign the role to users.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To restrict the number of concurrent sessions per user to one, you should set the SESSIONS_PER_USER resource limit to 1 within the user's assigned profile and ensure resource limits are enabled.

Keep practicing — related questions