ok all experts out there, thats a first, i've never seen a hardware vendor say "you can only do max of 2800 inserts/second". I'l assume thats based on MIPS or would someone kindly explain that one. thanks, joe Ranganath K wrote: > > 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 > > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
