From oracle-l-bounce@freelists.org Sat May 15 20:25:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i4G1P1N14901 for ; Sat, 15 May 2004 20:25:11 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i4G1Op614891 for ; Sat, 15 May 2004 20:25:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E902B72C0EA; Sat, 15 May 2004 20:14:11 -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 20213-07; Sat, 15 May 2004 20:14:11 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 312FC72C29F; Sat, 15 May 2004 20:14:11 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 15 May 2004 20:12:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3A69F72C0FC for ; Sat, 15 May 2004 20:12:53 -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 17492-96 for ; Sat, 15 May 2004 20:12:52 -0500 (EST) Received: from mail.cybcon.com (mail.cybcon.com [216.190.188.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6979172C016 for ; Sat, 15 May 2004 20:12:52 -0500 (EST) Received: from dsl2-6 (dsl2-6.cybcon.com [208.186.116.6]) by mail.cybcon.com (8.11.6/8.11.6) with ESMTP id i4G1SGS14021 for ; Sat, 15 May 2004 18:28:16 -0700 Subject: Re: MTS for 5,000 All-at-Once Users? From: Jared Still To: Oracle-L Freelists In-Reply-To: References: Content-type: text/plain Message-Id: <1084671263.15775.1968.camel@poirot> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sat, 15 May 2004 18:34:24 -0700 Content-Transfer-Encoding: 8bit X-CyberConnectics-MailScanner2-Information: Spam/Virus Scanned at CyberConnectics X-CyberConnectics-MailScanner2: Found to be clean X-CyberConnectics-MailScanner2-SpamCheck: X-MailScanner-From: jkstill@cybcon.com X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 650 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@cybcon.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On Sat, 2004-05-15 at 06:51, JApplewhite@austin.isd.tenet.edu wrote: > This hadn't shown up in about 18 hours, so I'm resending it. Apologies if > it's a duplicate. Problems at freelists.org - fixed now. ... > We are in the process of sizing servers for consolidating the 162 > far-flung dBase IV (go ahead and laugh, we have to - to keep from crying) Actually, this sounds like fun to me. > However, once each morning, all 5,000 Elementary teachers log on and > upload their class attendance data. The data from each teacher is only > the Student Numbers for 20 - 30 kids and the associated "Present" or > "Absent" flags, perhaps with an Absence Code. It's not much, but > multiplied by 5,000, all within probably a 10 - 15 minute span, and we ... Jack, have you investigate Advanced Queuing for this? It sounds like it might be worth prototyping. If the data doesn't have to be there immediately, this could prevent killing your server even though they they all logon at once. My guess would be that memory for all sessions in will be the least of your worries if they all hit 'COMMIT' in a short time period. :) Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------