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

2001-03-02 Thread C.S.Venkata Subramanian
Hi u can try the bulk binding feature of Oracle 8i, U can reduce a lot of time in inserts update and delete. -- On Thu, 01 Mar 2001 21:41:03 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

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

2001-03-01 Thread Ranganath K
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