Re: Oracle 9i Tunning

Ignore my previous message. Got my gigabytes and megabytes muddled.

"Priyesh Patel" <priyesh_at_mercurie.co.uk> wrote in message news:afa3h7$pnc$1_at_shale.ftech.net...
> Well I am going to offer a different opinion :
>
> You have the memory so I would make the sort_area_size even bigger to say
 8
> Gb as this will optimise the speed at which the index is built.
>
> Next, when creating the index, specify an appropriate size of the initial
> and next extents. This is also a major factor in how quickly the index is
> built. Even though everything is on one raid array, it is still a good
 idea
> to have a separate tablespace for indexes.
>
> The third factor is the size of your cache. Increase the size of the cache
> to soak up excess memory but don't allocate so much that it starts
 swapping.
>
> Regards
> Priyesh Patel
> www.mercurie.co.uk
>
> "Zbrk" <zivjeli_at_veselili.se> wrote in message
> news:af949v$lej27_at_ns4.bih.net.ba...
> > Joe <joegenshlea_at_attbi.com> wrote in message
> > news:jWGR8.139109$nZ3.58300_at_rwcrnsc53...
> > >
> > > Here is what I have done so far.
> > > - Created a temporary 4GB tablespace and set it to default for the
 user
> > > account I use.
> > > - increased the sort_area_size for the session to 1GB.
> > > - specify nologging and paralell 2 in the create index DDLs
> > >
> > > Is this the best I can do to maximize sort procesess?
> > >
> > > Joe
> > >
> > It seems to me that you set sort_area_size to very large value. Yours
 two
> > parallel processes will use 2 GB of merory. Set sort_area_size to less
> > value, first try 10M and examine you report.txt. If there is lot of
 disk
> > sorts increase yours sort_are_size. I think that 1 GB is too much.
> >
> > Regards
> >
> >
> >
>
>
Received on Tue Jun 25 2002 - 18:52:51 CEST