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"
--
http://www.freelists.org/webpage/oracle-l


Other related posts: