First page Back Continue Last page Graphics
Persistent Parameters…
SPFILE provides persistent parameter initialization
“Persistent” : change persists even after shutdown
SCOPE=BOTH changes current instance and SPFILE
- Only valid for dynamic parameters
Optional COMMENT can be seen in v$parameter file
Notes:
SPFILE provides another new feature: persistent parameter initialization. This means that you can use the ALTER command to change a parameter – and that change will be in effect the next time you start the database! The new SCOPE clause of the ALTER SYSTEM command allows us control exactly how the change should take effect. In the example above, “BOTH” is used to tell Oracle to put the change in effect in memory (immediate) and in the SPFILE as well. So, the next time we startup, the change persists and the shared pool will still be 12M.
Also, the COMMENT clause has been added to allow the ability to associate comments with a particular change. Comments can be displayed using v$parameter or the new v$spparameter.
1 select update_comment
2 from v$parameter
3* where name = 'shared_pool_size'
SQL> /
UPDATE_COMMENT
------------------------------------
changed on 5/1/03