RE: MTS for 5,000 All-at-Once Users?
- From: Riyaj Shamsudeen <rshamsud@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 15 May 2004 15:42:46 -0500
Hi Jack
I guess, we need more details about the architecture. Is this a
3tier architecture? If yes, how does your middle tier handles the DB
connections ? You say "Upload", does it mean some kind of file upload
takes place and another process processes the files ?
Assuming 2tier connections without any connection pooling, MTS
might be a way to go. Process creation/death for 5000 connections in 20
minutes might be suboptimal with dedicated server approach.
30 students/5000 users approximately turns to 150000 DML
statements within 20 minutes.Approximately 7500 DML statements/minute. I
would venture to guess that 4 CPUs@3GHz should be able to handle that.
You might want to reduce the work during that 20 minutes with variety of
approaches such as:a) preinserting data and updating only the students
who are absent b) bulk DML statements, c)With increased concurrency on
the objects d)Avoiding log switches during that 20 minutes e) Use of
bind variables f) avoiding space management calls etc.
HTH
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
JApplewhite@xxxxxxxxxxxxxxxxxxxx
Sent: Saturday, May 15, 2004 8:51 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: MTS for 5,000 All-at-Once Users?
This hadn't shown up in about 18 hours, so I'm resending it. Apologies
if
it's a duplicate.
...
Oracle 9.2.0.4 on Linux.
Anyone have experience with using MTS for handling a flood of about
5,000
simultaneous 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)
Campus "databases" of our COTS Student Information System into four
central Oracle databases. We'll have one 9i database each for High
Schools, Middle Schools, Elementaries, and Other (Summer Schools,
special
Campuses, etc.).
Without going into all the gory details, we see our biggest performance
challenges as the times when most all teachers record attendance for
their
classes. Most of the time, there is a relatively small number of Campus
Clerks and Registrars entering enrollments, withdrawals, transfers, etc.
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
think the Elementary database will be hit pretty hard. The second big
hit
will be the hourly attendance uploaded from High Schools and Middle
Schools, but that's fewer teachers and it's spread across two
databases/servers.
I've RTFM and searched MetaLink, but can't seem to find a minimal memory
requirement for a "bare bones" MTS connection. I've got a test database
and have attempted to make multiple MTS connections to try to measure it
myself, but only the connection in which I issue the query shows as
SERVER
= SHARED in V$Session, all the rest show NONE.
Would 16GB of RAM and 2 or 4 CPUs (3GHz) handle 5,000 smallish MTS
connections? Or is MTS not even the way to go, given that it's a
simultaneous flood? How about Connection Pooling - Yay or Nay?
BTW, in case you think our LAN/WAN might be a problem, it won't. We
have
an extremely fast fiber network linking all our Campuses and the
District
office. Our infrastructure is really great - robust, reliable, and
never
a bottleneck. We have gigabit connections from our WAN to the DB
Servers.
TIA for any advice on this.
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
-- Attached file included as plaintext by Ecartis --
-- Desc: Signature
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
