From oracle-l-bounce@freelists.org Thu Jul 28 11:17:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6SGHDUZ017246 for ; Thu, 28 Jul 2005 11:17:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6SGH5IP017211 for ; Thu, 28 Jul 2005 11:17:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6A8541D7C16; Thu, 28 Jul 2005 11:16:29 -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 18625-08; Thu, 28 Jul 2005 11:16:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AD9291D8E9A; Thu, 28 Jul 2005 11:16:28 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:subject:date:mime-version:content-type:x-mailer:in-reply-to:thread-index:x-mimeole:message-id; b=nRetltOCklx3H/vRUhzMNgTkjFdDTaCyl8Rlck6KCGU6TxrbH99ibjP0f4tY2DGXSJvfzCTMQVE3RZnCOxa2cs3zS+mx5OxZx7yS8ruGRbuQO1uOVYKe/EZ+51ceIIgX9SMeDqa3ERzK/zk8WrbquSonjms9CuwHW+Zc37t9NFY= From: "Ken Naim" To: Subject: Large PGA for a data warehouse on Windows 2003 advanced server(32 bit) Date: Thu, 28 Jul 2005 11:14:38 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00FA_01C59365.8C0A6A80" In-Reply-To: <84B673E70D068347A2F54A51457E5C270937BB48@CINMLVEM05.e2k.ad.ge.com> Thread-Index: AcWTi1nmVOdmGbrGTM6bayt+M1DnhQAAS2tQAAAuDFA= X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-ID: <42e9046e.39a8fd66.3d3d.fffff5a1@mx.gmail.com> X-archive-position: 22996 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kennaim@gmail.com Precedence: normal Reply-To: kennaim@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_00FA_01C59365.8C0A6A80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Dear List, I am developing a data warehouse using Oracle 10g R1 on Windows 2003 advanced server(32 bit). The server has 32gb of ram and ideally I'd like to allocate a good portion of it to the pga and not just db block buffers. As I understand it windows "sees" 4gb of ram, 2gb of which is for windows, 1gb which is used for db block buffers which can map to higher regions of memory for larger amounts of db block buffers, leaving only 1gb of memory for the sga and pga. I'd like to know if there is a way to use more of the ram for the pga, in the neighborhood of 4-6gb. My background is on the unix side, so please keep the switch to linux comments to a minimum. I do not have a choice in this matter. Thanks, Ken Naim ------=_NextPart_000_00FA_01C59365.8C0A6A80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable RE: monitoring jobs (dbms_job)
Dear=20 List,
 
I am=20 developing a data warehouse using Oracle 10g R1 on Windows 2003 advanced = server(32 bit). The server has 32gb of ram and ideally I'd like to = allocate=20 a good portion of it to the pga and not just db block buffers. As I = understand=20 it windows "sees" 4gb of ram, 2gb of which is for windows, 1gb which is = used for=20 db block buffers which can map to higher regions of memory for larger = amounts of=20 db block buffers, leaving only 1gb of memory for the sga and pga. I'd = like to=20 know if there is a way to use more of the ram for the pga, in the = neighborhood=20 of 4-6gb.
 
My=20 background is on the unix side, so please keep the switch to linux = comments to a=20 minimum. I do not have a choice in this matter.
 
Thanks,
 
Ken=20 Naim
------=_NextPart_000_00FA_01C59365.8C0A6A80-- -- http://www.freelists.org/webpage/oracle-l