Re: tunning an index build
- From: genegurevich@xxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 18 Jul 2007 17:45:38 -0500
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@gmail. To
com> "genegurevich@xxxxxxxxxxxx"
Sent by: <genegurevich@xxxxxxxxxxxx>
oracle-l-bounce@f cc
reelists.org oracle-l@xxxxxxxxxxxxx
Subject
Re: tunning an index build
07/18/2007 11:20
AM
Please respond to
afatkulin@xxxxxxx
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@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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
