Re: 'alter system' does not alter the memory...

"Ibrahim DOGAN" <idogan_tech_at_yahoo.com> a écrit dans le message de news:6bf58828.0312230751.5a116c13_at_posting.google.com...
> version=9.2.0.1
>
> shared pool=112MB
> db_cache_size=32MB
>
> and i'm using spfile..
>
> when i try to change the shared_pool ordb_cache_size, sql plus replies
> "system altered" but the memory figures in v$parameter remains same:
>
> ========================
> SQL> alter system set shared_pool_size=100M
> System altered.
> (but shared_pool is still 112M)
>
> SQL> alter system set db_cache_size=30M
> system altered.
> (but db_cache_size is still 32 MB)
> ============================
>
> the interesting thing is that when i try to change the shared_pool to
> 90MB (or any size below 100MB) my session just hangs forever..
>
> any help would be appreciated..
>
> thanks,
> i.d.

SGA is allocated in the unit of granules. For total SGA size > 128Mb, the granule size is 16Mb. So 100Mb is rounded up to 112Mb and 30Mb to 32Mb. Cf the Administrator's Guide, "Setting Initialization Parameters that Affect the Size of the SGA", p. 2-38 to 2-41.

Regards
Michel Cadot Received on Tue Dec 23 2003 - 10:20:53 CST