RE: Queueing Connections

Maybe use a profile with an appropriate sessions_per_user setting 
(http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm#15520)

Or use Resource Manager and an active session pool 
(http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dbrm.htm#5080)

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of MacGregor, Ian A.
Sent: Wednesday, September 21, 2005 10:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Queueing Connections


Is there any way to queue connection requests?  This is not for interactive 
processing, but for jobs which could take hours to days.  Here is the problem.  
We have a batch farm of several thousand machines.  A phtsicist want to process 
a million plus events.  The bach form assigns the task to a few thousand 
machines.   These machines try to log onto the database simultaneously and 
start querying.  However the database itself cannot support thousands of active 
sessions.  What is wanted is for the database to allow onto itself the number 
of sessions in can process, and the others be queued to be let on as others 
logoff.

I'm looking at shared servers.  I have always found them wanting; also, if 
thousands of processes are active simultaneously, then shared servers will not 
provide the complete answer.

Ian MacGregor
Stanford Linear Accelerator Center
ian@xxxxxxxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: