altering session_cached_cursors in 10g?

hello to al of u.

i want to install grid control agent 10.1.0.3 with an existing database i.e 10g 10.2.0.1. during installation of the grid control i received an error every time when i try to install it displaying that the "session_cached_cursors size must be set to 200 or above".

i alter the value of this parameter many times with the following method i.e Alter session set session_cached_cursor=200;
but when i start the installation again,the message is also displayed again. i want to change the value at system level .plz give me some idea that how i can do it.
with regards,
waqar.

alter system set session_cached_cursors=200 scope = spfile;

then reboot the instance

Need not reboot the instance!!!!!!

Scope will change at system level too.

you shuold really check before posting the stuff you do

SQL> show parameter session_cached_cursors

NAME TYPE VALUE
------------------------------------ -----------
session_cached_cursors integer 0

SQL> alter system set session_cached_cursors = 200;
alter system set session_cached_cursors = 200
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option


you cant change the running instance, only in the spfile and reboot

Try reading the docs

http://download-uk.oracle.com/docs/c...tparams004.htm