| Mark D Powell 2005-08-23, 9:23 am |
| Angela, in what frame of reference should we take "global change" to
apply?
One way I can think of the term being used would be in changing
database parameters. Many database parameter values can be changed at
the session level or instance wide. An instance wide change would be a
"global" change.
alter session set global_names = FALSE
aler system set global_names = FALSE scope=both
The first command affects only my session while the second immediately
takes affect accross the entire instance. Some parameters can be
changed and take affect immediately while others require the instance
to be bounced to take effect.
See the SQL manual entries for ALTER SESSION and ALTER SYSTEM plus see
the Oracle version# Reference manual for the database parameters.
Another possible use of the terminology might be related to the taking
of global checkpoints. RAC system coordinate checkpoints accross
instances in order to facilitate recovery operations should they be
necessary. There are RAC manual that should provide more details if
this is along the lines you want.
HTH -- Mark D Powell --
|