Sessions, sga... , pga... Five parameters, restart, sga/pga three values change is normal, the processes and sessions how also doesn't work, the create pfile... The from spfile check and found that the correct value of spfile have processes500, but show the parameters during the processes or the value of the old 250

CodePudding user response:

The modification process, stick figure,

CodePudding user response:

's normal operation, and, after the restart, modify the size of the sga/pga has three parameters to take effect

CodePudding user response:

reference 1st floor selling fruit net reply:

modification process, stick figure,

The alter system set the processes=500 scope=spfile
System has been change
But after the restart of the original 250

CodePudding user response:

Select the name, the value from v $spparameter where name='the processes';