Menu ☰
12 Things You Need to Know about Oracle Database 12c R2

12 Things You Need to Know about Oracle Database 12c R2 Hi Readers At these times we are talking already about Oracle18c, however most of production systems are in 11g,, 12cR1.. 12cR2.. so.. We think you will love this material. Enjoy Connor McDonald Talking about Oracle Database 12c R2 https://go.oracle.com/LP=60882?elqCampaignId=92113https://go.oracle.com/LP=60882?elqCampaignId=92113&src1=:ow:lp:sh:em::LPD100664923NLP3&intcmp=OUNV170405P00034:ow:lp:sh:em::LPD100664923NLP3 Ask Tom Answer Team (Connor McDonald and …

Oracle 12cR2: Cross-Platform PDB Transport Using XTTS

Oracle 12cR2: Cross-Platform PDB Transport Using XTTS Hi Readers Let’s see how we can perform this process: Verify the prerequisites: The source PDB must be closed in MOUNTED mode and the COMPATIBLE parameter must be set to 12.2 or higher. Start an RMAN session and connect to the CDB instance of the PDB to be …

Oracle 12cR2: Cross-Platform Transportable PDB

Oracle 12cR2: Cross-Platform Transportable PDB Hi Readers Oracle Database 12.1 allows you to transport database or tablespace backup sets with conversion at source or destination for same endian platforms. Oracle Database 12.2 includes cross-platform PDB backup and restore into a CDB by unplugging at backup step and plugging at restore step as long as the …

Oracle 12cR2: Upgrading a Single Regular PDB from 12.1 to 12.2

Upgrading a Single Regular PDB from 12.1 to 12.2 Hi Readers  You can also upgrade a specific PDB without upgrading the whole CDB: Prepare the PDB to be unplugged and upgraded in another CDB by executing the same jar file as in the previous slide but only on the PDB. The fixup scripts and log …

Oracle 12cR2: Controlling the Degree of Parallelism of Queries

Controlling the Degree of Parallelism of Queries Hi Readers  Oracle Database 12.2 introduces a new instance parameter to control the Degree of Parallelism of queries, which involves a containers() construct. By default, a query involving a containers() construct uses a DOP that is equal to the following value: In the case of a query in …

Oracle 12cR2 (Tip): Local UNDO Mode Versus Shared UNDO Mode

Local UNDO Mode Versus Shared UNDO Mode Hi Readers Using the local UNDO mode is required when cloning a PDB in hot mode or performing a near-zero downtime PDB relocation or refreshing PDBs or using proxy PDBs. You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB …