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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Berger Sent: Donnerstag, 16. April 2009 21:25 To: makulev@xxxxxxx Cc: oracle-l@xxxxxxxxxxxxx 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 > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l