|
 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 8 - RAC Administration
Undo Management in RAC
The undo tablespace can also be defined after
the database is created, as shown here in this example:
Create UNDO
tablespace UNDOTBS_3
DATAFILE ‘/u01/oracle/rbdb1/undo_3’ SIZE 512M ;
If an undo tablespace runs out of space, or if
you want to prevent it from doing so, you can add files to it or
resize the existing data files. The following example adds a data
file to the undo tablespace undotbs_3:
ALTER
TABLESPACE undotbs_3
ADD DATAFILE ‘/u01/oracle/rbdb1/undo_31‘ SIZE 128M ;
Initialization Parameters for
UNDO management
The initialization parameters shown in Figure
8.6 are relevant for undo management.
The above text is
an excerpt from:
Oracle 10g Grid & Real Application
Clusters
Oracle 10g
Grid
Computing with RAC
ISBN 0-9744355-4-6
by Mike Ault, Madhu Tumma
|
