From oracle-l-bounce@freelists.org Mon Jul 19 08:41:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6JDf4J11974 for ; Mon, 19 Jul 2004 08:41:14 -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 i6JDes611931 for ; Mon, 19 Jul 2004 08:41:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 192BE72C9C7; Mon, 19 Jul 2004 08:20:31 -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 05417-51; Mon, 19 Jul 2004 08:20:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 69CEF72C839; Mon, 19 Jul 2004 08:20:30 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 19 Jul 2004 08:19:03 -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 4B5D272C352 for ; Mon, 19 Jul 2004 08:19:03 -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 05323-43 for ; Mon, 19 Jul 2004 08:19:03 -0500 (EST) Received: from smtp800.mail.sc5.yahoo.com (smtp800.mail.sc5.yahoo.com [66.163.168.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 92EA872C2AA for ; Mon, 19 Jul 2004 08:19:02 -0500 (EST) Received: from unknown (HELO medo.noip.com) (gogala@sbcglobal.net@69.37.244.23 with login) by smtp800.mail.sc5.yahoo.com with SMTP; 19 Jul 2004 13:44:43 -0000 Date: Mon, 19 Jul 2004 09:44:35 -0400 From: Mladen Gogala To: oracle-l@freelists.org Subject: Re: About having a large SGA for a DataWarehouse Message-ID: <20040719134435.GA7312@medo.noip.com> References: <42BBD772AC30EA428B057864E203C999274476@MSGBOSCLF2WIN.DMN1.FMR.COM> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <42BBD772AC30EA428B057864E203C999274476@MSGBOSCLF2WIN.DMN1.FMR.COM> (from Waleed.Khedr@FMR.COM on Mon, Jul 19, 2004 at 09:39:03 -0400) X-Mailer: Balsa 2.0.18 Lines: 11 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5402 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gogala@sbcglobal.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On 07/19/2004 09:39:03 AM, "Khedr, Waleed" wrote: > Data warehouses usually require using PQO, and this uses direct reads > that will benefit nothing of big buffer cache. They will also not benefit much from MTS, so allocating large chunks of memory for large pool is also pointless. Hashe and sort are size will need to be exploded, typically to values like 64M/process. -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- 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 -----------------------------------------------------------------