Forcing ASMM component to shrink 2007-12-01 - By Finn Jorgensen
Back
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@(protected)> 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
>
<div>alter system set shared_pool_size=500M scope=memory;</div>
<div>alter system set db_cache_size=600M scope=memory;</div>
<div> </div>
<div>Finn<br><br></div>
<div class="gmail_quote">On Dec 1, 2007 11:59 AM, Vishal Gupta <<a href=
"mailto:vishal@(protected)">vishal@(protected)</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-GB" vlink="purple" link="blue">
<div>
<p>Hi,</p>
<p> </p>
<p>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?
</p>
<p> </p>
<p>Cheers,</p>
<p>Vishal</p></div></div></blockquote></div><br>
|
|
