From oracle-l-bounce@freelists.org Tue Jun 8 16:03:05 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i58L2e710801 for ; Tue, 8 Jun 2004 16:02:50 -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 i58L2U610761 for ; Tue, 8 Jun 2004 16:02:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0315672C1CF; Tue, 8 Jun 2004 15:48:15 -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 16759-15; Tue, 8 Jun 2004 15:48:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5666472C0A0; Tue, 8 Jun 2004 15:48:14 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Jun 2004 15:46:47 -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 4BD2F72C452 for ; Tue, 8 Jun 2004 15:46:46 -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 16439-29 for ; Tue, 8 Jun 2004 15:46:46 -0500 (EST) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.202]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id CE02272CF25 for ; Tue, 8 Jun 2004 15:46:45 -0500 (EST) Received: by mproxy.gmail.com with SMTP id 72so3812266rne for ; Tue, 08 Jun 2004 14:05:59 -0700 (PDT) Received: by 10.11.99.2 with SMTP id w2mr98544cwb; Tue, 08 Jun 2004 14:05:59 -0700 (PDT) Message-ID: <7765c8970406081405ee413e2@mail.gmail.com> Date: Tue, 8 Jun 2004 22:05:59 +0100 From: Niall Litchfield To: oracle-l@freelists.org Subject: Re: What's max sort_area_size? SUN 64 bit O 9.2.0.4 64 bit In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII References: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2293 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I'd be sort of (sorry) suspicious of such a large S_A_S a large P_A_T might be more appropriate (even though that is twice in 2 minutes I've agreed with support. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ----- Original Message ----- From: Mark W. Farnham Date: Tue, 8 Jun 2004 16:15:56 -0400 Subject: RE: What's max sort_area_size? SUN 64 bit O 9.2.0.4 64 bit To: oracle-l@freelists.org Ah. Unfortunately that limit is compiled in and shipped for a given OS/release. I do not believe that you can change it. I have not checked on the availability of a "large memory model" release for that port, nor am I sure they bump sort area size max above 2G even for a "large memory model" port. ---------------------------------------------------------------- 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 -----------------------------------------------------------------