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@xxxxxxxxxxxxxxxxx> 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 >