This content has been marked as final. Show 3 replies
-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
Thanks, this is very helpful,
but sessions per user is not ACTIVE sessions right?
is there a way to limit active sessions only?
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.