Re: tunning an index build

Oops. Thank you. I have corrected that. I'll check and see if there is any improvement

thank you so much

Gene Gurevich

                                                                           
             "Alexander                                                    
             Fatkulin"                                                     
             <afatkulin_at_gmail.                                          To 
             com>                      "genegurevich_at_discover.com"         
             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 11:20                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             afatkulin_at_gmail.c                                             
                    om                                                     
                                                                           
                                                                           

No,

the pga_aggreagte_target is *only* relevant if you have workarea_size_policy=auto.

What you have done is used the defaults for *_area_size which are quite small.

On 7/18/07, genegurevich_at_discover.com <genegurevich_at_discover.com> wrote:
> Alex,
>
> Yes, I have set pga_aggregate_target to 1.5G and workarea_size_policy is
> manual. I thought that this will make
> the sort_area_size (and all other area_size parameters) unused. IS that
not
> the case?
> I am also working with the UNIX team to address the I/O contention that I
> am seeing.
>
> thank you for your input
>
>
>
> Gene Gurevich

--
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf/
--
http://www.freelists.org/webpage/oracle-l






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