I would like to configure resource manager so that there will be only one active session per USER.
I succeeded in doing it per GROUP, but not per user in the database.
we have around 5000 users and I would like that when a user opens two or more sessions it will wait in queue for the third session, but other users won't wait.
anyone can help with that?
-ALTER SYSTEM SET RESOURCE_LIMIT=TRUE SCOPE=BOTH;
-create profile XXXX limit sessions_per_user 1;
-add profile to your user
Edited by: Fran on 04-dic-2012 1:23
what are you understanding by "ACTIVE" sessions?
In the user profile you can set "IDLE_TIME" or "CONNECT_TIME" if you user exceeds, the current transaction will be roll back and the session end.