Re: AWR

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Fri, 1 Sep 2006 15:20:12 -0700 (PDT)
Message-ID: <20060901222012.18398.qmail@web51305.mail.yahoo.com>

Thanks John for the quick Update

John Kanagaraj <john.kanagaraj_at_gmail.com> wrote: Sanjay - These buffers (both ASH and AWR) are allocated from the shared_pool so this is from "Variable Size" in V$SGA.

Determining how much *AWR* requires in the SGA takes a little guesswork. The space names are a little vague and the picture is complicated since AWR seems to have been known earlier as SWRF (Statistics Workload Repository Facilities - See Metalink Note 240052.1 - first few lines). Look for anything with both AWR and SWRF in the V$SGASTAT.NAME column.

Thanks for your kind words.
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is always inevitable; Discouragement is invariably optional

The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

On 9/1/06, Sanjay Mishra wrote:
>
> John
>
> THis is an excellent update as It is more clear now. Can you also update as
> this portion of SGA comes from fixed Area of SGA. Also AWR stats are also
> stored in SGA and how the space is allocated for it.
>
> I am going to buy this Insider books tomorrow as it look like had greate
> review by everybody on Amazon
>
> TIA
> Sanjay
>
>
>

How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.

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

Received on Fri Sep 01 2006 - 17:20:12 CDT