Re: 11g

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 19 Sep 2006 23:06:29 GMT
Message-ID: <J5v475.441@igsrsparc2.er.usgs.gov>

> Are there any quick and dirty HOWTO links or FAQs that deal with
> tweaking init.ora to consume less memory without affecting performance
> drastically?
>
> Thanks

As a start, consider shrinking your SGA_TARGET parameter. This parameter will most likely be taking up the majority of your memory allocation. Also consider shrinking your PGA_AGGREGATE_TARGET parameter.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Tue Sep 19 2006 - 18:06:29 CDT