Re: Fasten huge index rebuild - How To ?

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Thu, 19 May 2005 05:20:06 -0700 (PDT)
Message-ID: <20050519122006.22358.qmail@web52601.mail.yahoo.com>

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 PARALLEL.

I also believe that the machines and databases where you did the test are comparable. Correct?

operations with CLOB may cause also slow index building.

When you find the root cause for you slow index creation we will easier help you.

Regards,
Zoran Martic

• Prem Khanna J <premjhere_at_gmail.com> wrote:
  > Thanx Raj , it seems he had tried that.any other
  > trick that can make it fas=
  > ter ?
  >
  > <original post>
  > Based on the timing for the domain index creation on
  > the CLOB column
  > in development database with smaller data volume
  > using parallel degree
  > of 8, I extrapolated (development database is on a
  > much smaller box
  > and I used linear extrapolation) that it will take
  > ~53 hours to create
  > the same index in production database, which is not
  > feasible to do
  > even in a weekend.
  > </original post>
  >
  > Regards,
  > Prem.
  >
  > On 5/19/05, rjamya <rjamya_at_gmail.com> wrote:
  > > normally I create large indexes in parallel and
  > then alter then to do
  > > noparallel, works for me.
  > --
  > http://www.freelists.org/webpage/oracle-l
  >
  

  ---

Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250

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

Received on Thu May 19 2005 - 08:24:46 CDT