| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Increasing CPU on every execution of an anonymous block sent from WebLogic
Chris,
At this point we don't know if the use of PL/SQL has anything to do with the problem. Development is reluctant to make a change solely for diagnostic purposes if we can't support the theory. Is there any reason to believe that PL/SQL is the culprit?
Thanks,
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: Christian Antognini [mailto:Christian.Antognini_at_trivadis.com]
Sent: Tuesday, March 20, 2007 1:06 PM
To: Baumgartel, Paul
Cc: oracle-l_at_freelists.org
Subject: RE: Increasing CPU on every execution of an anonymous block sent from WebLogic
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.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 20 2007 - 12:41:48 CDT
 |
 |