Reset the default value of parameters in spfile of the Oracle

Reset command for the parameter in Oracle

ALTER SYSTEM RESET parameter_name scope = memory/spfile/both sid=’*’;

Following are example to reset the default value of parameters in Oracle

SQL> show parameter cursor_sharing

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------------------
cursor_sharing                       string      EXACT

SQL> alter system set cursor_sharing=force scope=both;

System altered.

SQL> alter system reset cursor_sharing scope=both;

System altered.

SQL> show parameter cursor_sharing

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
cursor_sharing                       string      EXACT