Re: MTS for 5,000 All-at-Once Users?

From: <JApplewhite_at_austin.isd.tenet.edu>
Date: Sat, 15 May 2004 21:31:02 -0500
Message-ID: <OF1B276445.E9F7D706-ON86256E96.000C8B8A-86256E96.000DD120@austin.isd.tenet.edu>

Jared,
Actually, it is fun. The approach we've come up with to centralize the Campus databases, eliminate other problems with the App, enhance security, etc., etc. - using standard database features, no code changes - are all things the Vendor has never been able to figure out. We've applied for a patent and have the Vendor very interested in getting us to teach them how we do it! It's a rare and enjoyable feeling to actually make a Vendor squirm! ;-)

Advanced Queing, eh? Never used it and only looked at it as a possible solution for our Developers to centralize error logging from their many Apps on our several databases - Autonomous Transactions across DB Links are problematic. I'll have to see if it can help us with this COTS App, for which the code is unmodifiable by us.

Thanks.

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk)
512.935.5929 (pager)

May have come a long way, but we got a long way to go.

B.W. Stevenson Notice: If you use this email nefariously, you are scum - probably criminal scum. Beware. The opinions I express herein are NOT the official policy of AISD, the City of Austin, the State of Texas, or the U.S. Government; but they probably should be.

Jared Still <jkstill_at_cybcon.com>
Sent by: oracle-l-bounce_at_freelists.org
05/15/2004 08:34 PM
Please respond to oracle-l

        To:     Oracle-L Freelists <oracle-l_at_freelists.org>
        cc: 
        Subject:        Re: MTS for 5,000 All-at-Once Users?

> 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_at_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
-----------------------------------------------------------------

Received on Sat May 15 2004 - 21:28:20 CDT