alter system does not work as advertised
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.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren 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).
Re: alter system does not work as advertised
Hi! It works in 9.2.0.4 on W2k, so it might be a bug. I've seen other problematic parametrs as well in previous patch levels. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 3:24 AM 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:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
RE: alter system does not work as advertised
Some parameters just never make it to the data dictionary... In 8i there supposedly is an init.ora parameter called create_stored_outlines = true ... can't find it referenced anywhere though in the data dictionary. use_stored_outlines doesn't show up in the OEM parameter listings either. Oh well. Win some, lose some. Patrice. -Original Message- Sent: Thursday, August 28, 2003 3:59 AM To: Multiple recipients of list ORACLE-L Hi! It works in 9.2.0.4 on W2k, so it might be a bug. I've seen other problematic parametrs as well in previous patch levels. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 3:24 AM 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:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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).