Duration

How long will my database upgrade take? Revisited …

Posted on March 17, 2020 by Best Practice 6

I received this question twice within a few days. And I remember that a tiny little while ago I wrote something on the blog about it. But as this “while” is 11 years ago, I came to conclusion to refresh this topic – and write something about How long will my database upgrade take? Revisited …

How long will my database upgrade take? Revisited ...

Photo by Aron Visuals on Unsplash

Is there a query?

At first, before I go into details, an important fact upfront: There is neither any query nor any tool giving you a rough estimate or precise figure of how long your upgrade will …

Continue reading...

Why does the upgrade of PDB$SEED always take longer?

Posted on July 10, 2017 by Single-/Multitenant Upgrade / Migration 0

Upgrading the PDB$SEED takes always longer than any other container.
What is the reason for an upgrade of the PDB$SEED taking so much longer in a real world environment?

How does an upgrade with Oracle Multitenant work?

Upgrading the PDB$SEED takes always longerI have written several blog posts in the past about the different techniques to upgrade an Oracle Multitenant environment:

  1. Upgrade Everything At Once
  2. Upgrade via Unplug/Plug/Upgrade

The interesting case happens in the “Everything At Once“. The PDB$SEED takes significantly longer to upgrade than any other container.

Upgrading the PDB$SEED takes always longer?

Quick recap: The PDB$SEED is the (I call it) blueprint …

Continue reading...

Upgrade downtime credited to APEX

Posted on September 1, 2015 by APEX 5

What do you think when you see this post-upgrade result?

Oracle Database 12.1 Post-Upgrade Status Tool           08-07-2015 15:08:26

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.1.0.2.0  00:19:26
JServer JAVA Virtual Machine              VALID      12.1.0.2.0  00:10:52
Oracle Workspace Manager                  VALID      12.1.0.2.0  00:01:52
OLAP Analytic Workspace                   VALID      12.1.0.2.0  00:00:34
OLAP Catalog                         OPTION OFF      11.2.0.3.0  00:00:00
Oracle OLAP API                           VALID      12.1.0.2.0  00:00:42
Oracle XDK                                VALID      12.1.0.2.0  00:01:07
Oracle Text                               VALID      12.1.0.2.0  00:01:36
Oracle XML Database                       VALID      12.1.0.2.0  00:03:55
Oracle Database Java Packages             VALID      12.1.0.2.0  00:00:22
Oracle Multimedia                         VALID      12.1.0.2.0  00:03:57
Spatial                                UPGRADED      12.1.0.2.0  00:08:56
Oracle Application Express                VALID
… Continue reading...
Mike Dietrich
Oracle Senior Director of Product Management for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 8,089 other subscribers

Follow me on Twitter