Note that this method requires that the data be stored in multiple places at once, thus impacting
your storage needs.
To improve the performance of this method, you may consider the following options:
Disable all indexes and constraints until all the data has been loaded.
Run multiple data-copying jobs in parallel.
?–
?–
Chapter 2: Upgrading to Oracle Database 11g 59
Use the parallel query option to enhance the performance of individual queries and inserts.
Use the APPEND hint to enhance the performance of inserts.
As of Oracle 10g, you can use cross-platform transportable tablespaces. When transporting
tablespaces, you export and import only the metadata for the tablespace, while the datafiles are
physically moved to the new platform. For very large databases, the time required to move the
datafiles may be significantly shorter than the time required to reinsert the rows. See Chapter 17
for details on the use of transportable tablespaces; see Chapter 8 for additional advice on
performance tuning.
After Upgrading
Following the upgrade, you should double-check the configuration and parameter files related to
the database, particularly if the instance name changed in the migration process. These files include
The tnsnames.ora file
The listener.ora file
Programs that may have hard-coded instance names in them
NOTE
You will need to manually reload the modified listener.ora file if you
are not using DBUA to perform the upgrade.
Pages:
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156