First page Back Continue Last page Graphics
…Persistent Parameters
3 options to the SCOPE clause
MEMORY
- Default
- Change is immediate
- SPFILE is not changed; change lost at shutdown
- Only valid for dynamic parameters.
SPFILE
- Update SPFILE only
- Change takes effect next startup
- Only valid option for STATIC parameters
BOTH
- Update memory (immediate) and SPFILE
- Only valid for dynamic parameters
Notes:
The SCOPE clause is used to indicate the desired persistence of the change. Valid options for SCOPE are SPFILE, MEMORY, and BOTH.
Valid SCOPE values:
MEMORY will make the change for the current instance only. The SPFILE will not be changed. This option can be used for dynamic parameters only. Default.
SPFILE will make the change in the SPFILE but will not take effect until the next shutdown-startup cycle of the instance. This option can be used for both dynamic and static parameters.
BOTH will make the change for the current instance (memory) and will update the SPFILE also. This option can be used for dynamic parameters only.
Note: Dynamic parameters were introduced in Oracle8. See the next page for examples of determining if a parameter is dynamic.