RE: ASH Buffer max size

  • From: "Milen Kulev" <makulev@xxxxxxx>
  • To: "'Martin Berger'" <martin.a.berger@xxxxxxxxx>
  • Date: Sat, 18 Apr 2009 20:51:29 +0200

Hello Martin,
it seems that the upper limit of _ash_size is 250MB (on 10g and 11g). I have
tested it on OEL5.3 with 10.2.0.4 and 11.1.0.7 (1CPU ;( only )
The parameter _ash_size is set as requested , but the real value of the
buffer is limited to 250MB
 
SQL>   select  POOL , NAME , BYTES   from  V$SGASTAT where NAME='ASH
buffers' ;

POOL         NAME                            BYTES
------------ -------------------------- ----------
shared pool  ASH buffers                 266338304

This result is independent of Oracle shared memory management discipline
(AMM or ASMM)

HTH. Milen 

-----Original Message-----
From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx] 
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
> --
> http://www.freelists.org/webpage/oracle-l
>


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


Other related posts: