RE: Increasing CPU on every execution of an anonymous block sent from WebLogic
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Alberto Dell'Era'" <alberto.dellera@xxxxxxxxx>, "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- Date: Wed, 21 Mar 2007 13:43:57 -0000
The timings are for serial execution of the block by the same connection.
The text of the block, including bind names, is identical every time.
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: Alberto Dell'Era [mailto:alberto.dellera@xxxxxxxxx]
Sent: Tuesday, March 20, 2007 3:52 PM
To: paul.baumgartel@xxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Increasing CPU on every execution of an anonymous block sent from
WebLogic
> Analysis of the trace files for the bind-variable version reveals that the
> CPU time to EXEC the anonymous block (and, to a lesser extent, its
> constituent INSERT statements) steadily increases. The first time
> through the CPU time is about 0.02 second. By the last execution
> before the timeout, the CPU time is just about 1.0 second.
> Interestingly, the logical I/O stats for each execution are quite low
> (<100 current reads and consistent reads) and quite consistent.
Are those timings for a serial execution of the block by the same connection,
or by concurrent execution by different connections ?
Is the block identical for bind variables names also ? ie
begin
insert ... values (:bind_one);
insert ... values (:bind_one);
end;
or
begin
insert ... values (:bind_one);
insert ... values (:bind_TWO);
end;
--
Alberto Dell'Era
"dulce bellum inexpertis"
==============================================================================
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:
