Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 21950 invoked from network); 21 Sep 2006 09:24:58 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 21 Sep 2006 09:24:58 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 54D7B42E267;
 Thu, 21 Sep 2006 10:24:28 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 17546-04; Thu, 21 Sep 2006 10:24:28 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BA86A42DC19;
 Thu, 21 Sep 2006 10:24:27 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 21 Sep 2006 10:23:31 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E952042E24A
 for <oracle-l@freelists.org>; Thu, 21 Sep 2006 10:23:30 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 17301-08 for <oracle-l@freelists.org>;
 Thu, 21 Sep 2006 10:23:30 -0400 (EDT)
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 64E3A42E1F9
 for <oracle-l@freelists.org>; Thu, 21 Sep 2006 10:23:30 -0400 (EDT)
Received: by ug-out-1314.google.com with SMTP id 22so126080uga
        for <oracle-l@freelists.org>; Thu, 21 Sep 2006 07:23:59 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=XbSt2T5IdAfgeIHBU79HBf9I/i5G01VXvGmNoWDaQl8jjawxrGFaeAKBn8cOHA+mKX8jpp0+yvOZJPCXLDgfIYnutG6ED/ifha3wUNca8dpdVJLuXkCRAFSOG/qpI+cbw3LV3JCLQ6azK0IDd031bBLtgC8Rbwk1EwT0YhFy7MQ=
Received: by 10.67.100.12 with SMTP id c12mr9297093ugm;
        Thu, 21 Sep 2006 07:23:59 -0700 (PDT)
Received: by 10.67.20.20 with HTTP; Thu, 21 Sep 2006 07:23:58 -0700 (PDT)
Message-ID: <be592d550609210723x8e1e691x9a774f4e07c28e6b@mail.gmail.com>
Date: Thu, 21 Sep 2006 15:23:58 +0100
From: "David Sharples" <davidsharples@gmail.com>
To: murtuja_oracle@yahoo.com
Subject: Re: parameters
Cc: freelists <oracle-l@freelists.org>
In-Reply-To: <20060921140640.10747.qmail@web32706.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_9587_20901071.1158848638770"
References: <20060921140640.10747.qmail@web32706.mail.mud.yahoo.com>
X-archive-position: 39765
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: davidsharples@gmail.com
Precedence: normal
Reply-to: davidsharples@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------=_Part_9587_20901071.1158848638770
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

the answer to all of them is

"whatever you set them to" - there is no way from what you have given us
that anyone can tell you what they should be set to


On 21/09/06, Murtuja Khokhar <murtuja_oracle@yahoo.com> wrote:
>
> Now My question is what will the value of below parameters
> so I can allocate maximum memory to each parameter
> db_cache_size
> db_keep_cache_size
> db_recycle_cache_size
>
> buffer_pool_keep
> buffer_pool_recycle
> global_context_pool_size
> java_pool_size
> large_pool_size
> olap_page_pool_size
> shared_pool_reserved_size
> shared_pool_size
>
> bitmap_merge_area_size
> create_bitmap_area_size
> hash_area_size
> sort_area_retained_size
> sort_area_size
>

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

<div>the answer to all of them is </div>
<div>&nbsp;</div>
<div>&quot;whatever you set them to&quot; - there is no way from what you have given us that anyone can tell you what they should be set to<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 21/09/06, <b class="gmail_sendername">Murtuja Khokhar</b> &lt;<a href="mailto:murtuja_oracle@yahoo.com">murtuja_oracle@yahoo.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Now My question is what will the value of below parameters <br>so I can allocate maximum memory to each parameter</div>
<div>db_cache_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>db_keep_cache_size<br>db_recycle_cache_size</div>
<div><br>buffer_pool_keep&nbsp; <br>buffer_pool_recycle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>global_context_pool_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>java_pool_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>large_pool_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>olap_page_pool_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<br>shared_pool_reserved_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>shared_pool_size&nbsp;&nbsp; </div>
<div><br>bitmap_merge_area_size<br>create_bitmap_area_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>hash_area_size<br>sort_area_retained_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>sort_area_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class="ad"></span></div></blockquote></div><br>

------=_Part_9587_20901071.1158848638770--
--
http://www.freelists.org/webpage/oracle-l