Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Increasing CPU on every execution of an anonymous block sent from WebLogic

RE: Increasing CPU on every execution of an anonymous block sent from WebLogic

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 20 Mar 2007 18:06:02 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAFA8EF93@MSXVS04.trivadis.com> 





Hi Paul



> Each block contains 15 to 20 or more inserts. A similar

> implementation in a London database showed significant

> performance improvement when they moved from issuing

> inserts individually to batching them into an anonymous

> block. 




What about the batching functionalities of JDBC? 
With so much inserts it seams the obvious way to go...




Regards,


Chris

--
http://www.freelists.org/webpage/oracle-l


Received on Tue Mar 20 2007 - 12:06:02 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US