From niall.litchfield@dial.pipex.com Mon, 30 Jun 2003 13:51:53 -0700 From: "Niall Litchfield" Date: Mon, 30 Jun 2003 13:51:53 -0700 Subject: RE: Caffeine good. Message-ID: MIME-Version: 1.0 Content-Type: text/plain And another thing. If in pre 9i days you tried to allocate more than 2gb to the Oracle.exe process, just cause you have 9i and dynamic memory allocation does not mean that os limits have disappeared. Your text file (init.ora) with the incorrect value in it to edit on the other hand, has. Actually, I have learned a number of lessons from this experience which may have general applicability. 1. Your co-worker having a bad experience (db crashing with bad init.ora parameters for memory) does not mean that you won't hit the same barrier. 2. Spfiles have extra pain and little convenience over pfiles - read you can screw up badly. 3. don't change the same thing on 3 databases at 16:30 Friday. 4. Actually don't make *any* changes at 16:30 Friday. 5. Windows sucks (ok this isn't exactly a lesson really). The Niall practicum (no fee-no certification). On a windows 9i server (not a valuable one OK). Connect / as sysdba Alter system set SGA_MAX_SIZE=2047MB scope=spfile; Alter system checkpoint; Shutdown immediate/abort; Startup What happens next? How do you fix it? Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).