Oracle中alter system命令参数之scope

    技术2022-07-11  65

    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(),重启数据库来生效。

    U2FsdGVkX1+jJKP9bWOqgeGr+zmLcf0m5JrYpbLmoiO3O2GLXNxKggTycqI5h8Gz 3YR0SHueJzoT/MgXygX8FEhm1WXmfbN2WrNKXrSQ7nf/h48We59cgyFW7Ape6+79 PpWZREG8ZKHMMyaJoNjzfusNoYKUZYOkRNGHNggNu6bv+HuAQytY8ChAGM637dlM dOdH1vOBqiezZ4JsjZ5RumXvxEXoOaUdjA2AeQkzlmOg7aDV2iOE12hSjKFzmKdF Wsii8dWpj6OZ/nmFgQhiBcUzUr754nJcWqXXwwNzuaPyLQ6xXWWQcr+8kK6N2fNn exZRq6S95cO5/3+ApQDUw5QPyVa2WQ3VARRJ1Uq6NsRnNUuadyEEIH5KY4HK1kqQ ZDE3wMiV/TCiU2Q/86634ivofUORBgDd+wenVFLVb0Yl3n7Chuy/abMEJwdFpqzI ajWRANi6ixwyavZ7oUgs1vMqUu6JKx5oSfXP99bjwL4nwBnDgzv3qc1aN5uosAKN sAtRLqaoD7TPb1kWpjMEPfblXBXojT4g4Px00cyMMB6KiL2piAyLumfBIL4qpZwG OcGaJs9hc63bfEpgJbwqStfxGTegIMzki54rEUa/eLJXABlN9prYc9dety+zML7X ujLl+5ciBUV5wg4wTldu2spz3V5L9z3WH6vYKMNWOnQ4tPRqLZWV6tyeUwmn5HMx gCXvWEmd3aTY9E+V+dsYkjqinCDokjNEsn196c2Uc+LflZzhBQW2U1b4lIT+rFOz jmMYBxURTxvlufZWeZoX94eCGgsdrSnkjhQoNFNkOrlzHVfTKWBpkS6HndibrELq j4gap38JxoNLhdSlLOPr+0WErohcYU2r/O5dkmOI6bNVHzhKabQ2wHq77q0roJKp oLl5HB3kpsRtjk7R5ECzZAPQTVZOYHB5wQGSAwr2/WYYia1dhy3Gq9ljnfV4S/ev UhTBB9PpjI40wgU7HAlJEsMI6UhmEDmxueoNag7P3kLdE5KbBv8Qg3ltslyikxZD NBeJZBcH+5xG4Asz8HlxiC+GIK7KnD5+qdF9XjVyCi3OXDvuQSR2jM9LpM6ZkTyX rXa83clQAH2ppbwaSpPIrZQnvnPPR+M9YqCIVNj/Y+iqnxUPwgHwG0QxoVsxEADs B8lXL5AIX90/Ra7mfguvN5Wcbp//e+8lDcFizWM2/taebcSe7ssfXQWsszyo1oV8 IhUTepBsOplzAltYPiEurY2hIEBFOlFOSpm8lIF/zypmqq9jZHRZPB71g4QePz4G 06p78M4Fxo+M1PDKa8KcTccbxPrE/wvxCxggWGvFtpFW6C4hVj417CyvXXIgjJ/o y8tP5+C62j0POD47k1KYH52hWh1OaBzdn8LYLIHA57d3YzYv8V+UOJNtumA5bpUO GVTCwkYbrK9aySK9FUxV5rph9OZ6gcgyds7nYd5gs30bXOPGtquMOn9bQWEU9/SP RCVgpI2YkhQvsFy8PQvAh6C6ur5yN3COA7q7SQph7kbnW93zLQVQCvIEKG2b75BL aNRgVhNGiR3uOAigDp4yZFmx2QjMZMZDUC3pKiWaPbM802rQ7oNSaYysYAOYoLXp OyH+vP36wpxHaTOGPNKgLfLdPn3qJ8SkzRCx9bUxKoKKgKaVPtI2P2vgQ+Zwomj4 pcyqiaLjFE1r4tRjVznK/pi7eAZp65NdhJCWenFKgvzDa/Lw/YZGAUvWvtnpmYwY dSZnJsAXjWLu0XAixwSq2rbiVFbzybriKb7W0ev0wvV9JZeNiDWUAH1yXCOv5P7L Ku/OxwiqfDoxw9sRHRCXVzjgFHezVdQppf0VxThPqamgj15ato439GBUBR4wPo0x Fwy8C1J+jCR+tNVB9051PIoO9l/rNfrNu9xf+X6HyHUOr3eeBPiQHScyWfEZbTnV oO0EX3kjQoWJ3kQuP7WB6CaC2bk7kwbimjRSRgsxIXYq/EnPrE6BKgyLgmhAt8Jl rtc0fjQwKXIo14nomgtcLl/Ulp2wb+DnfuAwBUOjfmBLz5GEkQcO9OViPJrl8Ts7 g6/pj4FVf5Js0B2koI8pV0SFkbQplMTyZ+lRcojMFWaOhI+f77zOTIuGrwHphAWy I/FAYB49Dm9aeMWdYZMgJ364iWUa1Ei2A/sNKlDkEVhk6olqH8ud/BlNpkt+0hZC 5kw3Igwb4DGhWDRkXEY+0ZqMYzdf7wDHAiHg6hx9hfrsB3Ck0+FbNok37NqHycQ6 YrNF0NUl1v4lXPh8OXR/4Kduw/W7rZB/DPKsbHMdRS/AkLpM0Xp5owxn1L0g4Vcc HALlAZLoH7PzabYp0pyRHybht4KKRjGzOFqFbvRXmUWJm7TDfiyyBzuWKyUSzYDf VxKVUCoH2gtch3V9cfT2LqrsdVoGfqbGAf5emtGIKYuuPOPrPOBbQ6thJgzVUyA1 rMrk8Pzq40qAJ1yIZZpKuG+mS/NTehp2W70I7DPV8OrQoUJ4u1254NsWWEzbBSBf dfyDpiAtsr3xKoHgVYA3/hBgUQNpH6KYZmx3oIHwPGRnCy3q6F6N35NAU6PtaDYu 6qNYdLrg0j9u40SHPEfXJ1A0ww2HvNMn70Oqhzbv3R0CI5SmUjluKKuGSdYVR20p XuvwLnXrPXkm1816TiAuFyjJxr9Qn/uLnDwLjvAmYGU7fdr9HSbLaF7ahe9wNY6l 7+UHnbcimklrkMp9ma9BD7dOdZnbXADrAGSnf63GLuEeVwWWQ+JaSsynRV/adJoi q+9wu4GMndXsxviaZQUyE82PqzmjCJmdbWcd0ZUYZT5IZa0DLILtiH6pOc6BMIkS Jeh/sNQl0Axgt1vVNc2y6nFkFf33+tUNnt1NhWTygdRWXdepjEyAfUvNXxrV+Nvw 3zp6Zvkegk/HUT8Ac/9GILyj9Q+paKRORMP4rs5JSrGsBjaAumAlsvdc5jg29Ed8 I7KfOf/B7aYIaX/CdJgEAObbNGQCcLQUZYK8D/arCkcnTyZeYcNGZ2lck0cyMiR4 rTZ7N6OXSLuXCDw2KP2OkJ53/+lz+O9u1HGsQT+IbVdibxi89jdAUQZMxb7buA6u Bv5ZN/90CMGqLN/EYxe8rylEE+5ib6scdrvKwzyf/e3fAifl7ZG7SoGWQEUaVsNr biwjSLgG/kprnzzwjxRUJ5f3M1a2Sdue9Nh7FHn6RWQ2vQluZ39krK6iSjbS1NCa q4oU2/mUmVk0QaFpu4bThoVFleujz11iC/YusM6AyI2JOm7Cm5srkP0G1IC1Lt9t 6pCY+qNYVVvP3U6aUdGOwxxSK54K55XqF8T+AGnPZSF3feX/Gd3J/I32UJGn1sUB MYTOulzYLLuwt/QV4q1fjMD9Dy7Y/YOx/znEofyxE8zSCL/RpH/nUEHy1gcBGvGL N2tjYSswgr6/XHrhfXthu8PCaDzPee+3mNf9UVAVfblc9HZtWlFGGKHUPuwaNICQ GL5Zf72JKs/ZkMBwtIAOCW9fgjpBGSB+f1e2JANXzJzGmJsJpOV5nuEB8/yu/DHB eKIxYqolie3YNyTGWv+iYBgLXqZC0+qFBFtbSx6QPYeUI+c6VBQLXzLGXsBGCVs7 wlAprHu9k5zpzfJ3dE7k3+wkfDnQg3k4NnF3mXKMfIZTLpEdigEzmC0fgQQN5rTL LkjQIMElHbqzMcWae+fHCGuoJkQivYcdxGganz2Iig/W/CmJ4np7/6vfY74SodiT fWF8LX0jNUqLqPgUQEIa+94JiwxCWdgf6wDxuZ9ijWKCQG6MRm4PNeZ+PMkGlNH0 /foiJO2jFdjKU2vBPhH8bYK6AuQX6uCDAoeXQRvJRhsrsJ3mMXaAxoeZQvI3CMcE mrEZd0ShwlJc5+yKnFyiQO+qJNFSo1dygpc+63x5K2iEkmBjIfKIAtAhHyLhcwsz Qlr7fpCcMN7V2wN+iud5/tTOP0tDAWTmI/YMcRntgwJICBAx2CkgAUuPGEUw5s/J aNF74cUgZ1TW44ub3ab73m3XWEpIXJmR7k+o7YtSURP2SH+HwxmoHru00/qR+kqR JjAGFk7uRulxCOYPFEbbmfQa2KCgv4zM6RO5UIbMx2zMI8AuhdzXSLU1d9sxkY4n sGPMOa0PsCDke/GGMUWG3NJ0IHJRqQA7nD2zANMo25ooeweeHoXsOgvgHuC4kYUA ByhxyRFBfnoknk60XUfKQv71wQ4Q8kLww3/Toooqpxc/hHJoQX/b8wf8Iq7BD+qw FygZwHLaAww1FfE42mIAZttWad3OZsFLiv3QixVlNBvkngu7SoMtNBXM98mrjtMk AtGFwXxCncfu4o2VDQcP6y9IMV/7WU97Mtm9JlRqilneS3o/KNnx4sT0XBKjWSNv IMaB6r05ed2YqHQYYPxosRO+ZfNzlKCkFIFLMoVnUVm3Hz2iaf5BqcKSp5QNW0Lr c+ks8ulYqxz/wd8cyk/obYxv4VwjFPl8sfAsnE1zR7OaZ88qO25A17nWzWw3KzEL JGj7npPkH4F8Jy1xkx/Xh76q3IsWm+h/Ru7YVxnkZXOAboVoW1ndsVku3WuWSV87 0Grk1pFd2pXdeAhLhUAgpd/623e4wu1owKYdVHEJo9q4OzsO0KLPTXj61JeW+uMS

    Processed: 0.012, SQL: 9