• From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: Anjo Kolk <anjo.kolk@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 1 Sep 2006 13:20:47 -0700 (PDT)

  I was in hotsos and attended Graham Wood Presentation, where he mentioned 
that ASH is bascially  2M Per CPU, < 5%  of Shared Pool , 2% of SGA_TARGET  and 
it is fixed for the life of Instance. Now what I am trying to understand is 
that AWR consist of 
  In memeory Stat ( Comes from SGA) and WorkLoad Repository ( comes from SYSAUX)
  In Memory Stats itself comprises of ASH and AWR Stats. ASH comes from SGA and 
it is allocated as per previous values, then how the space is allocated to AWR 
Stats. Is there an algorithm for it like ASH

Anjo Kolk <anjo.kolk@xxxxxxxxxxx> wrote:
  Strictly speaking AWR is STATSPACK++, so in a way it is only the schema on 
disk with some PL/SQL packages + some background process doing the loading. The 
data being stored comes from different places, one of them is the ASH memory. 
ASH is sized based on a formula that I have seen, but since then forgotten as 
it is a circular buffer. The memory for this buffer is allocated from the 
Variable Part of the SGA not the Fixed Part. 
  On 9/1/06, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:       AWR consists of 
In-Memory Stats and Workload Repository. Can somebody tell me as how much area 
in SGA is allocated to In-memory stats or is there any %age of total SGA or 
like. Is it been allocated from Fixed SGA.


  Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates 
starting at 1¢/min.   

Anjo Kolk
Owner and Founder OraPerf Projects
tel:    +31-577-712000
mob: +31-6-55340888 

Do you Yahoo!?
 Get on board. You're invited to try the new Yahoo! Mail.
  • Follow-Ups:

Other related posts: