Instance Tuning Steps These are the main steps in the Oracle performance method for instance tuning: Define the Problem Examine the Host System and Examine the Oracle… Read More »Oracle Instance Tuning Using Performance Views
Oracle AWR, Snapshots and Baselines in Automatic Workload Repository. AWR collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This gathered data… Read More »Oracle AWR, Snapshots and Baselines
The output below shows the current status of the pluggable databases in the primary and standby databases. — Primary COLUMN name FORMAT a30 SELECT name,… Read More »Controlling PDB Replication in Data Guard
PDB Memory Parameters The following parameters can be set at the PDB level. DB_CACHE_SIZE : The minimum buffer cache size for the PDB. SHARED_POOL_SIZE : The minimum… Read More »Memory Management for PDBs
We duplicate a pluggable database using the RMAN DUPLICATE command using the PLUGGABLE DATABASE clause. This comes in two basic forms, depending on whether we want to retain the… Read More »Duplicate PDB to an existing CDB
Prerequisities Make sure you have all the OS prerequisites in place by running the 19c preinstall package. On Oracle Linux you can do this by… Read More »Upgrading Multitenant Database to Oracle 19c
Prepare the PDB for Upgrade The PDB must be prepared for upgrade, then unplugged from the source container databases. Switch to the “cdb1” instance in… Read More »Upgrade PDB using Unplug/Plugin
Flashback of Container Database (CDB) The basic procedure for performing a flashback database operation on a container database (CDB) is the same as that for… Read More »Flashback in Oracle CDB and PDB
When connecting to a PDB to perform backup and recovery operations, the RMAN connection will look like the following. Notice the password prompt as no… Read More »Backup and Recovery in CDB and PDB
In multitenant environments there are two types of user. Common User : The user is present in all containers (root and all PDBs). Local User… Read More »Manage Users and Privileges in CDB and PDB
Manage Tablespaces in a CDB Management of tablespaces in a container database (CDB) is no different to that of a non-CDB database. Provided you are… Read More »Manage Tablespaces in CDB and PDB
Configure Instance Parameters in a CDB (ALTER SYSTEM) Configuring instance parameters for a CDB is not much different than it was for non-CDB databases. The ALTER… Read More »Configure Instance Parameters for CDB and PDB