Re: alter index rebuild online

From: Terry Sutton <terrysutton_at_usa.net>
Date: Thu, 6 Oct 2005 16:38:41 -0700
Message-ID: <018201c5cacf$69f51e80$61f5a8c0@TerrySutton>

That's better, right?

BTW, if you use a large sort area, it may be even faster (alter session set sort_area_size=2000000000;). Naturally assumes you have enough RAM on the server to do this without causing swapping.

--Terry

  no parallel: 42 minutes
  with parallel 3: 29 minutes

  Thanks

---

  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu   Sent: Thursday, October 06, 2005 3:08 PM   To: mark.powell_at_eds.com; oracle-l_at_freelists.org   Cc: mkurth_at_wfs-ops.org
  Subject: RE: alter index rebuild online

  I will try parallel as Mike Kurth suggested. Thank you all.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 06 2005 - 18:44:27 CDT