Home -> Mailing Lists -> Oracle-L -> RE: 12c upgrade slow

RE: 12c upgrade slow

From: Lange, Kevin G <kevin.lange_at_optum.com>
Date: Mon, 5 Nov 2018 17:36:17 +0000
Message-ID: <9FEE65EE2766CC4A85A8AE7A8EAF0A0D7F296602_at_APSWP0431.ms.ds.uhc.com> 








I have been upgrading our multiple 10g databases to 12.2 or a while now.  Here are the few things that I have come to make sure of on each upgrade:



    
  
  1.   Gather Dictionary and Fixed Object Stats before hand.  Makes a difference

  
  2.   12 seems to take considerable more memory than 10 did.  I have had to raise up SGA and PGA values considerably.

  
  3.   Processes had to be raised .  It seemed that the upgrades were slower at lower processes setting

  
  4.   Larger rollbacks with more groups.   I used to have 4 groups with relatively small files in them but when I changed that to 10 groups with larger files the upgrades sped up






Some of these suggestions may not be thought of as being something that would cause a faster upgrade, but it did it on our setup so I leave it to you to consider or not.



Kevin



From: oracle-l-bounce_at_freelists.Stats org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeff Chirco
Sent: Monday, November 05, 2018 10:59 AM
To: oracle-l-freelistI


Subject: 12c upgrade slow



I am working on upgrading a database from 11.2.0.4 to 12.2.0.1.  Single instance non CDB.  The upgrade is taking 2 hours and 50 minutes.  I am running the command line version of the upgrade and using parallel.  Any tips to make this go faster? I already have APEX 18.1 installed however I am noticing it is becoming invalid during the upgrade and I have to reinstall it afterwards.



Thanks



This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.


--
http://www.freelists.org/webpage/oracle-l


Received on Mon Nov 05 2018 - 18:36:17 CET












Original text of this message