Oracle-L: RE: Transactions per second

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 08 May 2002 15:23:38 -0800
Message-ID: <F001.0045C379.20020508152338@fatcity.com>

Where does that theoretical limit come from? We've done 15,000 tps here using OCIDirectWrite calls on a machine with 4, 450 MHz CPU's an a-1000 and some internal disks. The transactions were small about 150 bytes max. There was no network involved, and no queries were being run against the database. The 15,000 tps figure comes from our accelerator controls department which is testing Oracle's feasibility to store information on the accelerator's status.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu <mailto:ian_at_SLAC.Stanford.edu>

-----Original Message-----
Sent: Wednesday, May 08, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L

Not that it's relevant to this question, but I understand the theoretical limit is 16,384 tps. This affects the sizing of integers used for SCN base, wrap, seq# in the block headers, I guess...

Original Message ----- To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Wednesday, May 08, 2002 11:30 AM

I have a developer that asked "how many transactions per second can Oracle handle?"

I would assume that the number of transactions depends on the size of the transactions, number of CPUs, memory, etc.

Is there a guideline to follow when guesstimating something like this, or is it just trial an error to find out whether it can handle the new load?

I am running on Solaris 2.8, Oracle EE 8.1.7

Thanks for any help?

Rick Stephenson

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 08 2002 - 18:23:38 CDT