Oracle Multitenant

Queries on dictionary tables are slow in Oracle Multitenant?

I love to learn something new every day. And on Friday afternoon last week I learned something new again. It started (as often) with a very simple question from a colleague working from the Oracle Malaga office in Spain. The customer has an issues with some queries being slower than before once they moved from on-prem to the cloud into a PDB. But are queries on dictionary tables are slow in Oracle Multitenant generally?

Queries on dictionary tables are slow in Oracle Multitenant?

Photo by Pascal van de Vendel on Unsplash

What was the case?

The customer ran some queries against dictionary views in the PDB in Oracle Database …

Upgrade to Oracle Database 19c – Virtual Classroom Series

Posted on June 16, 2020 by Mike.Dietrich Workshop 22

Roy and I delivered a similar seminar already for the Australia and New Zealand region. And now it is time at a more convenient time zone setting for EMEA and India. So if you are not tired of web seminars yet, please sign up for our Upgrade to Oracle Database 19c – Virtual Classroom Series.

Upgrade to Oracle Database 19c - Virtual Classroom Series

Photo by Bima Rahmanda on Unsplash

4 Web Seminars – Going far beyond upgrades

The idea for this series of 4 web seminars is to cover not only the database upgrade itself. You will get much more than technical upgrade information. And we will …

Save Patching Downtime with Oracle Multitenant?

Posted on December 2, 2019 by Mike.Dietrich Best Practice Patch Recommendation Single-/Multitenant 8

At OOW 2019 we announced that you can have up to 3 user-created pluggable databases (PDBs) per container database (CDB) without having a Multitenant license. And in this blog post I’d like to demonstrate how you can save patching downtime with Oracle Multitenant.

The Concept

The idea this entire process settles on is very simple. When you create a fresh container database in the target (already patched!) environment, you don’t have to patch this one. You only have to relocate the PDB from the source into the target CDB. In addition, only datapatch needs to be executed. As the …

Database Migration from non-CDB to PDB – Overview

Posted on July 22, 2019 by Mike.Dietrich Single-/Multitenant 7

Today I’ll start a blog post series of several “how to” articles about database migration from non-CDB to PDB – Overiew. You’ll find a quick introduction below. And of course, the links to all the other related blog posts.

Database Migration from non-CDB to PDB – Overview

When you plan to move from non-CDB, the Oracle term for regular database deployments, to a Pluggable Database (PDB), you will migrate your database. It will become a PDB and run as part of a Container Database (CDB). This is a well known concept for several years now called Oracle Multitenant. If you …

Can you simply switch from SE2 to EE with Oracle Multitenant

Posted on July 18, 2017 by Mike.Dietrich SE2 - Standard Edition 2 Single-/Multitenant Uncategorized 10

This question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?”

Yes, you can!

First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements:

Both database versions must be the same
Both databases must have the same character set (in Oracle Database 12.1)

That’s it. Simply unplug your Standard Edition 2 PDB and plug it into your Enterprise Edition CDB.

In addition you may have to run several component …

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

Posted on July 10, 2017 by Mike.Dietrich 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 longer I have written several blog posts in the past about the different techniques to upgrade an Oracle Multitenant environment:

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 …

Oracle Multitenant

Upgrade to Oracle Database 19c – Virtual Classroom Series

4 Web Seminars – Going far beyond upgrades

Save Patching Downtime with Oracle Multitenant?

The Concept

Database Migration from non-CDB to PDB – Overview

Database Migration from non-CDB to PDB – Overview

Can you simply switch from SE2 to EE with Oracle Multitenant

Yes, you can!

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

How does an upgrade with Oracle Multitenant work?

Upgrading the PDB$SEED takes always longer?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts