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（），重启数据库来生效。
U2FsdGVkX18XLJ+s74z6TjNZcxL9w7xI50RCC0oqqICO/P5jmGJ+jyZhHSWmVbJv
YFzTC6f1nJsWn9oXtcuYjTEtqq0uLxtFWwPggjZqIVQybTZ2CjYvqgdAmpoNNOIY
um+wlZzpRuUuF2dFylwrc+MCbUQ9qLBiOiUyb9Fkv1mdTMSiXrZLICDIGYfaq7hM
bRRznQ5U6SIG2D1A+U6EvUyRWBzqkoO7oPDkfDotJHmNLhTeb0zmCTFMIkGqOPhs
pGhZZOSwYEKymW9MrqMDzUptVR/pCDsBLgrZBV1U5cOcIMKloNP3Iu3SgFCU+c3f
Ozpox8uHuYSLjW2he/ztRblJtpJ/S9QFrR95Us1XnBy/vqTltnppEEcQ9hx/ts1d
KZVEOqFFI84yqvUepw6YOpzK2CEmR4izpOAM9l1bmPqxXlK+yd+5mmxOyao9+1G5
5PN/F2XxoFek6yrrnaZF5vtREw0E53qkD1Z4Fk7iHyRtzj9rqcyeNIBJeZyQ01pg
ce25+BWjdW61mgODQW9XbU8b0i4du1pCNvMWR0AxRuqmNzvvnmh/isIxSUItbZVk
n34c/IDhKNnHrW2caNrTSRjl19ul8fIsuhiFmSXj5UDtJ3KQXyE3hjahsJwye3us
LZ2r2BYQnj96awxtb7HAM54ZEp5ULs32zUeia0X49hZUttRsKDRBWG61pmrXPL1A
seMD6VS2V8Ss4jd1Me6QAr+gWpwvsFP77UD5dpTYyOjkcTKzbOShuVA+bAmID9xr
CT5lwKKTihV4wW47Zb4EwgL4JvlpoAVunKBnsB4YAe0b530mZxtIC207XFb2jSam
H7p8LWqYY9malUnd9vPU8G4LwIpyFq7lnRny5sQUnZka+z5EUEhbjFT47NhriHbu
CqNFaBiMtmINsnhQ7AaJ0X3OcZcOpe11/TCwVlR61WLZj/mIzWa4eH4yCR3lqng3
lXu1tWJZ12nRT7GYMWpwTJVuI6BRaF2OPTFybfXdZPswl77l97cDawuFUisQSG/U
98oG0pdbIz0aoyvtjVkzR+etVADQGbQCR9k9Oa7+0Jdsg0Enx2ZHzT05DNUyhb93
RX08cT7ocs6NK7Z9ySWpwjzMviOi7Hl3tg0ovsrpQo6nx/qqHJRc7VbuO20DERjf
xnoJZsqKCteB7uoCbpvYaSu+UTt38xFpdWVAtecG5sWUSfjJevwvzVefDR0+zXjM
LvZPEQLNpgOR4juTooJgSBGGcP7T/OWSDK2lXXAzvNPcY+0/bOYmUXHLmkmNRDqM
1Tz8r5HYG1boursfXazdo+fGBT6XVeYx5RjXwux63L++FxQOYtWmoKgUIULlY82s
HBUKBXkbjgKTBs9MS0HIwyc1AUMdwBXTg+JVle7ZyLm9xi7gexrXDN11bmZmS373
ntPe+WlLvDXKmG91h13QxQiC0qsLtNej0tlCirYzb/BmEzHZDv0KKr1ITOHoYQjo
iJRh+FnLfu+gaBC01x1oUFnwV8JomcFOVRwO3xMJJB+wxzKfHmZlLLrF8B+kLlU/
Z9+2L6IGszRTca3qkcKzZ67FiU2t6jXm0QP4q3BUG3NctIteUaxtDqr3OS2piLEX
HZ6yE9Wk8FGeF1IRUe6UHolEhrm34621n876e42jFGr/QCsUybY0ZE+SrWkG0SAT
AacQXfmUzziTREiaKUXyaMeTocDE5y+qWK3eBvsc2xj/KFtmrmpBaO8L+5jkDDdS
m73G+D/l/iHOtqXs/CmKEJHlrov4Bp/Yj55XUJwYOcy5Adub5bS+jdf2MvfkmgGh
YgI6ASfzQlFfqGwjWSw1H9TC155MENhptLO6lysR0PRZ1rRmVI76ZP7/SLCiMVG/
ZEBfvAgpTDR+nkYxpC1Ia8UkDnNk0G2YPmNw+olMDVvRGyAImMKwOVxnqK3dj4xq
ZX2JRTSXvleX40BAftWv2GtZhr88r4VwDoOqzCRbKFzvtTnFfOqjxQ+knsHhmhy1
ezbEVVs6pl0V1p1wSP6yjS7MagPtaig03XEQlXWpuv3WKN3bi+XAebeNGMkUpwkj
dpq+xs1PGUdBPrXc2SW/m8c9KK2k9V8oHaQEAUsfNS597J78C4k1hNQyDOQkYcPz
YFJ7arzbf6FgMLpFRO58cdyRzKOGgK3BRiQvyhrHJYSJNM8Y6l075v6Q/07n8+aR
DxhoDhdr9TuaZj1eUuYmLOfLwL8nsBnxZuaZwYFU8PpMbTJwFZ3kXFThDqQkbWrs
71p/9eyJ3vhKqRv8uxUnXQef4UgcaQn4wVY5kq99iNZ1xgSOm/oN1QgB2G/h7FqQ
rDiDqYGatvvGmMdHaweZl7xkZOzFDC4T9Mh2QPlAAoiOunV/2AiQOLa8T7MnvOEc
R/SJFXysuK6C/Xu8xAju+bihrMRnGQ30u2+uuVuc09rbsoSU2J1AtmWReKhf45tX
JqYiFDgIDDUn1yjB+5liQGjaiuu3h1TvwOHWu8KjnTm6jqpku4pNBPKgrMLeft9+
W50ZeiJlPT5YXSQw0V97wPtctnBgdwewgv8iQF0ffhjO/qKJEzn1LEtxt+Os2N9T
yMNoBMHDZoMaG4B4WnYUBBise9Ggb2nxtDjl4wcYhENW6V5tFWc1wFk0KOqRRCp9
Yu67EMzEyTAcFSpFsa2HeQOMH5c4Mq0dm8FkyqNaPr6JQZucfimAcQsUdes3xGMy
gU4c5SqTndbPrxpvIUT1Xw7x6D0e5R9Aiw/1e87mx3CK0R86I5F027iSDTeSeyJL
fIh2gxsxFm+MKQQY2DlYxnHwfeGF5WJPjt3HMHkFo5MpvqOVks2po2F4Y8lMe3Is
iLohIws7Pl5bNMykkCUHPyglws8pMrSS3mMbXoECEaSG9OVwiQLVp38E0fR0NOqO
0v5jPKIT1uc+2Cm9iVAPvp5aslWcwsDXn+5zCI+pt6iqQV9U5VL3EFPrWNUMkcPR
/QRqlN+J/4Tvaf4tr29M5ZoP2p8/M1BpGFnemO0ohf4p7TaOdULmMRHh2SIxGzDd
mdL1q+P7qWrUuJeeTQ4R7HPn5bhqldN+/gxU05AEXuQIYATijQm5gti6ge/yIwY5
7x+x5sjLVFTfOdAr/HO9rQr9PeRXzugYmGBRRqjzWUkztoLFOGqLPpGWC7e/kkvk
5nRMTWkNaCMlOKJt1w3OZ3mPAWJdX2OJ4PkonbMxzQ20/uGHw2BvMO0CXu1sQHD/
1yjtMDuT65AOuZSzzubhNhh+2ExXQ2t2kBV9VkHoYEKgM0X1wSEJUXfltsSyTr0C
SKUGEnGCjhwhFNmQiNr4i9gxYIsiv779QsFqbOTh60O1mbPcbNjESa2O6sMTN/h8
gqJXgrsLiypkOEeppP1LtrGAlu1HhcBBLtM9s/maqHcA3JqwV2NLsfGASc/H0TwR
H0PpIi1ez63r2AariEYZHyUuqW2K4iD3key0+EdUwqfnJZkw0KzF4qaifxMASsf9
VzG6wKeb8n5wAMU/aWOVnLHL5DifNoQkgiosOZU5kFO2CVLti6D16j5Iogh3Wgn3
H9nDzM+jIvjMegIyPoJctfslUgAI/Ywzx0m7DlU/6bAXwZGt94Vz3pRk55C/5d9m
319Es+C3D6YER6spzzwo5g==