How to SET TIMING ON for parallel upgrades to 12c?

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 settings
Rem =============================================
@@catpses.sql

Rem =============================================
Rem  Set Timing On during the Upgrade
Rem =============================================
SET TIMING ON;

Rem =============================================
Rem Turn off PL/SQL event used by APPS
Rem =============================================
ALTER SESSION SET EVENTS='10933 trace name context off'
;


-Mike

PS: This may become the default in a future patch set ;-)


Comments:

Mike,
Thanks for the tip and excellent documents on upgrades. I want to ask you a question but couldn't easily find where to ask. So I am posting here.

I am reading your 519 page pdf file named "Upgrade, Migrate & Consolidate to Oracle Database 12c".

I am certainly going to read every line from this pdf and prepare my upgrade steps. My question is, you will certainly get lot of inputs from users and you may change or add content to this pdf. I really can't check any changes you made to pdf by reading entire document.

Is there any way you can help people like me to quickly read what is changed in future versions?

May be you can also have a version number too in this document.

Thank You
Giridhar

Posted by Giridhar on November 29, 2013 at 11:55 AM CET #

Giridhar,

once the new version of the slides will get uploaded (End of December) I will add a "change log" at the end as I have done this in the past for the 11g slide deck as well. That will make it easier for readers to see at a glance what has been changed since their last version.
And the slide deck has always an "Last Updated" tag on the title slide (see at the bottom of the picture to the right).

Cheers, Mike

Posted by Mike on November 29, 2013 at 01:23 PM CET #

Post a Comment:
Comments are closed for this entry.
About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers