Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Queueing Connections

Queueing Connections

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Wed, 21 Sep 2005 10:03:20 -0700
Message-ID: <7F24308CD176594B8F14969D10C02C6C8A0437@exch-mail2.win.slac.stanford.edu>


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_at_slac.stanford.edu

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 21 2005 - 12:05:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US