Shulou(Shulou.com)06/01 Report--

It should be scope=both and scope=spfile.

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

+ + scope=spfile only changes the records in spfile, does not change memory, that is, does not take effect immediately, but waits for the next database startup to take effect. Some parameters are only allowed to be changed in this way

+ + scope=memory only changes memory, not spfile. That is, it will be invalid the next time it starts.

+ + scope=both memory and spfile are changed

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.