How cas we allow for each user to have 3 concurrent sessions on orcle?

Answer 1

This can be done by using a "profile"

To implement a 3 session hard limit for each user in the database, perform the following:

Login to the DB as SYS via SQLPlus

Once there run the following:

alter system set RESOURCE_LIMIT=true scope=both;

create profile sesslimit limit sessions_per_user 3;

For each user you wish to implement the new limit on you

will need to do the following:

alter user <username> profile sesslimit;