Re: tunning an index build

Thanks. I do use nologging and parallel. I'll look at the sort_area_size if pga_ parameters don't help

thank you

Gene Gurevich

                                                                           
             "LS Cheng"                                                    
             <exriscer_at_gmail.c                                             
             om>                                                        To 
             Sent by:                  genegurevich_at_discover.com           
             oracle-l-bounce_at_f                                          cc 
             reelists.org              oracle-l_at_freelists.org              
                                                                   Subject 
                                       Re: tunning an index build          
             07/18/2007 12:26                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             exriscer_at_gmail.co                                             
                     m                                                     
                                                                           
                                                                           

the faster way is rebuild nologging with parallel and big sort_area_size, there isnt much you can do

thanks

--

LSC On 7/18/07, genegurevich_at_discover.com <genegurevich_at_discover.com > wrote:   Hi all:

  I think I have posted on this issue before, but I can't find my old   Emails
  so - sorry for the repeated question.
  Here is the situation. I am running oracle 9208 and have a 40G table   with
  a lot of indices - mostly bitmap
  Their sizes are under 1G. These indices take about 20 to 30 minutes to   build. That seems to be too long.
  I have just waited for 24 minutes to build a 82M index. The index is   parallelized 4 way, the table is
  parallelized 6 ways. I have 2G sga and 1.5G pga. I do see a lot of IO   waits
  (via vmstat) and I have UNIX
  team looking into that. I think I have plenty of memory and the   parallelizm
  should be enough for a small index.

  Any thoughts on what else I should look at?

  thank you

  Gene Gurevich

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 18 2007 - 17:47:04 CDT