Re: What's max sort_area_size? SUN 64 bit O 9.2.0.4 64 bit

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 8 Jun 2004 22:05:59 +0100
Message-ID: <7765c8970406081405ee413e2@mail.gmail.com>

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 <mwf_at_rsiz.com> 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_at_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_at_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

Received on Tue Jun 08 2004 - 16:03:05 CDT