Oracle中alter system命令参数之scope

SCOPE

The SCOPE clause lets you specify when the change takes effect. Scope depends on whether you started up the database using a client-side parameter file (pfile) or server parameter file (spfile).

scope可指定对system的修改何时生效，scope=memory|spfile|both ,值取决于数据库使用pfile还是spfile启动

MEMORY

MEMORY indicates that the change is made in memory, takes effect immediately, and persists until the database is shut down. If you started up the database using a parameter file (pfile), then this is the only scope you can specify.

scope=memory，表示修改立即生效，持续到数据库关闭为止，若数据库使用pfile启动，这是唯一可选值，也是默认值。

SPFILE

SPFILE indicates that the change is made in the server parameter file. The new setting takes effect when the database is next shut down and started up again. You must specify SPFILE when changing the value of a static parameter that is described as not modifiable in Oracle Database Reference.

scope=spfile ，会修改spfile参数，新设置只有在重新使用spfile启动数据库的时候生效。

另外，若是修改静态参数（不能直接生效的参数），必须指定scope=spfile，否则若指定memory或者both会报如下错误：

ORA-02095: specified initialization parameter cannot be modified

因为静态参数不能直接通过修改内存而生效，只能通过修改spfile然后重启数据库生效。

BOTH

BOTH indicates that the change is made in memory and in the server parameter file. The new setting takes effect immediately and persists after the database is shut down and started up again.

scope=both，表示修改会发生在内存上立即生效，并修改spfile保证数据库重启后也生效。

If a server parameter file was used to start up the database, then BOTH is the default. If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify.

若数据库使用spfile启动，则scope=both是默认值

若数据库使用pfile启动，则scope=memory是默认值，也是唯一值。

静态参数，不能通过修改内存（默认scope值或scope=memory或scope=both）来生效，要通过修改spfile（），重启数据库来生效。

U2FsdGVkX18i2H3q5lk2PC7ENI4HYyEIYo0Wqf14442DYPVce7KkuREotHIybyeg
5+//0eaA7T1vFLRply2fUoTxUAeCUXA5x2zV9wRsdVcXo3nG2pJm5qFtL5o2lH6s
CjLqF/wC+yPgGD9T/qJ9m6+dC5fJ4fMlTfslmpIIKyAgNdWPACtk0GepfjQkfDgE
vsOwwO7wPhxr3XlWB5Reh3P144ue2bUXL6ccNPAGzablc6otx5VDnLyWoK6qA03L
vL7S0zZFzYrzQrJTOAKA1EUK1A8YkZQIvbh4A6Z5BzsJvSVaQNCX25grL4tfiE9G
tWstLgRU+/Bnp2AfawmyWy4XkR6o4vaKZDpgA5n2aq+QXVYPwIVLYXAKzwbwly+Z
k8hthtOxHn6FUpAk2Dn/Asq7X2u74rV8cFqxbKjD3FUT2WaNrWioIPL0Dkcb1ZWF
NxXm5nCSrxJAeYrxuvWf0jou5Ra+p+m6VRbl3sAEtT1DvoneJS+P2L38SKDFvaGp
2YccUEJ32XrWBdro6VUmsDkj5YmG1H2tGD692M6OI9r3xVRxg3TqJ2aaO/zGMprV
X8KKqTcJTlEc9ObWFYXJE8Lay/+IbVXHYkKKyIupSjPlrsyMC9HVYTjCAo1RA7hr
CnTocQn4UBiLoZY2uxPRcvMKMIihJVEVf1MTWuSu7+dRh34afFKKlXEhIzFOkj5R
Na3nw42M81SA8CG32/Ip+AjBqdt9FXiE6W3NPEcg4BiTtPWLF3/zC9wVJlooRhf8
bn1sYMvQOxIr4HWZorCBZE1Uyswf9tYYLC9y4i8S/pklTgnAOV09WHSKm+C2kwCe
t600XKMzeljY2Gk8PInWLNAxGR74jAUcEvzOWGcE+FkEw0nGwiJLQrCrj8o08c2z
HcunFTBCXrteak3Mq+ZA+cg3miXY8gTiD0u/YQFTh7IxJp2vBaCcqdGdzRIEXzpb
PNHhWrVUdi6mt0FConIy2+1sWsWl3P+wbplvkGKmNzO/ONElgvZQPHoiwtcXGpeZ
Ugunr4M/ZQPFoZ/8kyhjcnw3D7xIILfT+AR7ZCm9Gy2qkZvQ/ii7Ae74Q/ANLxkS
Ow5SBj8CizvUYC9ho2xQGHC1lARwr3NQ4YrxZBtOWYfV19HuAa5uUt6cK2fPiBPB
6545kBC24M/mcKte8T712cBbs81EyBb6b+J2QVBxH1liwVHUmB1BwVhNL8DhLPE5
5pFtYfar5MaoqY3bRvTACEPbSHkmvvBEr8vRRHm2f/um3ouwE1q3wQdXswrk5ChW
zvCCCTcTBk+NQiRKhDUbcY4E83NqzpzcHoZRlMcCianOD4N8FQ55ilh2Nmz1VZJP
LivuwDiCGXGQMN9N94h9MyPVQ+2megjJHIh/ZHqf7m1VPdOIpmaubWAaoCMQnTWa
5XzsZEjdAaJ9iNP8Alk42NJDCvazMyOituy3os+ijCchN2GkOli6w2mhOl7753w8
HNrq3kztCDIsQdtH0y71p23/0O9ais9P/OBB26N5nT2RWeOMYfAxfeOAbh3wuQyq
qTIhc16O0aWYWZ2HwvfTzli2dZPVudhRomp0/dFTFWv2cnT3cKnRCgBAFC1s3LrC
56sfXqT3+qL14IQzZuewos7DQlyuklvGV0jNE6kOveTSjPLT6JLFHHVpY+VVF1h3
Zn3hiQC+ZXV4wdYbwXBvnXrzoegmtD85Z0rF+e/5uE6mMTCRQ0R7YQrVpVL43ylD
C8utMvcmh/h2FaeWImrs+Y6XGCb01iTgWHQhic089TCAN6MLK2Yk2+h++0l4KF/S
sQrLSucH/iMkFEDCzPI4WOLhT9Y9f4gC7dxpmj3YZTgEDBtGBJhnb5ZT1IEazPyC
EZ3p3eEaM7KlFbyi+TrvEJTyQtI3Nzqji2vhPL2RkadF0pgXQJV/xYk8Y8ysm0zS
tVxNj6hKXdTVJPwthA5k6LaOKhKDGTC4ljmAE+uRbbvL9+1uix0eNTnJp1ouNXJQ
NH41P/1NUg4+eifMyYVXX127yjcE8mqR3BnPWP4cDTaBk+layXCC1y8O3RF1WEvI
6IgP0Zd41KaJxbvxntgaFp2M4iFM4j/4L/cGSOfkmCKhYfN8hTskzCVre87FT6RQ
/Hf1oh9PismV6yICy5rkxz2t86KonZxML76rk/yOypFyr8MAGDS0pCRxlN3CiK+E
nkAu6OWdIEITflxWXP0hcD9NQZSnEoBdDaN2SflB1KY/XTDKPhKbBRCanfCERrOS
7kalpg/g42yN4cm2BqBFpc2fNDEn9DQYQh3dezZoGfb0FjFjwWMFRZxzlKgbVm/F
0Njfn6U5lAZjKDLif950mag0KVpPWUEUY7PcJq459fAa4fLbdcePsuaH5imHgEwI
+eVi0pXQt8qBnLrLMu3BJw/xLxo5XK/3jgiRVYt+D9xMiQQXdDE7DCRsKA98xYb3
RjY0w1SDi1cbgRSA7OzNZgRuKQ7HaaDqC+Fh34DAv49gkatUOollj9qhys2D3GkW
hHEXPdTsimYK4GGUL+vIYIks2NAz8cLG0VaUxbpNc0lSHv6RgiBZAvQ7Nck/Xgh0
FbBciIpuZ8sUXo/106icWd2h1fJKJWlRWnsj6uRWRnvJ8EAN2oUxKQuZACzv8xdg
kgDP5mFMRoOdVh9jTgfCp7stx6NZZnwZg7oG9iq0QmFQL+hegw1TrNL9dhbaXlEH
ocPr1NpT1WLV/5uK8nXmO2e23m1ihqERR+K6XYrKKjHrvGf9o+CbjwZobNAVVCs3
1qi3XGyzJKVrZ9qyJBVKEWJLNeNYzHASgPr4LSykRa8bDcbYD0qlTB8oduPLxlyx
nrGUs6egv/QX7KDH0KiyJ1G4rzWqQien7ZyBrrfPSDJvXfp1jJNn4d3a1WD99k9a
UD/+bbbQyybjANkiqDqoq9PEswOIGAEbWfryGPcRRAgZPNf5wVpIYiA/sIqm9XOh
hFZDuYP+5tj98rrXLojGG9tRhCAYt5OhycxR0hZPuZaJivP4RzcVba+8Ot2NU5X0
mHVxQodetI3JVB2z0v9N+8L3R8fw7YkT0lN3WcmvE6joxIWBdggzAsuwUkSeRMHH
B5ecvnvh+pE9LT0L4NGrYjQ5lFdkxlXtIrtUsTMhHjIxkkvZODqAjPm5GsOPAvna
opWbMWMA8t+OzpEbDMMxIYpOagLX8OqRMgFmcHfYIKUdq/ek/lz/CT44ynbKxjnH
HOhtTiWRcIdNNT3Suwflycw8THlcKlMFdAUNFfnze2pmrAiopdiTUr1hlopW8sFh
jeDcd9WhnbguWggx5TSDDD4u3LSt3ukNlMexk7fliis0SOjgo9x4B52Y6rDlZVlz
hJDJDkUBzNuHGiYf+r4TfPVIReheq/4/0fDdCyy/BhNE/CGWeQ/wQxsWtBuOaR7y
gtghyRye9kAuvyIPMCl4SMdLcfzqdBMn05D1t96p95PIhUTOwKmSqOW9R/EuZTdP
wYNR6Ke4PqkpSk1CjyjEQlEV8EwMxhWyr3D5nxUbacDyRWlu0yX/C9hRTT8TReRs
1uNKrheD2EAiuwiSiiTdsTvJetCTfqIlTdaz0fcdB29xMhKypvBD5NeLrhLboNgI
Cam9aVhhwANDAqlLaAOrrC+Z0UNUfgSb9LpTmIBSvX3KJhv6jkS29tt522C5kQkA
YvuWx8e+h8vJlnP1G3yQTA==