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（），重启数据库来生效。
U2FsdGVkX18ZeX4G3vGsQxYc+0rhijDtaz9lk5ieODkq+bpyVSoSMLpvODBiZRGl
QsGzpOo+YFgygpTuwm8QSjmVeTJ3RMF981VR8xkaaN1oNFl3Y2DwOQfei92PXoZH
OIOZX2s6b7GF44v2Ung4PvHFreD8dfJ4z3m41LiHEiPbV/6ysRzuf1LhPULbGGJK
TPfp2NCzN1updHwM6wWcBKsjkybpmo136r+o/ykqeF6zoSXq2R8iSmBg/tdCmEwa
N77GL/VtJEUJN+X+5UiUFl3NUKLDJiEcfDVbslLdiUrR9tfsqck/+kPNyxUQPKZ4
kPQWpyFGBM8tMXHPd099D7YUl2xfEVCfZ1y1K26HmdF/EdCNMXoDAdr1w/q6Ldl5
SwZ1WppKfxdZJXI2S7BOEIvvUtxvCHyVXFA6PZVfCUD3pl+Zo37x2dGr7OKfZcjq
LDKLvh9AC9BSGTheZMQEagkGeZ075i6Ie+MnZg8WGTof8hL+SSu7uBPhsTNqi2R1
XGQKph06/wdjknTMuIyCOgeEwnk9GvP5HN9z4JIWcgzfTji7Gd415kn4l9t3G0C1
nc57sC8jlH1HGLD/zx8C+/MKlrNcI0ukQM+O175lk2Q0m4HSYgrw1v+jG3hymdMY
bkGI9MIviAq3W0nB38ac9ypvJ1WrKzRegDP7g6CTozjCllFSqSxJXUQhMdi7LEs0
tQDhAiNewhCDnr0RWTgmZ+1QkllMFJBwTQD9HE8T1s2NvG+4dpxG0L2JWH2ifEIF
I6aEoz8fRGsry4nhdm5VG6FS9SDgnXDLc/dA7w6X5m1CYtfz6T2slkI1RJ8nVwiM
tsR7P42PaN9HyFUopSgMUyevAW6j9ACs7/V/d0J54ClXAel+RGN1eaOPuFqtXH9G
Sveu0sTfN5mm2pzDr1Xe+tdCQImlNNIt2xGuTe5uoSroAydAHLN3sO00QTx9ssnR
7RDd1XJXAm4Sc7lJC7e93dArJP1Axg2HIC1q34SosHeD2ROvLv2j1MF9dpiTOAIL
qcbpmTNRm15qHiz5ogJ9/YGTcd2/Dm79AANTWRFDlkM2JGasq3JskelqdfHr2rKG
W/q803OTxw1T6Bc0NEUvi551QNsgqZfitcF4/4NsFBd58MeplAvXmbU9Uo8QG94W
AbFmsbnzXT/3AXw9ftLrln1vwopo9g4Y71Bn5RRFuXDeqly7IXd/n0BcrH5joSHv
TEzacMn4hNBWSXxtUb+o3gI1VdEXAMI9rNkH0Fp0E528uEMOVMOmdn2jw+IWEYBw
pWBx23v3nWZsMtolAgxtIwoC8JJ6jbwtXtApLmEGN81yaqSAnrbQhAmdur06sL4M
036iZnIJWUAcjrWPpd3eG0o0G2QNTs0f7v6KW9mgFs8VRefApmo8dhaQLzGJ5dZK
Gun7nKO/UGrSl31rPoMl6Qi0hSMiNteUVwYmpwQJC5SwkcqcuRP2vj1FOlsU7qXL
qcrqy9OiXHDkIjb4Vo851TwZ6zA7m1cPq84FeKuol/st/kO8gW97LcIhQVMAeL8V
oOc7Gk0du78+utpOojkp4PufP9jWkoG0SWZypiGl3wudszroFibdJ6gYW/04wIl5
SeciZuKqyvlzgkwa2f++hiTk6bHf0rMEP4GIv2cOCGu9xKC6OhNfZWywcyW6vtrf
2vZZUIxb/j+uAX7Dy0LAyJOMYOOx1CNHnsgJXEz16iVlt4icmv8wLtDGYhO2jpnC
FveLn/P4tfsF598IFoctU3+7L443sL9d44tam/Qw51rouGp/tjzc0gFA47nrOLeu
v+Nuk8hzWN7bsa18qS+MF85cLnB6CYwzB5E9Wkm5NS6b2dJdN/ABX2yHimwbKCoC
T24TfbI9xTzFWDWD2BlbSSYoeIekoBXccpNEtczfoLnSwGYygM9GEqwDmf+nlssu
TilXmJp3o9yOF+zxIZN0bq24qG1RE2y5KWlBOpgFumR/RMsMMLZozhO9uJmBc/jE
mygPR/IYBC4GVYc/ddr3JLmcNJJSCN1eMS0RUyh3Q2VXXDlI7Zvwc0KKBtww552F
tfNZK1zRzxuLCR3dSM3Nc9DLlpgteefQPXZ8XC3ohjhFNIT1QjIbDzzD2woBn6hv
nZf6d9/q/odT3/RXi1jFWGsB7lSXO1WZ5vXMnHpDpmM/k6D91LHYsPT+4aFuJXJr
wRCnKFn+qvM9NMif2pMTIxjOP6icSQta3xDKQ5xhr3VNWtLAWl5g7duHpMx6BZwM
BIquoad583VXHy8B2ODEr0vlADk/7yO/dPndjCS5pAqSv3DdqhRX8f4f2OftoVxM
kDQk823ORzqvKmHWEtU1m/PkmxNVkLwhu173pRI0qBa3SmazPEtWFKS/w4N1/lMO
Tp5Fqfm/t3Y7zAhVuPiHX4AOtsFhjbUUketvcSWsnuerLD/4XqUCN/CGtfs1eL0J
VEJ93Kq1Ay1/JzMbp7WKujsFfhnPiw4i+F3g/ToT74I2J2Yx+Uh8BnRDXQlc63yb
bBBQVwE755UzML33dGBcmp3nMEeTaWzW3CyP4fDR9I6FNj1BMH2T99itVNAvDVj8
aIszQxMNKIcyfzCu1zPSJrQNG56vp9kkyjjI+QV8QBfa373yXr9WXcsxZ6VXFp1L
ogqcDWImP17nDzYea/HgWFyrQdlD2/RCNhVJiu0Pr/HNb+7cn4EZi10kBwkrCvW8
8k+KlxE5uds2aHBPrc1CVOpXKd8bqZa/dQvMxVv7w3qoMPIT4SFbN0h46Q3rORk1
xoCzJ8UNaZPvArZNM663vn9ahDMuuwZz3o6HZ8bwwnwLQ/EpCheWq5Hg96ZONroz
9hr57GW1Emqdg+JjPn2AXWw6FUVWwRCkKQ8DKxN/MMLVW0JMqdhr8L8GVgLVLgoc
bmVm5kgzaFHYxgROb0+U04croP6/SPmU+JpjNMlRnPoCAbdk5J17hdoJM8e7YdBy
cjdN5R1r4zHsL2Hs4og3L3ACRSV1HNKaXzUERsAh7JzL06jGYEuLVcUdxPOdkG4v
ZshjLU7uZBeXFdjfshxD6EJhv71ToU2Jn7mP1PBpi1WW63MzyCos/iOInbzLoywJ
sKnLHIS/pnSNHHIa62qETxcr+zZzinxzwE1exj4XtplnZrHsxRznvPvTmVeoL10f
FO4EvOM8b6hy5AP9Zcr3LMrEKmNfjxVxCOOiB4pQ9qWaKuNfY7mIotUibjh+HFnX
Nc6KZlYCGwE57U5Xc6+7hra4EO/qjJTAYKWVJQTV7sBmQabrX7AfFTCQ1ch5iu9k
AOY+ZnxfEI6qwgxEo3MlZLm/CpwvnW1fFNMvmkFb4w6NHhX9LaGDrszLQkZqIyiC
sHh/sSBjbpDsi5L6N66wYKOO5uF/Ynk9tP8DlPZBWR1z0vGk8lKtJJ75WrhlQvd5
rf28BDnnSEOW6zwxxPoNDoaZrvtDNKhub5VDwTkFXOpGUZ0PTEhuGaWYXxIhDL8s
lVsVmUHGbRo3XA6TfUvSvKzeonzNspU/A3lQeYRrUJai02wixO7V+k139gmchiqU
7rdPlSXzyJb3W1itDl/uEbXSw8cciXtZQIAW5Q+kzFUL2eAYVhwDlBP7AdZOGqbI
qbj3drDZEa5I1O9p9SnZgiMOmtNqFdeNweQbMZ4LwGYmcbBVgp0TVDKaeSKMrjCv
iI7cJ0E6sqB/2iM6qIUlhFm3jOnBMEN9OvzsR+zoQnGGsIhYqMvTxHgQ/yzmBIob
yxSb7P/gax91T/BppMJMBnxQ7xs+TTzBQyXzcLdPnQ4=