Re: sga_max_size discrepancy
From: rjamya <rjamya_at_gmail.com>
Date: Wed, 30 Jul 2008 18:57:56 -0400
Message-ID: <9177895d0807301557qa999718nb7746d4359a3cce3@mail.gmail.com>
Date: Wed, 30 Jul 2008 18:57:56 -0400
Message-ID: <9177895d0807301557qa999718nb7746d4359a3cce3@mail.gmail.com>
Keith,
do you have 4 CPUs? then it might make sense because in absence of sga_target setting, db_cache_size will default to 4mb * #cpus * granule size.
I am guessing granule size as 16M so, if you have 4cpus, the min db_cache_size will be 256m (or 8 cpus if granule size is 8m).
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 30 2008 - 17:57:56 CDT