Question: How can I use the Oracle
parallel upgrade utility in Oracle 12c?
Answer: You can use the Oracle upgrade
utility in 12c to allow you to leverage processing on
servers with multiple CPU's. To install the parallel
upgrade utility, you need to run this dictionary script:
SQL> $ORACLE_HOME/diagnostics/catupgrd.sql
Now you are ready to run the Oracle parallel upgrade
utility, a Perl script called catctl.pl:
SQL> ORACLE_HOME/perl/bin/perl
catctl.pl -n
8 -l
The 11g catupgrd.pl is replaced by the
catctl.pl utility, and it is run automatically by the
Database Upgrade Assistance (DBUA), or it can be executed
manually.
In the example above, the "8" indicates the maximum
parallel degree, and you you omit this positional parameter
the default is parallel degree of 4.
This new utility promises to greatly speed-up Oracle
upgrade operations.
