Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large set-based UPDATE
f1fteen_at_hotmail.com (Paul) wrote in message news:<7b7286ec.0302130803.19f42c5e_at_posting.google.com>...
> Hi Howard, thanks for taking the time to respond. Comments embedded
> below.
>
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<pan.2003.02.12.16.57.49.61549_at_yahoo.com.au>...
> > On Wed, 12 Feb 2003 04:02:13 +0000, Paul wrote:
> >
> > In which case: how often does the bulk update happen?
>
> Every night.
>
> > Why can't it be
> > shunted off into the midnight hours so it doesn't upset your web users?
>
> It runs in the early hours and processing creeps into 9am-10am. Users
> are accessing the site at all times.
>
I would first find out what's making the procedure so slow. A good place to start is v$session_wait. The event and seconds_in_wait columns may help identify the bottleneck. Received on Fri Feb 14 2003 - 12:49:27 CST