SGA_TARGET substantially less than SGA_MAX_SIZE ?

From: kyle Hailey <kylelf_at_gmail.com>
Date: Mon, 11 Aug 2014 13:05:10 -1000
Message-ID: <CADsdiQju=QyA_CHjfeGHLkT3WvhcBVOne7hAoTs42AU4481b9A_at_mail.gmail.com>

Is there any reason to run SGA_TARGET substantially less than SGA_MAX_SIZE?

For example is there any reason to run MAX=48GB, TARGET=12GB instead of just running MAX at say 10% over TARGET to give some wiggle room?

Another way to put it: what are the pros and cons of running SGA_TARGET substantially less than SGA_MAX_SIZE ?

Thanks
Kyle

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 12 2014 - 01:05:10 CEST