Re: Queueing Connections

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <ian@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Sep 2005 13:28:50 -0400

Is your job as fun as it sounds? Your emails are always the coolest.
----- Original Message ----- 
From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, September 21, 2005 1:03 PM
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.
>
--
//www.freelists.org/webpage/oracle-l

Other related posts: