Re: ASMM Settings Help
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: dofreeman@xxxxxxxxxxx
- Date: Fri, 10 Apr 2009 08:43:27 -0500
Oh, that makes more sense. First I would look and see what the AWR report says in the memory advisors section. A general rule of thumb for a dedicated Oracle server is Oracle can have about 75% of the memory on the box in whatever combination is best. If it is a data warehouse, you generally want a larger PGA. If it is an OLTP system, you generally want a larger sga_target/sga_max_size. On Fri, Apr 10, 2009 at 8:34 AM, Freeman, Donald <dofreeman@xxxxxxxxxxx>wrote: > Ouch, I'm sorry I mean Automatic Shared Memory Management "not" ASM. > > Donald Freeman > Database Administrator II > Commonwealth of Pennsylvania > Department of Health > Bureau of Information Technology > 2150 Herr Street > Harrisburg, PA 17103 > dofreeman@xxxxxxxxxxx > > > > ------------------------------ > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Freeman, Donald > *Sent:* Friday, April 10, 2009 9:11 AM > *To:* ORACLE-L > *Subject:* ASM Settings Help > > I have a vendor supplied Oracle 10G system on Windows 2003 server with > 32G of RAM. This system is only using 1.25G for the SGA and 400M for the > PGA. I'm in management now (snooping around) but I strongly suspect we > can do better than that. What would be the optimal settings for these? I > have been doing some reading in the manual and it looks like I (somebody) > just needs to set the SGA_MAX_SIZE, SGA_TARGET, and PGA aggregate target > appropriately. Am I on the right track? I'm a bit ticked that all that > expensive memory is sitting their inactive. I can't change it until I talk > to the vendors but I want my ducks lined up. > > Donald Freeman > Database Administrator II > Commonwealth of Pennsylvania > Department of Health > Bureau of Information Technology > 2150 Herr Street > Harrisburg, PA 17103 > *dofreeman@xxxxxxxxxxx* <dofreeman@xxxxxxxxxxx> > > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'
Other related posts:
- » RE: ASMM Settings Help - Freeman, Donald
- » Re: ASMM Settings Help - Andrew Kerber