From oracle-l-bounce@freelists.org Wed Jun 23 19:54:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5O0s1u29215 for ; Wed, 23 Jun 2004 19:54:11 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5O0rp629198 for ; Wed, 23 Jun 2004 19:54:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3F0DC72C69E; Wed, 23 Jun 2004 19:37:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24555-96; Wed, 23 Jun 2004 19:37:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6868772C64F; Wed, 23 Jun 2004 19:37:17 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 23 Jun 2004 19:35:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B782572C5D9 for ; Wed, 23 Jun 2004 19:35:52 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24433-76 for ; Wed, 23 Jun 2004 19:35:52 -0500 (EST) Received: from mproxy.gmail.com (mproxy.gmail.com [216.239.56.247]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 3D88472C5BD for ; Wed, 23 Jun 2004 19:35:52 -0500 (EST) Received: by mproxy.gmail.com with SMTP id x17so82247cwb for ; Wed, 23 Jun 2004 17:57:30 -0700 (PDT) Received: by 10.38.181.55 with SMTP id d55mr50389rnf; Wed, 23 Jun 2004 17:57:30 -0700 (PDT) Message-ID: <962cf44b04062317573fa54d96@mail.gmail.com> Date: Thu, 24 Jun 2004 08:57:30 +0800 From: zhu chao To: oracle-l@freelists.org Subject: Re: Combined SGA size and Total Memory In-Reply-To: <20040624003710.GC1807@medo.noip.com> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <75DFF91B31A1284992092BDB70C92324035E6124@ftwp45ns.br-inc.net> <20040624003710.GC1807@medo.noip.com> X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3511 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: zhuchao@gmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Simply try and see. No rule of numb. I have an Oracle instance having 12G SGA and 800 connections. Oracle SGA+PGA size is about 14GB. The total memory for this box is 16GB. According to those rule of numb, I am totally wrong. I am using 75% of physical memory for the SGA. But I am happy with this. (Yes, it is an OLTP system), so pga is relatively small. No pagein/pageout/swapin/swapout, kernel cpu usage is below 8%.If I only use 35% of the total memory for sga, what is the use of the remaining physical memory? On Wed, 23 Jun 2004 20:37:10 -0400, Mladen Gogala wrote: > > -- Regards Zhu Chao www.cnoug.org ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------