What 's max sort_area_size? SUN 64 bit O 9.2.0.4 64 bit 2004-06-08 - By Niall Litchfield
Comment below
-- -- Original Message -- --
From: Wolfson Larry - lwolfs <lawrence.wolfson@(protected) >
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@(protected)
<quote >
06:24:20 LNW >ALTER SESSION SET
SORT_AREA_SIZE =3147483647;
ERROR: ORA-00068 (See ORA-00068.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
