Find which Paramaters can be Change with ALTER SESSION

In Oracle V$PARAMETER documentation, column ISSES_MODIFIABLE indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE).

You can query the parameters list using below command,

select NAME from v$parameter where issys_modifiable='TRUE';