| Limit Sessions per User in RAC [message #506037] |
Fri, 06 May 2011 04:39  |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
