Oracle-L: alter system does not work as advertised

From: Browett, Darren <dbrowett_at_coquitlam.ca>
Date: Wed, 27 Aug 2003 16:24:26 -0800
Message-ID: <F001.005CD8D8.20030827162426@fatcity.com>

Maybe somebody can enlighten me on this,

if I do a

"alter system set session_cached_cursors=100 scope=spfile"

I get the following message back

ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option

According to the documentation, by specifying scope=spfile, then

"The change is made in the server parameter file (SPFILE) only and will
be set on the next startup"

Going by that statement, even though the variable is not-modifiable when the instance is up, I should still
be able to change the parameter, then when I shutdown/startup the database during the night, the NEW
value should take.

If I can't modify the parameter in the spfile only, whats the point of the command ??????

Is this a bug or a feature ??

Thanks

Darren

Darren Browett P.Eng This
message was transmitted
Data Administrator using
100% recycled electrons
Information and Communication Technology City of Coquitlam
P:(604)927 - 3614
E:dbrowett_at_coquitlam.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Browett, Darren
  INET: dbrowett_at_coquitlam.ca

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: ListGuru_at_fatcity.com (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).

Received on Wed Aug 27 2003 - 19:24:26 CDT