Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need help tuning a very large delete
didnt realize that... its on ixora, but is it on the otn docs? that is nasty
and dangerous.
if it consumes all that ram can you get the same 'out of memory' error? and
have the transaction end?
"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message
news:3f6a148f$1_1_at_news.estpak.ee...
>
> > its gonna run all night. Tired of messing around. Ill do it in
> > parallel. but the big slow down is the sorting to temp. Its evil.
> >
> > 4.2 GB table minus a 2.5GB table then a create table as of a 1.7GB
> > table. with just 83MB of sort_area_size. if i could jack up the
> > sort_area_size to 1GB we would be fine.
>
> Remember that with parallel execution, each slave can consume up to 2x
> sort_area_size. Make sure you don't run out of memory.
> Check ixora for more information about this.
>
> Tanel.
>
>
Received on Thu Sep 18 2003 - 21:23:32 CDT