
|
[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
>
|

|