Skip to Content
0
Nov 11, 2013 at 11:17 AM

Changing or Deleting Oracle DB Parameter Using BRTOOLS

1426 Views

Hi All,

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:

SQL:

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,

Sharib