Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [12-2007 Date Index] [Date Next] || [Thread Prev] [12-2007 Thread Index] [Thread Next]

Re: Forcing ASMM component to shrink

  • From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
  • To: vishal@xxxxxxxxxxxxxxxxx
  • Date: Sat, 1 Dec 2007 17:01:53 -0500
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
>




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.