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