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
