Reset the parameter to the default value in Oracle

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.