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.
Click Here to Expand Forum to Full Width