Re: AWR
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: john.kanagaraj@xxxxxxxxx
- Date: Fri, 1 Sep 2006 19:06:29 -0700 (PDT)
John
How do the AWR old partitions are dropped. Is it been done thru Purge_Job
automatically created. I thought that Purge_Job is to delete old stats. ANy
idea.
TIA
Sanjay
John Kanagaraj <john.kanagaraj@xxxxxxxxx> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates
starting at 1¢/min.
Other related posts:
