Hi All,
When we alter system, why we use scope clause?
As far as I know, it uses for update server parameter file, spfile and pfile are the same thing except spfile is binary representation of pfile. They both point init.ora file. What if we don't use scope clause when alter system?
Also, it is written that if we use scope=MEMORY it takes effect immediately, we don't need to restart the db. However, what happen if we restart the db?
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_2013.htm#SQLRF53075
Thanks in advance