Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need help tuning a very large delete
"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0309181125.2c738fde_at_posting.google.com...
>
>
> we tried things similiar for this and killed it after about 18 hours
> and the scary part is it died immediately. no rollback.
There will be very little rollback on an insert-select, followed by a truncate and another insert-select. We went through this about 6 months ago. So you're OK.
> We have issues
> sizing up sort_area_size because we have 8 instances on this
> server(not my call.. we just use these instances for staging so most
> of the day they are idle).
If you do the above there won't be sort at all.
> 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.
Hehehe! Make sure no one else using the system if you do that! ;)
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospamReceived on Fri Sep 19 2003 - 05:31:23 CDT