Re: Forcing ASMM component to shrink

You will have to push some of the memory you took away from the shared pool to another memory pool. Shrinks don't do anything if the memory freed is not allocated elsewhere.

Allan

On Dec 1, 2007 10: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