Re: sga_max_size discrepancy

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: kmoore@xxxxxxxxxxxx
  • Date: Wed, 30 Jul 2008 18:57:56 -0400

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2008