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@xxxxxxxx> 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@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------