Michael,

alter system set blah=blah;
shutdown;

That is, if you don't set scope=spfile or make the change in the
init.ora,
then the change is not persistent across db bounces.

Matt

On Wed, 2006-01-04 at 14:41 -0500, Michael Porter wrote:

> I'd like some example(s) of where rebooting the db will/could result in "changes not recorded permanently and hence likely to be lost". If there is such a thing, I better be getting my resume up to date...
>
> M


----------------------------------------------------------------
|Matthew W. Ball (Matt)
|Team Lead for Infrastructure and Reliability Group
|Endeavor Information Systems Inc.
|(e) [Email address protected]
|(p) 847-227-2678
|(f) 208-275-0869
|(u) http://www.endinfosys.com
--------------------------------------------------------------
#define THE_QUESTION
(( (bb) || ! (bb) ))
- W. Shakespeare
--------------------------------------------------------------

Oracle LazyDBA home page