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.