Change many oracle database parameters using a temporary pfile/init.ora from spfile

Spfiles are better than pfiles (init.ora’s) for most purposes, since they allow parameters to be changed with “alter system set parameter” SQL commands. However if you want to change a whole load of parameters in one go, it is easier to temporarily switch back to the old pfile/init.ora method to allow you to edit all […]

Read More Change many oracle database parameters using a temporary pfile/init.ora from spfile
February 17, 2012

Remove a parameter entry from spfile

alter system reset log_archive_start scope=spfile sid=’*’ ; Much better than old versions where you had to temporarily create a pfile, edit that, and load it in as an spfile.

Read More Remove a parameter entry from spfile
October 29, 2010