Home » RDBMS Server » Server Administration » Limit session from each clients.
Limit session from each clients. [message #261426] Wed, 22 August 2007 10:11 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

I want to limit connection from application on each clients to not over 2 connections per clients.Is there anyway to limit connections for each clients on database level?

Pls advice.
Thanks for advance.
Chara
Re: Limit session from each clients. [message #261430 is a reply to message #261426] Wed, 22 August 2007 10:19 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
By creating an AFTER LOGON trigger
Re: Limit session from each clients. [message #261433 is a reply to message #261426] Wed, 22 August 2007 10:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use profile and set SESSIONS_PER_USER resource.

Regards
Michel
Re: Limit session from each clients. [message #261435 is a reply to message #261426] Wed, 22 August 2007 10:34 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Thanks for your response . But I use one user for all clients.
I want to limit each clients can connect to db 2 sessions.
Is the SESSIONS_PER_USER can served these?

rdgs,
chara
Re: Limit session from each clients. [message #261438 is a reply to message #261435] Wed, 22 August 2007 10:45 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

No SESSIONS_PER_USER can't give any solution of your problem.
Better to use AFTER LOGON trigger and make a ckeck on that trigger using v$session view.

Cheers
Soumen
Re: Limit session from each clients. [message #261444 is a reply to message #261435] Wed, 22 August 2007 11:05 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How do you make the difference between 2 clients if you use the same user?
The answer of this question determine the way you can do it.

Regards
Michel
Previous Topic: LRM-00109
Next Topic: Cannot able to connect my Database
Goto Forum:
  


Current Time: Sat Dec 03 18:31:26 CST 2016

Total time taken to generate the page: 0.07882 seconds