How to Change the Session and Process Value

1. backup the spfile
$cp -p spfile.ora spfile.ora.

2. check the session and parameter value
$ sqlplus /nolog
SQL> connect / as sysdba
SQL>select NAME, VALUE from v$parameter where NAME = ‘sessions’;
SQL>select NAME, VALUE from v$parameter where NAME = ‘processes’;

3. Change the Process and Session Values
SQL> alter system set processes=100 scope=spfile;
SQL> alter system set sessions=100 scope=spfile;

4. Restart the Database
SQL> shutdown immediate;
SQL> startup;

5. check the session and parameter value
SQL>select NAME, VALUE from v$parameter where NAME = ‘sessions’;
SQL>select NAME, VALUE from v$parameter where NAME = ‘processes’;

Comments are closed.