DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=qw76MN7khqouotbDpNQaBuxvSrxllPfAPRVleHTd6S6YdMmdoyXyQY3GOstvhP31NKPByNI0rFwT/FQ18hZGugou3/SvnDTmI39AKNoQUC6Y+6GetwLCngF12l6saWiV+NRCRDXg5siwFIy46OFDIyFRyIy1bAE40tbxmVfjb78=
Message-ID: <74f79c6b0712011401lbb67f1au8fbe8846e1095087@mail.gmail.com>
Date: Sat, 1 Dec 2007 17:01:53 -0500
From: "Finn Jorgensen" <finn.oracledba@gmail.com>
To: vishal@vishalgupta.co.uk
Subject: Re: Forcing ASMM component to shrink
Cc: oracle-l@freelists.org
In-Reply-To: <!&!AAAAAAAAAAAYAAAAAAAAAO+aDPcFfUxLk96N633irQxiggAAEAAAAATM/S/M9DZOuvvFD5O59W4BAAAAAA==@vishalgupta.co.uk>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_4149_12526248.1196546513486"
References: <!&!AAAAAAAAAAAYAAAAAAAAAO+aDPcFfUxLk96N633irQxiggAAEAAAAATM/S/M9DZOuvvFD5O59W4BAAAAAA==@vishalgupta.co.uk>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: finn.oracledba@gmail.com
------=_Part_4149_12526248.1196546513486
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_4149_12526248.1196546513486
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>alter system set shared_pool_size=500M scope=memory;</div>
<div>alter system set db_cache_size=600M scope=memory;</div>
<div>&nbsp;</div>
<div>Finn<br><br></div>
<div class="gmail_quote">On Dec 1, 2007 11:59 AM, Vishal Gupta &lt;<a href="mailto:vishal@vishalgupta.co.uk">vishal@vishalgupta.co.uk</a>&gt; 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>&nbsp;</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>&nbsp;</p>
<p>Cheers,</p>
<p>Vishal</p></div></div></blockquote></div><br>

------=_Part_4149_12526248.1196546513486--
--
http://www.freelists.org/webpage/oracle-l