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

Comment below
----- Original Message -----
From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com> Date: Tue, 8 Jun 2004 02:57:16 -0500
Subject: What's max sort_area_size? SUN 64 bit O 9.2.0.4 64 bit To: oracle-l_at_freelists.org

<quote>

06:24:20 LNW>ALTER SESSION SET
SORT_AREA_SIZE =3147483647;
ERROR: ORA-00068: invalid value 3147483647 for parameter sort_area_size, must be
between 0 and 2147483647  

Opened a TAR and OS said it was
OS dependent. I asked what limit was and he said he didn't have that info,

</quote>

NL> Doesn't the error message tell you that it is 2gb?

<quote>

BUT, if I re-started DB the problem should go away... I was hoping for a more concrete answer.
</quote>

NL> I'd be hoping for a correct one as well. How restarting the database would change an os dependent limit is beyond me (unless I suppose you shut it down - moved to to another os in the manner of your choosing - and then restarted it)

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
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
-----------------------------------------------------------------