How to SET TIMING ON for parallel upgrades to 12c?
- by Mike Dietrich
Have you asked yourself how to get timings in an Oracle Database 12c upgrade for all statements?
When you run the parallel upgrade via catctl.pl, the parallel upgrade Perl driving script in Oracle Database 12c, you may also want to get timings written in your logfile during execution. As catctl.pl does not offer an option yet the best way to achieve this is to edit the catupses.sql script in $ORACLE/rdbms/admin as this script will get called all time over and over again throughout all steps of theupgrade run.
Just add these lines marked in RED to catupses.sql and start your upgrade:
Rem =============================================Rem Call Common session settingsRem =============================================@@catpses.sql
Rem =============================================Rem Set Timing On during the UpgradeRem =============================================SET TIMING ON;
Rem =============================================Rem Turn off PL/SQL event used by APPSRem =============================================ALTER SESSION SET EVENTS='10933 trace name context off';
-Mike
PS: This may become the default in a future patch set
