In Oracle, the scope = both and scope = spfile options are described. scopespfile

In Oracle, the scope = both and scope = spfile options are described. scopespfile

In Oracle, there is a thing called spfile, that is, the dynamic parameter file, which sets various Oracle parameters. The so-called dynamics mean that you can change database parameters without shutting down the database and record them in spfile. There are four scope options when changing parameters. Scope is the range

++ Scope = spfile only changes the records in the spfile, and does not change the memory, that is, it does not take effect immediately, but waits for the next database to take effect. Some parameters can only be changed in this way

++ Scope = memory only changes the memory and does not change the spfile. That is, it will become invalid upon next startup.

++ Scope = both memory and spfile are changed

++ Does not specify the scope parameter, which is equivalent to scope = both.