Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Updating info
Also probably not without being able to consider the table structures, especially including the indexes on the two tables. You could also be getting into nasty things like disk i/o issues (are both tables on the same disk along with the indexes, other active tables and the other Oracle files?) In other words this is a tuning question and tuning something like this can sometimes be resolved in minutes, but sometimes only over the course of days. So we would need much more information. Sorry!
Rich Mycroft, Oracle, Sybase & SQL Server DBA.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:960995303.21239.0.pluto.d4ee154e_at_news.demon.nl...
> Not without the actual code.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> "Deborah Carter" <dcarter_at_cnfei.com> wrote in message
> news:ckL15.3249$L4.4638577_at_firenze.visi.net...
> > I am trying to increase the speed of a procedure that updates
information
in
> > a very large table according to changes made to a smaller table. The
> > procedure is taking almost half an hour. I've tested the select
statements
> > in the cursors I'm using and that portion seems to only take 1 1/2
minutes.
> > I believe the consumption of time is in checking the data before
updating
> > and the update itself. Does anyone have any suggestions on how to make
this
> > part faster. All help is appreciated. Thanks.
> >
> > Deborah Carter
> > Developer
> >
> >
>
>
Received on Fri Jun 16 2000 - 00:00:00 CDT