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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of MacGregor, Ian A. Sent: Wednesday, September 21, 2005 10:03 AM To: oracle-l_at_freelists.org
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_at_slac.stanford.edu
--

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 Received on Wed Sep 21 2005 - 12:22:50 CDT