Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: need help tuning a very large delete
> 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
![]() |
![]() |