Re: Running time of index rebuild

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Wed, 05 Jun 2013 11:33:12 -0600
Message-ID: <51AF7658.7000401_at_gmail.com>

As usual with Oracle, the only answer is 'It Depends'. A lot of variables to consider:

• number of rows involved
• number of blocks that need to be read
• size (bytes) of each component of the index
• since it involves a sort, size of PGA for the rebuilding session
• speed of TEMP tablespace when PGA needs to spill
• is Parallel used (available?)
• other resources being used that might lead to lock/latch/mutex contention

and so on.

There is a lot of good discussion on the OTN Forum at https://forums.oracle.com/forums/thread.jspa?messageID=4269655 including links that may be helpful.

/Hans

On 05/06/2013 8:56 AM, Ingrid Voigt wrote: > Hi, does anybody know how the running time for index create or rebuilds > inOracle changes withnumber of lines / table size?

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 05 2013 - 19:33:12 CEST