We wanted to change and delete certain parameter in Oracle DB parameter using SQL stmt.
SQL is :
ALTER SYSTEM set parameter = value SCOPE = spfile|both|memory;
And not sure if we have to use below command to delete few parameters:
alter system reset parameter SCOPE = spfile|both|memory;
Correct me if I am wrong.
Also, we wanted to take system restart immediately after changing or reseting parameter, so shall we take scope as "spfile"?
Thanks in Advance,