[10g] SCOPE Option in ALTER SYSTEM Phrase

/****************************************************************************************************************
-- Title : [10g] SCOPE Option in ALTER SYSTEM Phrase
-- Reference : dba-oracle.com
-- Key word : alter system scope both spfile memory
****************************************************************************************************************/

SCOPE = SPFILE

(For both static and dynamic parameters, changes are recorded in the spfile, to be given effect in the next restart.)

SCOPE = MEMORY

(For dynamic parameters, changes are applied in memory only. No static parameter change is allowed.)

SCOPE = BOTH

(For dynamic parameters, the change is applied in both the server parameter file and memory. No static parameter change is allowed.)