Alexander, I'll see if I can do it next couple of days.
It's very busy here.
On 3/14/07, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
> 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
>
--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 14 2007 - 20:01:35 CDT
