Re: tunning an index build

From: genegurevich@xxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 20 Jul 2007 10:34:06 -0500

OK. Here is what I have so far..

I have increased the pga_target_area to 2.5G and it looks like when the
index build starts this is not enough  and
I can't add more right now because the server's memory is exhausted.  I
have considered rebuilding my temp
tablespace. Right now the uniform size in that tablespace is 1M and I think
it is too small.  I will also try to reduce
the parallelism on some of the tables/indices.

Does this sound reasonable or would it be better to get rid of pga and
increase the sort_area bitmap_area etc?

thank you

Gene Gurevich


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

Follow-Ups:

RE: tuning an index build
From: Mark W. Farnham

References:
- Re: tunning an index build
  - From: Fuad Arshad

Re: tunning an index build

Other related posts: