Re: Documentation on Transaction Management

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 20 Nov 2009 10:12:58 -0800
Message-ID: <bf46380911201012he5ce95cn91605af532b93d08_at_mail.gmail.com>



I will second the recommendation for execute_array. :)

I've used it a couple times, it works quite well.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

On Fri, Nov 20, 2009 at 3:28 AM, <scoles_at_pythian.com> wrote:

> A simple perl DBD::Oracle script utilizing the
> http://search.cpan.org/~timb/DBI-1.609/DBI.pm#execute_array
>
> should only take a few momments for 10m+ records even with binding maybe
> there is something else going on like the others say you might have too
> many index or other trsanactions going on.
>
> cheers
>
>
> > How long time does it take to run the update as a single update? Sure
> > enough
> > undo would need to be allocated, but this would show if the problem is
> > with
> > the approach or with the database (number of indexes and such). It could
> > also show that the simple way actually works fast enough to do the job.
> >
> > If that turns out to be too slow, then one possible solution would be to
> > have multiple parallel jobs operate on different parts of the table.
> >
> > Can new rows be added to the table while the update runs?
> >
> > Mathias
> >
> > On Fri, Nov 20, 2009 at 3:16 AM, rjamya <rjamya_at_gmail.com> wrote:
> >
> >> 10m rows should not be more than a few minutes unless there are lots of
> >> active transactions and/or indexes. I'd try to minimize outside lookups
> >> and
> >> by scanning the table (to be updated) first, get values from lookup
> >> tables
> >> and cache them locally then run simple updates.
> >>
> >> Then again we are talking about lack of more info :)
> >>
> >> Raj
> >>
> >>
> >>
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 20 2009 - 12:12:58 CST

Original text of this message