| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to restrict the user connections
Use number of processes .... but count for whatever oracle process plus 20 user sessions ...
Raj
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Senthil Kumar
Sent: Thursday, March 18, 2004 10:18 AM
To: oracle-l_at_freelists.org
Subject: RE: How to restrict the user connections
Hi Tim,
This is to test our internal applications. We don't want to allow all the users to access the web application all the time. In some time period we want to give access to only 15-20 users.
Now I'm using license_max_sessions, I want to know any other way to do this better.
Regards,
Senthil.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Johnston
Sent: Thursday, March 18, 2004 8:43 PM
To: oracle-l_at_freelists.org
Subject: Re: How to restrict the user connections
Senthil... You'll get a bunch of answers to this question but it seems to me that you have a underlying problem and you've decided to solve it by limiting the database to only 20 users... So, what's the underlying problem you're trying to solve? Is this a license issue? A technical issue? You'll probably get better answers that way...
Tim
Davey, Alan wrote:
>Hi,
>
>Create a logon trigger that checks the number of sessions, and if more than
>20 exists, it will randomly select one and kill it. The idea being that
>that user has probably been on long enough and needs to learn to share
>resources.
>
>Alternatively, you can set license_max_sessions in your init.ora file.
>
>-----------------------------------------
>Alan Davey
>Senior Analyst/Project Leader
>Oracle 9i OCA; 3/4 OCP
>w) 973.267.5990 x458
>w) 212.295.3458
>
>
>
>-----Original Message-----
>From: Senthil Kumar [mailto:senthilkumard_at_summitworks.com]
>Sent: Thursday, March 18, 2004 9:28 AM
>To: oracle-l_at_freelists.org
>Subject: How to restrict the user connections
>
>
>Hi List,
>
>How do I restrict the number of user connections. I want only 20 users to
>access the database on a particular time.
>
>How do I do this.
>
>TIA
>Senthil.
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
>"This information in this e-mail is intended solely for the addressee and
>may contain information which is confidential or privileged. Access to
this
>e-mail by anyone else is unauthorized. If you are not the intended
>recipient, or believe that you have received this communication in error,
>please do not print, copy, retransmit, disseminate, or otherwise use the
>information. Also, please notify the sender that you have received this
>e-mail in error, and delete the copy you received."
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
-- Regards, Tim Johnston Tel: 978-322-4226 Fax: 978-322-4100 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Mar 18 2004 - 11:14:44 CST
 |
 |