Re: ASM Settings Help

From: Andrew Kerber <>
Date: Fri, 10 Apr 2009 08:14:07 -0500
Message-ID: <>

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 <>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
> ** <>

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Fri Apr 10 2009 - 08:14:07 CDT

Original text of this message