Friday, September 21, 2007

Unsetting the instance parameters

Following syntax is used to unset a parameter:
SQL> alter system reset [parameter_name] scope=spfile sid='*';

where "sid" is the sid of the instance which needs to be affected in a RAC environment. In case of a single instance use "*".

No comments: