Re: ASH Buffer max size
Date: Thu, 16 Apr 2009 21:24:50 +0200
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/200609Johal_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.
> 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
> Is there any change in the upper ASH buffers size 11GR1 ?
> Many thanks in advance.
> Best Regards. Milen
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 16 2009 - 14:24:50 CDT
- application/pkcs7-signature attachment: smime.p7s