How to increase the number of inserts into a table to 2000 per second

From: Ranganath K <ranganathk_at_subexgroup.com>
Date: Thu, 01 Mar 2001 22:03:58 -0800
Message-ID: <F001.002C1C62.20010301214103@fatcity.com>

Dear DBA Gurus

I am using Oracle 8.1.6 Work group server on Sun Solaris 2.8. I want to increase the number of inserts into a particular table per second to 2000 per second. Sun Microsystems claims that with the current hardware configuration the number of inserts can go upto 2800 per second. Currently it is only 600 per second. The insertion is done through a C program using OCI with an embedded SQL statement. I am using a SunE4500 machine with 130 gb hard disk, 4gb RAM and 4 Sparc CPU machine. Please let me know as to how do I increase the number of inserts into that table as we require to implement the same into our application. Any help in this regard will be higly appreciated.

TIA and regards,

Ranganath

--

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

Author: Ranganath K
INET: ranganathk_at_subexgroup.com

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 Fri Mar 02 2001 - 00:03:58 CST