Re: SGA Tuning and The Memory Advisor

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 26 Oct 2007 11:08:43 GMT
Message-ID: <4721cabb$0$19877$79c14f64@nan-newsreader-07.noos.net>

On Oct 25, 3:42 pm, cptkirkh <kh..._at_scic.com> wrote:

>> Wehn I run the ADDM/AWR in TOAD it keeps returning the following report
>> that my SGA is not large enough. I have the sga_target to a number
>> higher than that

Did you really mean sga_target here? Or is it sga_max_size?

>> I thought that on a 10g, actually it is 10.2.0.3 on windows 2003, that
>> by setting the sga_target it turns on the SGA automated memory
>> management and will adjust the SGA if it needs more up to the
>> sga_max_size number.

No. The sizes of the *pools* inside the SGA are automatically adjusted and their sum is sga_target.

You can increase sga_target dynamically up to sga_max_size (this is the shared memory size allocated from the OS at instance startup and you cannot change it dynamically.) Received on Fri Oct 26 2007 - 06:08:43 CDT