Re: sga_max_size discrepancy
- From: "Keith Moore" <kmoore@xxxxxxxxxxxx>
- To: "Yong Huang" <yong321@xxxxxxxxx>
- Date: Thu, 31 Jul 2008 11:38:00 -0500 (CDT)
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...
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
