LATEST POSTS
-
23c – Simplified PDB hot cloning in a Physical Dataguard environment
In one of the previous articles I superficially mentioned a relevant limitation in the combination of Multitenant + Dataguard in 19c: It simply cannot execute a synchronized hot cloning (primary cloning cascading to the standby). Today we are going to address that issue in detail, and we will discover an important improvement that we find…
-
23c – Floating PDBs – The Lab
The main objective of this laboratory is to understand the behavior of PDBs (Pluggable Databases) and services based on their configuration, particularly focusing on a “floating PDBs” configuration. We are interested in observing if the clusterware properly distributes the PDBs and their services during startup, verifying the behavior in case of a node failure in…
-
23c – New RAC Floating PDBs
One of the fundamental milestones achieved by the Oracle Multitenant architecture (CDBs and PDBs) is the ability to online rebalance resources between databases; CPU, memory, and even IO (throughput or IOPS). For example, with multitenant, we can immediately rebalance free memory from one PDB to another; something that is currently impossible to do between two…
-
New Multitenant CPU management
Hello friends. Before starting this new article I want to thank you for the nice words and support you have shown for the blog. Today I bring you a topic that I particularly find really interesting. Maybe it is a bit long, but it is worth it. So make yourself a coffee and enjoy! Database…
-
19c – The mystery of Snapshot Carousel (Ch.2)
In the previous chapter we explained the reasons why the snapshot carousel feature still has significant limitations in Oracle 19c Release. While I particularly think the feature concept is certainly interesting, these limitations will probably prevent us from implementing such architecture. However, if we could know the SQL commands that snapshot carousel executes – since…
-
19c – The mystery of Snapshot Carousel (Ch. 1)
Oracle has taken a giant step forward with the introduction of the container architecture (aka multitenant). The core set of operations with PDBs is now well known to DBAs, who are beginning to see operations such as a “PDB hot clone” or “Refreshable PDBs” as part of their routine. But beyond that core set of…
ORACLE AND ME NEWSLETTER
Sign up to receive an email whenever I publish a new post. Eventually several times a month.
Oracle and Me 