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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
