Re: ASM Settings Help
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: dofreeman@xxxxxxxxxxx
- Date: Fri, 10 Apr 2009 08:14:07 -0500
Do you mean for the ASM instance? Those settings are probably fine for ASM.
On Fri, Apr 10, 2009 at 8:10 AM, Freeman, Donald <dofreeman@xxxxxxxxxxx>wrote:
> 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:
