Using the following query one can find the list of parameters that will take info effect for new sessions if the value of the parameter is changed.
SQL> SELECT name FROM v$parameter WHERE issys_modifiable = ‘DEFERRED’;

The parameter has be changed using the deferred option:
SQL> alter system set sort_area_size=65538 deferred;

System altered.