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

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 21 Mar 2007 08:57:02 -0400
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC1663BFC6@ENYC11P32005.corpny.csfb.com>

No, the commit is after all (several hundred) inserts are complete.

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: Kerber, Andrew W. [mailto:Andrew.Kerber_at_umb.com] Sent: Tuesday, March 20, 2007 3:35 PM
To: paul.baumgartel_at_credit-suisse.com; Christian Antognini Cc: oracle-l_at_freelists.org
Subject: RE: Increasing CPU on every execution of an anonymous block sent from WebLogic

Are the committing? Are they releasing their cursor?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Baumgartel, Paul Sent: Tuesday, March 20, 2007 12:42 PM
To: 'Christian Antognini'
Cc: oracle-l_at_freelists.org
Subject: 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,

-----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

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

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



------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

==============================================================================


==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

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

Received on Wed Mar 21 2007 - 07:57:02 CDT