The issue is actually raised from one of our colleague. So, how are you going to do to remove the Oracle parameter?
The activity will be done on SPFILE environment. Here is the command, that’s it! Voila~
ALTER SYSTEM RESET PARAMETER_NAME SCOPE=SPFILE SID='*';
Note
PARAMETER_NAME – The parameter you wanted to change.
