The remaining task for the DBA is sizing the undo tablespace. Data dictionary views such as
V$UNDOSTAT and the Undo Advisor can help the DBA adjust the size of the undo tablespace.
Multiple undo tablespaces may be created; for example, a smaller undo tablespace is online
during the day to handle relatively small transaction volumes, and a larger undo tablespace
is brought online overnight to handle batch jobs and long-running queries that load the data
warehouse and need transactional consistency. Only one undo tablespace may be active at
any given time.
As of Oracle 11g, AUM is enabled by default. In addition, new PL/SQL procedures are
available to supplement the information you get from the Undo Advisor and V$UNDOSTAT.
Advanced Initialization Parameters
The advanced initialization parameters include the balance of the initialization parameters not
listed here, for a total of 283 of them in Release 1 of Oracle Database 11g. Most of these can be
automatically set and tuned by the Oracle instance when the basic initialization parameters are
set. We will review some of these in the appendix (???Installation and Configuration???).
This page intentionally left blank
CHAPTER
2
Upgrading to Oracle
Database 11g
49
50 Oracle Database 11g DBA Handbook
f you have previously installed an earlier version of the Oracle database server,
you can upgrade your database to Oracle Database 11g. Multiple upgrade paths
are supported; the right choice for you will depend on factors such as your current
Oracle software version and your database size.
Pages:
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138