Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 9582 invoked from network); 1 Dec 2007 21:03:42 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 1 Dec 2007 21:03:42 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C31667CC338; Sat, 1 Dec 2007 22:03:43 -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 10201-06; Sat, 1 Dec 2007 22:03:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3BD667CC317; Sat, 1 Dec 2007 22:03:43 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 01 Dec 2007 21:16:48 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 029027CB3AC for ; Sat, 1 Dec 2007 21:16:48 -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 05260-08 for ; Sat, 1 Dec 2007 21:16:47 -0500 (EST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B44DA7CB193 for ; Sat, 1 Dec 2007 21:16:47 -0500 (EST) Received: by wa-out-1112.google.com with SMTP id k22so4277776waf for ; Sat, 01 Dec 2007 18:16:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=unXq5dQZ+wr9zEL4lDKBN6UVVlxBKxvJBFDN+hUVc4E=; b=NqtcYlw8FKTedxn+GZteHUVNuLPZY8iAeUObedwDTZI/QFOwtCe26vDizy0aaqIIPOSIefLiso4nHCuaq0um3aQxhekPDNhIL52zzUOyNBkegNDmOgSQ37JJn/pSP7AuUrYknGHqxv2AOfinOiizIu/n3d78JjCBsHG8P2Ir6X4= 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=nM3bQ2gfPkkQsuvAIp/To/2Iz5LLE7++jnjucah2+wtscN7c0klD80XxUuHjzTSVmfloQ7SwZDHwWMNJoZzclBiFqq6OR7E6X930FMnq4++YVtzA25ufpMu2/v0XjucUqB2YWZ8VIjanU1IzXFMjElPsxU+Dg6q9qaN20o1+zmQ= Received: by 10.142.187.2 with SMTP id k2mr2944748wff.1196561807167; Sat, 01 Dec 2007 18:16:47 -0800 (PST) Received: by 10.143.41.20 with HTTP; Sat, 1 Dec 2007 18:16:47 -0800 (PST) Message-ID: Date: Sat, 1 Dec 2007 20:16:47 -0600 From: "Allan Nelson" To: vishal@vishalgupta.co.uk Subject: Re: Forcing ASMM component to shrink Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6916_20748387.1196561807168" References: X-archive-position: 3668 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: anelson77388@gmail.com Precedence: normal Reply-to: anelson77388@gmail.com 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 ------=_Part_6916_20748387.1196561807168 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 > ------=_Part_6916_20748387.1196561807168 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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


------=_Part_6916_20748387.1196561807168-- -- http://www.freelists.org/webpage/oracle-l