Re: pga setting Oracle 9.2 recommodations?

Pete Sharman wrote:
>
> In article <o7rg9.294430$_91.360265_at_rwcrnsc51.ops.asp.att.net>, "Michael says...
> >
> >I'd say go for it.
> >I assume you are using dedicated server.For "Shared server" you would want
> >to play with
> >the SORT_AREA_SIZE, HASH_AREA_SIZE, BITMAP_SIZE MERGE_AREA_SIZE and
> >CREATE_BITMAP_AREA_SIZE parameters.
> >
> >Also, your sort_area_size looks a little small.
> >I am not much of an expert on this, so it you need a definitive answer
> >before
> >proceeding, wait for somebody more experienced to reply.
>
> Search trhough the group for my reply to a similar question on
> PGA_AGGREGATE_TARGET, and you'll probably understand why it needs to be set so
> high.
>
> Pete
> >
 

>
> HTH. Additions and corrections welcome.
>
> Pete
>
> SELECT standard_disclaimer, witty_remark FROM company_requirements;

Hello Pete and Michael,
thank you both for your input and Pete's hint for an excellent clarification why I need such a high value, link below.

http://dbforums.com/archive/49/2002/07/3/428301

Manuela Mueller Received on Sat Sep 14 2002 - 15:07:30 CDT