Menu ☰
Oracle 12cR2 ( New Features ): Cloning Remote PDBs in Hot Mode

Hi Readers Cloning Oracle Database 12.1 PDBs to get a test PDB required the source PDB to be in read- only mode, which was nearly unacceptable on a production PDB. The new Oracle Database 12.2 technique copies a remote source PDB into a CDB while the remote source PDB is still up and fully functional. …

Oracle 12cR2: Upgrading a CDB Including PDBs from 12.1 to 12.2

Hi Readers   When we talk about Multitenant arquitecture, Upgrade is one of the many advantages using it. Let’s see how we can upgrade a CDB Including PDBs from 12.1 to 12.2. Let’s see how to do it..     To upgrade the CDB and PDBs from Oracle Database 12.1 to Oracle Database 12.2, use the …

Oracle 12cR2: Enhancements in PDB Unplugging and Plugging

Oracle 12cR2: Enhancements in PDB Unplugging and Plugging   Hi Readers   In Oracle Database 12.1, when a PDB is unplugged, all the data files associated with the PDB along with the PDB manifest must be copied or moved individually over to the remote server where it will be plugged into another CDB. With Oracle …

How Well a Query Optimizer Handles Subqueries?

How Well a Query Optimizer Handles Subqueries? 查询优化器如何处理子查询?   Hi Readers   When we talk about a database, we think immediately in saving information.. and secondly in fetching information.. for the second one the backbone are the queries..  subqueries.. etc, if you are DBA or Developer.. We think this article is for you..   How …