RE: Increasing CPU on every execution of an anonymous block sent from WebLogic
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Kerber, Andrew W.'" <Andrew.Kerber@xxxxxxx>, "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>, "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- Date: Wed, 21 Mar 2007 08:57:02 -0400
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: Kerber, Andrew W. [mailto:Andrew.Kerber@xxxxxxx]
Sent: Tuesday, March 20, 2007 3:35 PM
To: paul.baumgartel@xxxxxxxxxxxxxxxxx; Christian Antognini
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Baumgartel, Paul
Sent: Tuesday, March 20, 2007 12:42 PM
To: 'Christian Antognini'
Cc: oracle-l@xxxxxxxxxxxxx
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,
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
------------------------------------------------------------------------------
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
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
