Re: tunning an index build

From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
To: "genegurevich@xxxxxxxxxxxx" <genegurevich@xxxxxxxxxxxx>
Date: Wed, 18 Jul 2007 12:20:21 -0400

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@xxxxxxxxxxxx <genegurevich@xxxxxxxxxxxx> 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

Follow-Ups:

Re: tunning an index build
From: genegurevich

RE: tunning an index build
From: Dunbar, Norman

References:
- Re: tunning an index build
  - From: Alexander Fatkulin
- Re: tunning an index build
  - From: genegurevich

Other related posts:

Browse oracle-l