Home » RDBMS Server » Server Administration » unable to set session_cached_cursors
unable to set session_cached_cursors [message #268435] Tue, 18 September 2007 10:53 Go to next message
ramabhupalrr
Messages: 69
Registered: July 2005
Location: India
Member

Hi All,


i am working on oracle 9.2.0.1.0

I tried to run this command 

Alter system set session_cached_cursors = 200 scope=spfile;

i am getting the error 
ORA-02096: specified initialization parameter is not modifiable with this option

i tried like this also 
Alter system set session_cached_cursors = 100 ;

Please let me know how to set the parameter with out bouncing the database.

Thanks,
Rama Bhupal.
Re: unable to set session_cached_cursors [message #268439 is a reply to message #268435] Tue, 18 September 2007 11:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't modify it at system level in this version.
Upgrade to 10g. Wink

Regards
Michel
Re: unable to set session_cached_cursors [message #268440 is a reply to message #268435] Tue, 18 September 2007 11:35 Go to previous messageGo to next message
ramabhupalrr
Messages: 69
Registered: July 2005
Location: India
Member

Hi Michel,

I am very thank ful for your help.


Thanks,
Rama Bhupal.
Re: unable to set session_cached_cursors [message #268490 is a reply to message #268435] Tue, 18 September 2007 22:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
Please let me know how to set the parameter with out bouncing the database.

You can't do.
Re: unable to set session_cached_cursors [message #268506 is a reply to message #268490] Tue, 18 September 2007 23:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this not what I said?

Regards
Michel
Re: unable to set session_cached_cursors [message #268510 is a reply to message #268435] Tue, 18 September 2007 23:47 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://www.orafaq.com/forum/images/message_icons/icon12.gif

[Updated on: Tue, 18 September 2007 23:48]

Report message to a moderator

Previous Topic: ORA-00313 and ORA-00312
Next Topic: upgrade 9i to 10g using DBUA
Goto Forum:
  


Current Time: Sat Dec 10 20:50:07 CST 2016

Total time taken to generate the page: 0.30227 seconds