Posts

Showing posts from July, 2014

Oracle Multitenant - PDB New Clauses - Standbys (12.1.0.2) - Part II

As you know, Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014.
You can download new release from here.

Oracle Multitenant option also supports some news in Oracle Database 12c Release 1 (12.1.0.2.0).
With new release coming new PDB Clauses.

This article series covers following new clauses:
PDB Containers ClausePDB Standbys ClausePDB Logging Clause  (as soon)Part II: PDB Standbys Clause
PDB Inclusion in Standby CDBs feature is coming with Oracle Database 12c Release 1 (12.1.0.2).

The STANDBYS clause of the CREATE PLUGGABLE DATABASE statement specifies whether the new PDB is included in standby CDBs. You can specify one of the following values for the STANDBYS clause:

ALL includes the new PDB in all of the standby CDBs.NONE excludes the new PDB from all of the standby CDBs.
When a PDB is not included in any of the standby CDBs, the PDB's data files are offline and marked as unnamed on all of the standby CDBs. Any new standby CDBs that are instantiated afte…

Oracle Multitenant - PDB New Clauses - Containers (12.1.0.2) - Part I

As you know, Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014.
You can download new release from here.

Oracle Multitenant option also supports some news in Oracle Database 12c Release 1 (12.1.0.2.0).
With new release coming new PDB Clauses.

This article series covers following new clauses:

PDB Containers ClausePDB Standbys ClausePDB Logging Clause  (as soon)
Part I: PDB Containers Clause

The CONTAINERS clause in PDB enables you to query user-created tables and views across all PDBs in a CDB.The tables and views, or synonyms of them, specified in the CONTAINERS clause must exist in the root and in all PDBs and must be owned by the common user. A query that includes the CONTAINERS clause must be run in the root.

Follow examples:

[oracle@oel62-ora12c2 ~]$ export ORACLE_SID=prmcdb [oracle@oel62-ora12c2 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 24 16:02:21 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected …

Oracle Multitenant - PDB Clone New Features (12.1.0.2.0) - Part III

As you know, Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014. You can download new release from here.

With this new release coming some new features. This article series covers PDB Clone new features of Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2.0).

This article is in four parts:
Excluding Data When Cloning a PDBNon-CDB Adopt to CDB as a PDB.PDB Subset Cloning PDB Snapshot Cloning (as soon)Part III. PDB Subset Cloning

Sometimes we using many schemas that each supported a different application in a database (Schema Consolidation).  With Oracle Database 12c coming new option Oracle Multitenant, which is helpful for simplify consolidate databases.Database Consolidation means, each pluggable database (PDB) support a different application and all pluggable databases adopted in same Multitenant Container Database (CDB).

If we move a non-CDB to a PDB, and the non-CDB had different schemas that each supported a different application, t…

Oracle Multitenant - PDB Clone New Features (12.1.0.2.0) - Part II

As you know, Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014. You can download new release from here.

With this new release coming some new features. This article series covers PDB Clone new features of Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2.0). 
This article is in four parts:  Excluding Data When Cloning a PDBNon-CDB Adopt to CDB as a PDB.PDB Subset Cloning PDB Snapshot Cloning (as soon)
Part II. Non-CDB Adopt to CDB as a PDB.

The new release of Oracle Multitenant fully supports remote full and snapshot clones over a database link. A non-multitenant container database (CDB) can be adopted as a pluggable database (PDB) simply by cloning it over a database link.

This feature further improves rapid provisioning of pluggable databases. Administrators can spend less time on provisioning and focus more on other innovative operations. Follow examples:
I'll create a PDB using database link from following non-CDB:

Oracle Multitenant - PDB Clone New Features (12.1.0.2.0) - Part I

As you know, Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014. You can download new release from here.

With this new release coming some new features. This article series covers PDB Clone new features of Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2.0). 
This article is in four parts:  Excluding Data When Cloning a PDBNon-CDB Adopt to CDB as a PDB.PDB Subset Cloning PDB Snapshot Cloning (as soon) Part I:  Excluding Data When Cloning a PDB
We can create clone of PDB with CREATE PLUGGABLE DATABASE ... FROM statement from existing PDB. All clones of PDB contains all object definitions and data in PDB. Sometimes we need quickly creating clones of a PDB with only the users object definitions and no data. New NO DATA clause included the CREATE PLUGGABLE DATABASE ... FROM statement in 12.1.0.2.0 version. The NO DATA clause specifies that a PDB's data model definition is cloned but not the PDB's data. When you using NO DATA Clause in�…

Oracle Database 12c Release 1 (12.1.0.2) New Features

Image
Oracle Database 12.1.0.2 is available for download now.  here

1. Advanced Index Compression

Advanced Index Compression works well on all supported indexes, including those indexes that are not good candidates for the existing prefix compression feature; including indexes with no, or few, duplicate values in the leading columns of the index.

Advanced Index Compression improves the compression ratios significantly while still providing efficient access to the index.

2. Approximate Count Distinct

The new and optimized SQL function, APPROX_COUNT_DISTINCT(), provides approximate count distinct aggregation. Processing of large volumes of data is significantly faster than the exact aggregation, especially for data sets with a large number of distinct values, with negligible deviation from the exact result.

The need to count distinct values is a common operation in today's data analysis. Optimizing the processing time and resource consumption by orders of magnitude while providing almost ex…

OTN Article : Oracle Database 12c – Nuevas Características de "Oracle Partitioning"

Image
Oracle Technology Network - OTN (Latina America) published our 6th article in Spanish Language.
This article entitled : Oracle Database 12c – Nuevas Características de "Oracle Partitioning") 
by Joel Perez (Oracle ACED) and Mahir M. Quluzade (OCE)  Published : 17 July 2014

Article link : Oracle Database 12c: Nuevas Características de “Oracle Partitioning”
This article covers a bit new features of "Oracle Partitioning" on Oracle Database 12c (12.1)















Regards Mahir M. Quluzade

Oracle Multitenant - 12 Jul at Orient ITM

Image
I presented entitled "Oracle Multitenant" at an event organized byOrient ITM.  (Baku, Azerbaijan).

What is Oracle Multitenant?

A new option for Oracle Database 12c, Oracle Multitenant delivers a new architecture that allows a multitenant container database to hold many pluggable databases. An existing database can simply be adopted with no application changes required. Oracle Multitenant fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard.

The many pluggable databases in a single multitenant container database share its memory and background processes. This enables consolidation of many more pluggable databases compared to the old architecture, offering similar benefits to schema-based consolidation but with none of the major application changes required by that approach.

Creating pluggable databases, moving pluggable databases between containers, and cloning pluggable databases are done with new SQL commands and take just…