Home » RDBMS Server » Security » Limit Sessions per User in RAC (Oracle 9i on HP-UX)
Limit Sessions per User in RAC [message #506037] Fri, 06 May 2011 04:39 Go to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hello

The following link states
Quote:

SESSIONS_PER_USER
Each instance maintains its own SESSIONS_PER_USER count. If SESSIONS_PER_USER is set to 1 for a user, the user can log on to the database more than once as long as each connection is from a different instance.


http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/dbinstmgt.htm

Of course the following is not working even when resource_limit is TRUE
ALTER PROFILE DEFAULT LIMIT SESSIONS_PER_USER 2;


How can I restrict a user to have limited sessions say 2 sessions across 4 node cluster?

Could please suggest this for both Dedicated Connections as well as Shared Server Connections in RAC?

Presently I am checking the sessions logged in using sql+ and no connection pooling of front end etc. is involved

Thanks and Regards,
OraKaran
Re: Limit Sessions per User in RAC [message #506040 is a reply to message #506037] Fri, 06 May 2011 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 58523
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No other way than to poll gv$session and kill unwanted sessions.

Regards
Michel
Re: Limit Sessions per User in RAC [message #506041 is a reply to message #506040] Fri, 06 May 2011 04:55 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Many Thanks Michel

Regards,
OraKaran
Re: Limit Sessions per User in RAC [message #513271 is a reply to message #506041] Sat, 25 June 2011 08:42 Go to previous messageGo to next message
bignoy
Messages: 4
Registered: June 2011
Junior Member
Sirs,

as what i understand from the above statement is
when I set SESSIONS_PER_USER=5, I can use 10 connections
in RAC with 2 nodes.

If ever 1 node is down, how many sessions can I still use?

Many thanks.
Re: Limit Sessions per User in RAC [message #513282 is a reply to message #513271] Sat, 25 June 2011 13:59 Go to previous messageGo to next message
Michel Cadot
Messages: 58523
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
5, the limit is per instance.

Regards
Michel
Re: Limit Sessions per User in RAC [message #513284 is a reply to message #513282] Sat, 25 June 2011 18:27 Go to previous message
bignoy
Messages: 4
Registered: June 2011
Junior Member
Many thanks Michel

bignoy
Previous Topic: AD Creation using DBMS_LDAP - Password creation solutions
Next Topic: linux
Goto Forum:
  


Current Time: Thu Jul 24 02:07:19 CDT 2014

Total time taken to generate the page: 0.09618 seconds