The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB). This article describes how to connect to container databases (CDB) and pluggable databases (PDB).
Tuesday, April 11, 2017
Wednesday, March 22, 2017
Emergency Monitoring in Oracle Enterprise Manager Cloud Control 12c
The Emergency Monitoring feature of Enterprise Manager Cloud Control 12c is an evolution of Memory Access Mode from Grid Control 11g, allowing you to access in-memory statistics. In EM12c you no longer need to explicitly enable memory access mode. Just navigate to the page and wait while it makes a diagnostic connection to the database and performs lightweight analysis. The screen contains information that will help analyze performance issues, even if the database is hung and you can't connect to the normal performance pages.
Thursday, March 2, 2017
Interval-Reference Partitioning in Oracle Database 12c Release 1
In previous releases you were able to do reference partitioning and interval partitioning, but you couldn't use an interval partitioned table as the parent for a reference partitioned table. Oracle 12c lifts that restriction, so you can now use interval-reference partitioning.
Thursday, February 9, 2017
Multitenant : Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB) in Oracle Database 12c Release 1
The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB). This article covers the options for migrating a non-CDB/PDB database to a PDB.
Sunday, January 29, 2017
Multitenant : Create and Configure a Container Database (CDB) in Oracle Database 12c Release 1
The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB). This article covers the options available to create a new container database.
Tuesday, October 11, 2016
Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c
The Active Session History (ASH) was introduced in Oracle 10g to provide real-time diagnostics information. ASH Analytics is a feature of Enterprise Manager Cloud Control 12c, which visualises ASH information, making it even simpler to diagnose performance problems.
ASH requires the Diagnostics and Tuning option in Enterprise Edition.
ASH requires the Diagnostics and Tuning option in Enterprise Edition.
Posts
