The Oracle pre-upgrade utility performs a simple verification of
the major database components prior to running a database and
You can see the Oracle pre-install utility in your rdbms/admin
You can run the Oracle pre-upgrade utility from SQL*Plus:
SQL > connect sys/xxx as
SQL> spool preupgradeutility.txt
SQL > spool off
The Oracle pre-upgrade utility is great for beginners because if
verifies some important pre-existing conditions for an Oracle
- Inspects your initialization parameter for the
pre-install checklist, detecting hidden and deprecated
parameters that will not work in the upgraded release. The
pre-upgrade utility also detects too-small values for important
pool parameters (e.g. java_pool_size)
- Verifies the existence and sizing for your system,
sysaux and temp tablespaces.
- Verifies that you have created valid optimizer
statistics (using dbms_stats), detecting "stale"
statistics. BEWARE: If you have no problems with SQL execution
plans, you may not want to re-analyze your statistics.
The Oracle pre-install utility is not a full replacement for the
pre-upgrade manual and checklist, because it does not detect missing
parameters and new settings, but the Oracle pre-upgrade utility does
provide a minimal check.
MOSC note 884522.1
describes the details for using Oracle Pre-upgrade Utility.
An Oracle upgrade is still tricky and should not be attempted by
an inexperienced DBA. For a reliable and certified Oracle upgrade,
BC can provide
remote and on-site Oracle upgrades in just a few hours.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.