From ktoepke@cms.cendant.com Fri, 02 Mar 2001 05:40:25 -0800 From: "Toepke, Kevin M" Date: Fri, 02 Mar 2001 05:40:25 -0800 Subject: RE: How to increase the number of inserts into a table to 2000 p Message-ID: MIME-Version: 1.0 Content-Type: text/plain Ranganath: If you all you really need is fast insert performance.... 1) Drop any indexes on the table 2) Drop all of the constraints on the table -- Foreign Key -- NOT NULL 3) Drop all trigers on the table 4) Use the SQL*Loader API (or use SQL*Loader) -- ALTER TABLE xxx NOLOGGING; -- Use the Direct Path method 5) Stripe the table across as many disks as possible. Doing all of that should significantly improve the performance of your inserts. Up to 2800 inserts per second? Is that for a table with 1 column, no indexes/constraints? Stripped across how many disks? Kevin -----Original Message----- Sent: Friday, March 02, 2001 12:41 AM To: Multiple recipients of list ORACLE-L second 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@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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: ktoepke@cms.cendant.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@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).