RE: ASH Buffer max size

From: Milen Kulev <makulev_at_gmx.net>
Date: Thu, 16 Apr 2009 22:49:30 +0200
Message-ID: <002501c9bed4$d77eded0$867c9c70$_at_net>

Hallo Martin,
yes, the information is pretty contradictory. I will test it myself and I will post the result to the list.

Best Regards.
Milen

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Berger
Sent: Donnerstag, 16. April 2009 21:25
To: makulev_at_gmx.net
Cc: oracle-l_at_freelists.org
Subject: Re: ASH Buffer max size

Hi Milen,

a short google search brought some ambiguous informations: it's controlled by _ash_size
one formula is
Max( Min ( No. of CPU * 2 M, 5% of SHARED_POOL_SIZE, 2% of SGA_TARGET) ,1M) -
http://www.nyoug.org/Presentations/2006/September_NYC_Metro_Meeting/200609Jo hal_Oracle10gs%20As.pdf
.
another: max (min (#of CPUs * 2MB, 5% of SHARED_POOL_SIZE, 30MB), 1MB) -
http://www.mhprofessional.com/downloads/products/007222729X/007222729X_chp09 .pdf

both seem to be about 10g.

Currently I have no informations if there are any changes in 11g, sorry.

happy testing with _ash* parameters.

hth,
  Martin

>
> Hallo Listers,
> I have s simple question:
> What is the maximum size if ASH buffers.
> Some documents say it is 30Mb, other documents say it is 128MB (for
> 10GR2).
>
> Is there any change in the upper ASH buffers size 11GR1 ?
>
> Many thanks in advance.
>
> Best Regards. Milen
> --
> http://www.freelists.org/webpage/oracle-l
>

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

Received on Thu Apr 16 2009 - 15:49:30 CDT