During
the upgrade process to Oracle 11g, the data dictionary will be analyzed if it has not been
analyzed already, so performing this step in advance will aid the performance of the upgrade. For
an Oracle version 10g database, you can use this procedure invocation to gather dictionary stats:
EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
Using the Database Upgrade Assistant
You can start the Database Upgrade Assistant (DBUA) via the
dbua
command (in Unix environments) or by selecting Database Upgrade Assistant from the Oracle
Configuration and Migration Tools menu option (in Windows environments). If you are using a
Unix environment, you will need to enable an X Window display prior to starting DBUA.
54 Oracle Database 11g DBA Handbook
When started, DBUA will display a Welcome screen. At the next screen, select the database
you want to upgrade from the list of available databases. You can upgrade only one database at
a time.
After you make your selection, the upgrade process begins. DBUA will perform pre-upgrade
checks (such as for obsolete initialization parameters or files that are too small). DBUA will then
create the SYSAUX tablespace, a standard tablespace in all Oracle 10g and 11g databases. You
can override Oracle??™s defaults for the location and size parameters for the datafiles used by the
SYSAUX tablespace.
DBUA will then prompt you to recompile invalid PL/SQL objects following the upgrade. If
you do not recompile these objects after the upgrade, the first user of these objects will be forced
to wait while Oracle performs a run-time recompilation.
Pages:
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146