Re: Oracle 9i Tunning

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 - 17:51:12 CEST