Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fasten huge index rebuild - How To ?
Would you tell us on which database event you are spending the majority of the time?
There are many scenarious there that can lead to slow index build.
One of these is inappropriate level of parallelism. I assume you have 8 CPU's on that test machine?
Usual suspects are log file sync - you can try to use NOLOGGING option together with
Discover Yahoo!
Get on-the-go sports scores, stock quotes, news and more. Check it out!
http://discover.yahoo.com/mobile.html
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 19 2005 - 08:21:12 CDT
![]() |
![]() |