You should review your database initialization parameters to make sure deprecated and
obsolete parameters have been removed; these should have been identified during the migration
process when you ran the Pre-Upgrade Information Tool utlu111i.sql. Be sure to recompile any
programs you have written that rely on the database software libraries.
Once the upgrade has completed, perform the functional and performance tests identified
before the upgrade began. If there are issues with the database functionality, attempt to identify
any parameter settings or missing objects that may be impacting the test results. If the problem
cannot be resolved, you may need to revert to the prior release. If you performed a full backup
before starting the upgrade, you should be able to easily revert to the old release with minimal
downtime.
?–
?–
?–
?–
?–
This page intentionally left blank
CHAPTER
3
Planning and Managing
Tablespaces
61
62 Oracle Database 11g DBA Handbook
ow a DBA configures the layout of the tablespaces in a database directly affects the
performance and manageability of the database. In this chapter, we??™ll review the
different types of tablespaces as well as how temporary tablespace usage can drive
the size and number of tablespaces in a database leveraging the temporary tablespace
group feature introduced in Oracle 10g.
We??™ll also show how Oracle??™s Optimal Flexible Architecture (OFA), supported since Oracle 7,
helps to standardize the directory structure for both Oracle executables and the database files
themselves; Oracle Database 11g further enhances OFA to complement its original role of
improving performance to enhancing security and simplifying cloning and upgrade tasks.
Pages:
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157