Thank you for the reply
I want to set my session parameter value as 1500 to 2000.So,if i set my session as 1500 what best to set process and open_cursors.
Please help me out.
Thanks and regards
Edited by: monoj on Feb 7, 2013 10:36 PM
proesses default value is 150 lets say, Session's Default value Derived: (1.5 * PROCESSES) + 22 , however if you set session to 1500, processes will remain 150. but you should increase processes also then simultaneously, close to 1300, recommended because more sessions more server processes has to be allocated, so sessions should always be higher but a little higher than processes in order to accomodate recursive sessions as well. Oracle says in a shared server environment, the value of PROCESSES can be quite small. Therefore,
Oracle recommends that you adjust the value of SESSIONS to approximately 1.1 * total number of connections.
Edited by: Karan on Feb 8, 2013 12:13 PM
After googling i found that the dependent parameter for session is PROCESS and TRANSACTION
Is there any other dependency parameter where there.
Thanks and Regards