OraFAQ Forum: Server Administration » unable to set session_cached_cursors

Home » RDBMS Server » Server Administration » unable to set session_cached_cursors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to set session_cached_cursors [message #268435]

Tue, 18 September 2007 10:53

ramabhupalrr
Messages: 69
Registered: July 2005
Location: India

Member

oracle developer

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.

Report message to a moderator

Re: unable to set session_cached_cursors [message #268439 is a reply to message #268435]

Tue, 18 September 2007 11:23

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't modify it at system level in this version.
Upgrade to 10g. Wink

Wink

Regards
Michel

Report message to a moderator

Re: unable to set session_cached_cursors [message #268440 is a reply to message #268435]

Tue, 18 September 2007 11:35

ramabhupalrr
Messages: 69
Registered: July 2005
Location: India

Member

oracle developer

Hi Michel,

I am very thank ful for your help.

Thanks,
Rama Bhupal.

Report message to a moderator

Re: unable to set session_cached_cursors [message #268490 is a reply to message #268435]

Tue, 18 September 2007 22:15

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.

Report message to a moderator

Re: unable to set session_cached_cursors [message #268506 is a reply to message #268490]

Tue, 18 September 2007 23:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is this not what I said?

Regards
Michel

Report message to a moderator

Re: unable to set session_cached_cursors [message #268510 is a reply to message #268435]

Tue, 18 September 2007 23:47

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:20:58 CST 2024