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（），重启数据库来生效。
U2FsdGVkX18TeB7pTJ9qBLjxj+6qi+AiPJhTyyYGb5RHd3wj75eRpOh+MF7Wjpk8
z6Xg4tOxRYzK5mjM3ZE+NuB8fANfuG1m2TZsKL69jzkl79dyhNuvYnLAEQTs+UCg
ReA1ZH6wNOGwkBqKxSYHSuP8wakcfjlTT6vDV16/58hIwlWwZewCPG/nLqYbj/ID
L1cZE15wpjt4X7OnUHCG1nhrkYa0JTphMMRFjSTucaBPoekVGyYhXmg0akr4Kix0
JQ5n6ENW6bvCoGJEWWAgNubtNMSeWYYQgSD9+jxHwQ8XzvIU9OzsZDCQsQZTmDtd
T4o5Sr/bLXHYIdH4FDj53Q7m+4CSQUWnCmp2aAvIDgcp4tVQudLOZSz6+X+8UNv7
NUxaC6rMWsmICEN4WhN0N/CxZDIYj59il+d/i7p0Ipu+sI80sX4D6sWXeCYpvkOr
k2asQf/WerCCdcwodlJPgV6A9ymm43myBwMcyg9QFiY50FLAptsNPDH+28AA76QZ
/8rAAdDNFLsG5uAqjnv3BvpE7w/UyMPJGxi9wFQEVDOXGXAzr4sa81TdGxCmVaYd
wcSoQsBmnBGaBn93kZmHtxrHbWc+Rp3QRuAWb0+rQVMCoHRhrs5jQqixoSMuNfCM
zzWrJwUzWzPgU0ladVUWdJSpGqjtI9FhS7WunoBC86+hsto4EUtoTNcIFkyHQHd0
PeOupapBMgFoY2+0s0BchgDiqH4xb2SypjxBN5CSf15pX8+qsowI8np9e6YfRY71
NR1hF+mWY6kvwQYy9F4lMgCUKJCPE79P22D4LkwjujjkJFTpf4w6RE8b6NgzICkt
12lsHApyiEF49pDX0goshUegD2sw66JQzVbFP9YXhfvMl27KNRCyPY2JSPsWmUIC
+/uGh216R9yBhxQwzCMqypWXfTCdCIreJ9b077S0wHZeDO3JbtvnbKF7LnbXBPd3
d/mI9y7vLaSmmkBWZ3VvhmUwxS6NU5NkXmxJT5AUW+G+Fk5fIp5XBUrLDbKZFfJD
5ok/q6qV5F5HKE5yw09GKm1JiDBy8gLsAdkG01Mej5VisGymagifi+9lsFxpORMP
z3Vztkd2t67H6Hmtkq+aE7U4kU1X8K14GzDGUbegL5ht1vm9efY/15qWPCi9qbP2
Da8hK1rZ40ACjsnWVX31nfwgY6YSQG4c3N+inmQntgyoXzQy3IKuhsnJCZ/akG8c
vJnA5rzqbh610FC1NebpnGVSwm4kgSUnlmLGWFFlrnve0zjd1od4CFbQ0IYntZ7z
/BGgyCrb6sbri3ed1f2E3AROoiSFoSt0pr2DG/ijqJD6S+W9m4mhHgst3OVjm0xz
y5CnJUbHjtC9A0VzHuyqd6TXn9xs5wY8ZAdklYiagV2T1SA9ndCNKTNsoiHj+uc3
Po4sng2UQxzZ++LmVNkJMmN+QreMP3sXJZtE3ilyu+kHeEt7bW6N7OIgWzZFc1VC
GN8IUTJ4u2bHAEyuCnh3YeYCrgt3Eg+TOSBp9RW4FJbUV9I9JSrUJZbVhXqEZu3y
ogfexext1TQ54reeB2P9ljhWxpkd5lBr1CBVUKE3pwFuBYa4nnFz15hJAAA3wlTx
PeA5loRJLZCnKa7orcQPPjw/DEYf9sfwW4gp3tKh8CxY1SAfykup/H5WGNZl1f/0
rH469haL92LkpAYGlfWvlx5BlHP+Tf8sVfkXHYhY46oOaSmvgUy6Ck+7oaugAWg/
k+dhwdKElDRnqzk9aSqXnktw48ftL5NVIdDpgjyNsk5Fbn3Y12pQHnvyrnVMS2Nz
Lp3DC3w7NzfWgx1H6k9naFJUqm7tmOeSs1gNCOD/ueXYroBtkl19n7XR+E146901
U6pRaqunioyGMHfjdQw5JomBgSovM3wY/NQsA3hVZkNKKG85/LoT1+0Ekke9zZeS
tMVq0pPz+/ULEW3zFCLYI/UaTbNJtThR1NvZCCW6gaFyRgHdpWdJN83iL/JUiA9f
uYsS8AAQyoNlxI9HeeGtQXIYU7rtz//Xs+Dnyf5XykPvYTjRqfgwbcjXrym66/U3
9nPAPiCT3V+cv8XBYN/Fq8P4dijIoXqM43uFwZXEPdmSiI/duL2ToYiPY3jIjWYp
vJ1ybmr8ur5SGYI5LmlhovCruSOK6bo6EBahiEN/dFa2XNjhrTPk6dyNG7BfCt54
FTLuakMFBQhv1e9yqwTA+g17Mt4KTJUCYYC5MZ9u0JtVoUfa7/URjGkaqwRosxWo
F5mrC+PiqKUexd+lYtuCX5HSS7u4b07rGc6S1UMMec7nUeGsxFsmwVsbmu5u7BWT
crwcP6PYkyI2QThCpMOk4T7zVKlPr7flv8I404pxw66+G7NauLm/fcBPf64POCg3
OX9iH+6D+4OiA63BFAVmGav3tgxYsxzzuKJ8hlvgCblcJRDvY0v6MUjlesVRGWmw
qkYXhnxNjD7QkwYW/14SLA9pGAZJx5oez28XOGTrwInbTqrEQaLjVR+2nXjUrC1T
HD0YxFxAKU5YXoZlkDswCku7nnWdOvjulOukDU+UIKOklEnU7bqK+fxCvPV3qR35
G5hYGIfGtuzVlq3TkiRzhYYeScfKSLO/ETF/7nkzZ5CwtiB/9F0bUk41bIALgEp9
EvMhgn3gHgM+e5mEXrmjuLAkQT8h5Y+BrsTDfCCCWrGkfrnLTqOJFdYBWq4Xl4oy
WmgC76rZ15dOrVxI4bljgM8Yle6CTn/Ji30uIxWowX/ot7NuSwiQ85l1IXS1F/Fi
wytaIYSmUsZTkMfjDbgKXlH7zUJTnb8eGZHitHJx6PMOKLT6jwdfTCXvOL7I2dT8
DY5diuP8J6zNsN5BLUQxiEmKQ6jJsHFBotGcCholrgBPKAhvvjh/3yfg4q9YeUji
xqQ2aYGFcWrHIKYIdr3sxh8yJSOnqYuEjlz6cEhLyW9JgtkADZlHj1MxK9+K1Dij
Yf5IplH4mQ5BLj/s7byjSm+mj6bFRcXnQ3D5wbrT4nlLyg6nGg/NnjXaFdduINDt
j4aLsSD4KNoUoneYRojwjV7D5LxnWu5VHhjtJnLL7LeY7SjwWEDDcjbNwOhJNgbO
H5geMfUH9B6QX+qCKVEUfuTQY6YWHucPOOQBSn54kU5UZ71MjNFiTYudZtXLxjqY
Pxi5JKRSVmASwUP2p3BkYHvsSWwc/RSnFg5/CNHB44iIaCAP3oqMRZt9S1HRDn6D
TwzniT+OMfVKwcLw/ud6gJzNi13jvEi/3RXxNlmDGc+I66j9l9PnOlgNCP5jQBOu
tNEi6Q/tmWDFzVut3bMJ38hjaec8Dy6kCqOSXvpuRWorNyqV/0s4dhSKvuyVnIXI
oZ3RE8V8ZlR1tWaoYlZP25bkJ7FDfbYzKkdVx44dOfvc34p0J5nekzwj+Z3d9Hcu
7oDsohYavOHIc+tYt0sEZDZNbOY6a0EEdMNunMqkz/6Y7R6aKAEZgfPSgTZ95Vtu
UJ+BE0J9YYEZ165zUbdG9gEcUry8RLYtq88DHx/Ry0Hlo7IkrWkoLgs/z2mWJKvp
SqtCCBStU9zsIPLKp+j0A0thg0sB2LNBknW46asRudf3BdWsPawD1UzSIUcoxfTH
HZkUdhLJnEgLMBhHQv8qINyTfxGMgJlhyx5DpabuaM4sJptt85pVLl0GUPygwgM7
MG9QsTgKNWmq/RtNCn+hL48rRCKLu2jD8ZDvPiybFGYSjRycLWs+sJNx4efkkhRF
G6ib+oofWFDyg1tWUVMzW06C2XtrXawQS+1yu00I0Y4FZdoZQtbs/lJyQ2naJgry
L8cS+eTFAMJb5dHqEkb7Ng==