Re: Forcing ASMM component to shrink

alter system set shared_pool_size=500M scope=memory; alter system set db_cache_size=600M scope=memory;

Finn

On Dec 1, 2007 11:59 AM, Vishal Gupta <vishal_at_vishalgupta.co.uk> wrote:

> Hi,
>
>
>
> Does anyone know if there is any way to force ASMM memory component to
> shrink. Eg. Instance has just been bounced and say shared pool is using 1GB
> and db_cache is using only 100MB. If one wanted to forcibly shrink shared
> pool without bouncing the instance, is there any way to do this?
>
>
>
> Cheers,
>
> Vishal
>

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