RE: Queueing Connections
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <ian@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Sep 2005 10:22:15 -0700
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
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
