RE: ASMM Settings Help

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Fri, 10 Apr 2009 09:34:04 -0400
Message-ID: <55264C4C0484A547B34C0B1A28E219EA337AC18CC3_at_ENHBGMBX01.PA.LCL>



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_at_state.pa.us<mailto:dofreeman_at_state.pa.us>



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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_at_state.pa.us<mailto:dofreeman_at_state.pa.us>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 10 2009 - 08:34:04 CDT

Original text of this message