Re: sga_max_size discrepancy

Yes, the default granule size is 4M.

  select ksppinm, ksppdesc, kspftctxvl, kspftctxdf   from x$ksppi, x$ksppcv2
  where (x$ksppi.indx+1) = x$ksppcv2.kspftctxpn   and ksppinm = '_ksmg_granule_size';

KSPPINM KSPPDESC KSPFTCTXVL KSPFTC

------------------- ---------------------- -------------- ------
_ksmg_granule_size  granule size in bytes  4194304        TRUE

Keith

> Keith,
>
> Did you find the granule size by looking at _ksmg_granule_size? It's mostly
> determined by processes.
>
> Yong
>
>> Raj,
>>
>> Thanks. You put me on the right track but the granule size is actually 4M
>> and...
>
>
>
>

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