From oracle-l-bounce@freelists.org Wed Sep 21 12:21:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8LHL6PE005544 for ; Wed, 21 Sep 2005 12:21:06 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8LHL16H005518 for ; Wed, 21 Sep 2005 12:21:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CB1571EE37C; Wed, 21 Sep 2005 12:20:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18643-10; Wed, 21 Sep 2005 12:20:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 50DCE1EE47E; Wed, 21 Sep 2005 12:20:48 -0500 (EST) Message-ID: <433195FA.7060000@pacbell.net> Date: Wed, 21 Sep 2005 10:18:50 -0700 From: Mark Bole User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: oracle-l@freelists.org Subject: Re: Queueing Connections References: <7F24308CD176594B8F14969D10C02C6C8A0437@exch-mail2.win.slac.stanford.edu> In-Reply-To: <7F24308CD176594B8F14969D10C02C6C8A0437@exch-mail2.win.slac.stanford.edu> Content-Type: text/plain; charset=us-ascii; format=flowed X-archive-position: 25752 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: makbo@pacbell.net Precedence: normal Reply-To: makbo@pacbell.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 MacGregor, Ian A. wrote: > 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 ot provide the complete answer. > Consider Resource Manager (requires Enterprise Edition -- you didn't state your version). "[Resource Manager allows you to] create an active session pool. This pool consists of a specified maximum number of user sessions allowed to be concurrently active within a group of users. Additional sessions beyond the maximum are queued for execution, but you can specify a timeout period, after which queued jobs will terminate." -- Mark Bole http://www.bincomputing.com -- http://www.freelists.org/webpage/oracle-l