Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: need help tuning a very large delete

Re: need help tuning a very large delete

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Thu, 18 Sep 2003 23:24:46 +0300
Message-ID: <3f6a148f$1_1@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 - 15:24:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US