Menu ☰
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 …

Oracle 12cR2 ( New Features ): Near-Zero Downtime PDB Relocation

Hi Readers To get the same result as unplugging and plugging a PDB from a remote source CDB into another CDB, you can take advantage of the Oracle Database 12.2 feature such as near-zero downtime PDB relocating. In Oracle Database 12.1, unplugging and plugging a PDB requires several steps such as unplugging the PDB from …

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 …

Oracle Cloud Onboarding Guide for IT Organizations

Oracle Cloud Onboarding Guide for IT Organizations 面向IT组织的Oracle云入职指南   By Joel Peréz Skant Gupta This article is brought by en.enmotech.com   This is very important document that everyone must read before going to Cloud: http://www.oracle.com/webfolder/technetwork/tutorials/cloud_onboarding/Cloud_Onboarding_Guide_for%20IT_Organizations.pdf     Enjoy the reading!   If you want to be updated with all our articles send us the Invitation or …

Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using RMAN Cross-Platform Transportable PDB

By Joel Peréz Skant Gupta   This article is brought by en.enmotech.com   This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible.   To migrate an Oracle Database 12c PDB to a PDB in an …