Re: ASM Settings Help

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 10 Apr 2009 08:14:07 -0500
Message-ID: <ad3aa4c90904100614t6980cadaxb7462a12f4f914e2_at_mail.gmail.com>



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

-- 
Andrew W. Kerber

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

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

Original text of this message