Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Tue Mar 20 2007 - 14:51:33 CDT
![]() |
![]() |