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（），重启数据库来生效。
U2FsdGVkX19aDMP9hEh2+6ugeAjSLeEDZaY3RWXGgpds2tQP5ByDL1HNO3nNm3eB
8M0LtE9COWyFz19ca2ZTMpXElleT0/BxC3JUk1azUo6XYu3Bwt0Y4ywo1JuVQAYR
JRja8CqjcTWd+GT2lmrA5s226RaT97kLM363bFg/QfQRXy677EpQbf7ccwBnB8fp
zxOJlD85zs6X+AZDsuGyXmMHsY/haGgYK5KZ05B7a6Q+LI7synG+cUSnRE3xMQxb
/8MBUUtn9WJj8buVA0dMOoLdNf5/44JRFPW4qSFYqYu8B7Iuv0uUhnHDebpxXL9A
4HSEMj7v2RFe1BsraxvgzDSUiSArKccGyr6ytE+lkocGW6cucufJB6AI96HXniDZ
vAl/HrK7GDwfDln4fISenT0eSOa97INZotq5JkqgItMGaRNeXf81VrtGSJa1PkC7
wOxxhTF/M5IBMr2IsUc9eRsDbW9ecNXTHc+4xKhJSMHKYfGuAw10EzLfSikWfKGG
TEd7QmvNq8Itk6sOzThG/yh/JKhAtfLhvuhJzv3fqLvihFh5Zyxg+cOWKSG1DRCs
uqdsqP2z9eSCyurqm6kM7uwpzYax/nrj0i9Ih4EydJJa7Zb0HBAC2GFQflfcRGhb
QLdb36XgCP2QcbgufjLPElQyBMSQavswHNSO3/ptnRIfB6vYu6SjYDRLdJSJjr8F
ICytxX+nmwR1pyGoMyDLCjEkJg7RV/MajKY/xK3DBKi/8ddJHzPFnrh/hEAyeYnn
qG/dU/Z/ArNgCl5sv3J9bcZPLAvGn5IwhHnkIPd8kt5F4HyuCDyak+WLxlYrVG4N
ouC4J4uueNZk43r4bVvIKuJyJworDLDQy2uPhosIFug/h6c49itj2OWNOgIC+bCx
GWZiL22yUEtYMTxQrocKV4848lq3moRU3oyQDd+6odXG+K8PoLYwbX4DVJ5lwla3
RuT6I4/SBYzaaM927sx9tAuM/ULzSOT9p5102M8nFdn99wx8QoEfJCzqoa0EvuKz
nQRm+d76ds7TzD2xfZ8oxMcUDJrgMRUkW1166KHpOLXFOVsfGNEAqee4AqWa71O8
9u1B+2EtwhmvIAU9XX8DL+VForNuLkH9/rs6MeZXwcd2UjkgqJsmddMylff/4ry1
Jyq+/Fs3xRAwPp6QSKaxK85ttFm28v2nakyIS84AjiE6lA8z2uwjSisK3iV1GER0
c+p1tZRJZP+Pnomu44RdeZcYG8hV9JLgBMyKCjKi2Z1u0QiCOpqf/rmBMXhefTZS
3rpKUy06tje4sQKgsCG/T1Yat5QaVgrL6zFcWjRNNx7ZiLTOhcPTJ1OiCzAZE1SI
9DRzhZOf/sIwQN3bY5YZYoquhTVRVvVub2GKhkOqC9g0u2MUOknCXzlGrlJrPj4J
/Iuv08gXKvm7TXOU+/IqAC2UF0YOMoa6xxW+4dnLAbtnC3B4CofFqgtGQcPQKQLB
v95IBTWnMMRosFBVjUX0OOAWoRZjDRuayDn1skpS2sNTVOVnHgzb8dkHdiuRikMX
TeeFL3R0jAk9JrqzXLbqYwiko9PNe4gr6EKZyIPJ3dAgk4yRcLbfhZdp+jwjju4d
t2hxjL+IQ8kAe+ZPAHDff92VoFBcsGaDkhcb4OW3X8LL5PeQBjANrh34s0yCWHVS
c8r5pRlSMEUPw7Xrt0ns8Rqr+pIUfSjrRxFTQQ9sCrSbWGLhwgf90THH4A9KAbRM
ho1u1z17U8tkgaT5b6aNgqvPHPJasSDIj2y3gLYA7YRMjhuKvBqgM+dp0NZIb1AJ
936imhFWv+fIGI7M/K/IzQKYnkURLhkIZ7Z8zAqjtuCv6JCeVMxR+vfXWrtTnB8h
g7/5Z9837bk4jAILZ/fuXebWaJDqjXn4Jod1pWEP47UxzxRSguiKgpcLMwLwJ9pK
TYrSuokQPsTlBu31Qwivn5Hq2VSUaCYMn4eV+lc7XE68TsnQ2rvUn2qJYZIa03Xa
YIVNLHreBSq4U3vI0D+VOTT6kqw6AFGPifUVBt9CI8Yevdf4Q5jtVKDbvz/JkkCv
Cl0dIG18KgsUpSaIFtFmMWc5UQhX/SyhkddSnzR/fZDJd0Ev7mHX2C1avi+HBn/O
ACYxbI6ecjWjDMEa1EWxZqyTRf241q2xx5hS/XJXVEtKMu4pbIM0v0vfzGeY9S1I
TrPPJk6t0EY1D2qwl/2l47f8X4Csa9WgQy6ZvQUj9KnlVnW/+M9mnAY3hiErka7n
hobzlPBmEoh6MuTr7odq+Z0QoGnXisMle6tQgsD6lXPsNTOW80ougTv0RcoV2924
SoXFBSK8S7QIwnPUajGzJ56l3i8OslaJGNP6NLnwsJuwRqMzJeZ/TirvgWvmH1Ks
YzSLbVnAwCmx6Xk7jJ9wb+MzqN7akvDZjfoK5R6/lcqzMfG0Ka+gj5XXQEN/nGhk
xBe2vSCd14f9jjB6OJyMeqE9TwOo8msT+VfiT5hhzORIsOivZO9O86TfTDvBnytB
NuAgNvXT8gH0mZhdZrMZsRRG5USSus9YVIxSCEbtZyhsKyx/99qs4OviAvzY9zUz
uxKAOGumsQrVmiSklznQSYacK4KL15/ubmss7Zc5HKWX/89r9BAczzl4yx83c4xF
6mbDiO7+yXaFU+0eaUOUwx8x1jXWaMY43NLlx10Oo14jxqOOgxhfKq9+UVB9wS7l
fYo42W3egmB33bdWQuZ8apXmLqMzupx5XpL352G3rbvvbT6Na/DP2wRAqLntfnpm
woNEvjX+1sFy+wvRcpyQSsuOHVO/xrrQYLlyLUKbUnPW9A6IAVw45hbWM+KheWL+
MJTIurrJMHz+A8eMnW9Z9TM2EldvNKPyjpBJ6Qt0kyHDKnnJp5JBCg8QpPxQIboq
POFvMOT3fPiiRsrTvPVM6ODLdmXk6Fy8WbtX10FTkTak78I1rbNc72dkietZuOcb
ePKDlBo/RUbERe9V52IWhJsw2aZURvU0nDVp2O9uekAC3mTIyNi0g5hlk7fvlF/i
s5g+x0FEqPwQyghqU8LOy9oZGV9slnYZTEP0PjR1vGDl297mJ8pClbrCdPwQcrSC
3IMXwUvoeRnNLYAfCVrvnfLITNDa26aU73KTLCnpNcgg1eDbj87YFm1An04J49l6
91iX+R7pjqmuj4i73qOoZhOcLuopGCuKneMqPNQl0puLHT9/5igmZOgkllhTiWrj
624VVdLsF6ZfbFYN8UeBfBLoml5tr8/XGTyO8zh/SmpGJL49W09vj2ecPcF2IW6H
LJ3cfWcTtmKtguW9xXmUwKNSSlkX+s+muu/jNgP6Qt6HVZI5rLMNqr86hgFFX/OH
k3DNVyhSipaWRKYzObZf1JUeFvE+ScOX4wgKCpy/2CXewmnBoJmbadvJJUBMvzYg
mYfJjOCzvfaL5FV+MtKQ3ICz4rOOrqFVWMcxXovjWG+A2LHtaFW5Zwc0BXdcmFyj
mnVKgf9sf8/wBLGh0korfz2IFpV8aFZnTXApx9bJJqj72Q5i6jjClwgXyzeuiuxb
mYJfoz+lNOlInNjRw58AonJXirdTrX8ahk/M/83QSgr24tkbUWs6jT/FOlgsJ6Qk
n+s6si9/K9y60I/tGQqPnwfTV3IJx+LIb42jqFUtoHk=