Remove Hidden Parameter from SPFILE

Remove Hidden Parameter from SPFILE

A parameter can be removed from an spfile by issuing:

ALTER SYSTEM RESET "_some_hidden_parameter" scope = spfile;

You will have to stop and start the instance(s) to have the changes take effect.

Steps:

1) Check if there are any hidden "_" parameters.

SELECT name,description

FROM SYS.V$PARAMETER

WHERE name LIKE '\_%' ESCAPE '\';

2) Remove the hidden parameter

alter system reset "optimizer_cluster_by_rowid" scope=spfile;

3) STOP and START the DB( ALL NODE in the RAC)

shutdown immediate;

startup;

4) Check again

SELECT name,description

FROM SYS.V$PARAMETER

WHERE name LIKE '\_%' ESCAPE '\';

If you like please follow and comment