Re: Update

Ranko,

do you have 10046 trace at level 8 (or 12) for both processes available?

It would be interesting to have a look at tkprof results.

On 3/14/07, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
> Timings:
> merge: 1.5 hours
> cursor loop/update: 1 hour
> for ... loop
> update
> end loop;
>
> Seems lime merge is slower in this case.
>

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l