Re: Question about SGA memory allocation and sizing
From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Wed, 5 Sep 2012 21:42:46 +0100
Message-ID: <CAPMSPxNx-RTQfKZDBButESS7SQ1okdFHwykKZNsEYaWX=GnyhQ_at_mail.gmail.com>
Thanks Jed,
Those Ask Tom pages are always good to read through, my answer was really right at the end, look at v$sga_dynamic_free_memory. Also I'll check the advice views. In this particular system Oracle has been given too much memory, even though the server has over 250GB, Oracle is not as Tom has said "the only game in town". I am just checking that I am not about to shoot myself in the foot given the AMM configuration, the use of which of course means that huge pages is not an option. Thanks for the link though,it jogged my memory that using HugePages should always be considered, because it may be once this server's memory allocation is under control, I might get the time to move to an ASMM model, which I have used in other places.
Regards
Pete
Date: Wed, 5 Sep 2012 21:42:46 +0100
Message-ID: <CAPMSPxNx-RTQfKZDBButESS7SQ1okdFHwykKZNsEYaWX=GnyhQ_at_mail.gmail.com>
Thanks Jed,
Those Ask Tom pages are always good to read through, my answer was really right at the end, look at v$sga_dynamic_free_memory. Also I'll check the advice views. In this particular system Oracle has been given too much memory, even though the server has over 250GB, Oracle is not as Tom has said "the only game in town". I am just checking that I am not about to shoot myself in the foot given the AMM configuration, the use of which of course means that huge pages is not an option. Thanks for the link though,it jogged my memory that using HugePages should always be considered, because it may be once this server's memory allocation is under control, I might get the time to move to an ASMM model, which I have used in other places.
Regards
Pete
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 05 2012 - 15:42:46 CDT