First page Back Continue Last page Graphics

Persistent Parameters…


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