RE: Increasing CPU on every execution of an anonymous block sent from WebLogic
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Christian Antognini'" <Christian.Antognini@xxxxxxxxxxxx>
- Date: Tue, 20 Mar 2007 13:41:48 -0400
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: Christian Antognini [mailto:Christian.Antognini@xxxxxxxxxxxx]
Sent: Tuesday, March 20, 2007 1:06 PM
To: Baumgartel, Paul
Cc: oracle-l@xxxxxxxxxxxxx
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
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
