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).