Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 27288 invoked from network); 3 Dec 2007 18:12:27 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 3 Dec 2007 18:12:26 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B79E57CF683; Mon, 3 Dec 2007 19:12:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18622-07; Mon, 3 Dec 2007 19:12:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1E0B87CEC9B; Mon, 3 Dec 2007 19:12:25 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 03 Dec 2007 18:25:28 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09AEB7CCA81 for ; Mon, 3 Dec 2007 18:25:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10855-09 for ; Mon, 3 Dec 2007 18:25:27 -0500 (EST) Received: from cht-smtp-002.bulldogdsl.com (smtp.cw-access.com [83.146.21.8]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F7F77CC754 for ; Mon, 3 Dec 2007 18:25:27 -0500 (EST) Received: by cht-smtp-002.bulldogdsl.com (Postfix, from userid 1002) id 2DB2C1E4207; Mon, 3 Dec 2007 23:25:26 +0000 (GMT) Received: from vishalgupta1 (host-87-74-1-242.bulldogdsl.com [87.74.1.242]) by cht-smtp-002.bulldogdsl.com (Postfix) with ESMTP id 9C88C1E42DE for ; Mon, 3 Dec 2007 23:25:22 +0000 (GMT) From: "Vishal Gupta" To: Subject: FW: Forcing ASMM component to shrink Date: Mon, 3 Dec 2007 23:25:19 -0000 Message-ID: <00a501c83603$c4bf1cc0$4e3d5640$@co.uk> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A6_01C83603.C4BF1CC0" Content-Language: en-gb X-archive-position: 3686 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: vishal@vishalgupta.co.uk Precedence: normal Reply-to: vishal@vishalgupta.co.uk List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_NextPart_000_00A6_01C83603.C4BF1CC0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sander, See reply of Yasin Baskan. He has answered my concern. That if free memory is not there ie. Its already allocated to some other component, then you will get following error. ORA-00384: Insufficient memory to grow cache From: Sander Westphal [mailto:sander.westphal@gmail.com] Sent: 02 December 2007 09:57 Cc: vishal@vishalgupta.co.uk; oracle-l@freelists.org; anelson77388@gmail.com Subject: Re: Forcing ASMM component to shrink I do agree with Allan; So you can set the lower-limit of the cache size to a higher value if realy needed. The instance will use your this setting as the lower bound, or the smallest size that particular area may be. Cheers, Sander Westphal OCP 8i,9i, 10G and your Dutch colleague. On Dec 2, 2007 3:16 AM, Allan Nelson wrote: You will have to push some of the memory you took away from the shared pool to another memory pool. Shrinks don't do anything if the memory freed is not allocated elsewhere. Allan On Dec 1, 2007 10:59 AM, Vishal Gupta 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 ------=_NextPart_000_00A6_01C83603.C4BF1CC0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Sander,

 

See reply of Yasin Baskan. He has answered my concern. = That if free memory is not there ie. Its already allocated to some other = component, then you will get following error.

 

ORA-00384: Insufficient memory to grow = cache

 

 

From: Sander Westphal = [mailto:sander.westphal@gmail.com]
Sent: 02 December 2007 09:57
Cc: vishal@vishalgupta.co.uk; oracle-l@freelists.org; anelson77388@gmail.com
Subject: Re: Forcing ASMM component to = shrink

 

 

I do agree with Allan;

So you can set the lower-limit of the cache size to = a higher value if realy needed. 

The instance will use your this setting =  as the lower bound, or the smallest size that

particular area may be.

 

 

 

Cheers, Sander Westphal

OCP 8i,9i, 10G

and your Dutch colleague.



 

On Dec 2, 2007 3:16 AM, Allan Nelson <anelson77388@gmail.com> = wrote:

You will have to push some of the memory you took = away from the shared pool to another memory pool.  Shrinks don't do anything = if the memory freed is not allocated elsewhere.

Allan

 

On Dec 1, 2007 10: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

 

 

------=_NextPart_000_00A6_01C83603.C4BF1CC0-- -- http://www.freelists.org/webpage/oracle-l