ASM Settings Help
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 10 Apr 2009 09:10:37 -0400
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<mailto:dofreeman@xxxxxxxxxxx>
Other related posts:
