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: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 19 Sep 2003 20:31:23 +1000
Message-ID: <3f6add0d$0$13416$afc38c87@news.optusnet.com.au>


"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.nospam
Received on Fri Sep 19 2003 - 05:31:23 CDT

Original text of this message

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