Oracle Database 12c: Statistics created as the data was loaded

As you know, Oracle Magazine July/Aug 2015 issue released. You can free subscribe to Oracle Magazine digital edition and you can read here or you can read technical  articles here.

I subscribed Oracle Magazine, in current issue have very interesting articles.

One of interesting article of Oracle Expert Tomas Kyte (as known AskTom) with title: On Learning from Mistakes


In this article Tom talks about Cost Based Optimizer and shown how optimizer learning from mistakes. (more...)

Database Schema as a Service – Oracle Cloud

Cloud computing is known for many things: cost effectiveness, flexibility, scalability.

Oracle Cloud provides several Oracle Database offerings. Choose between a single schema based service, or a virtual machine with a fully configured running Oracle Database Instance, or Exadata Service with all the database features, options, and workloads.
Oracle Cloud Provide Database schema Service as: 
  • 1 Schema on Oracle Database 11g
I don't know, can we request on Oracle Database 12c Release 1. But I (more...)

OTN Article: Oracle Database 12c In-Memory (Part I, Spanish / Portuguese)

Oracle Technology Network Latina started publish our new article series about Oracle Database In-Memory. This articles is first about In-Memory in OTN Latina articles.

First part of Oracle Database In-Memory article series published in 2 language (Spanish/Portuguese) same time.

In Spanish Language

http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-in-memory-2595521-esa.html





In Portuguese Language

http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-12c-in-memory-2595527-ptb.html





My special thanks to Joel Perez (Venezuela), Flavio Soares (Brazil) and Sebastián D'Alessandro (Argentina).

Regards
Mahir M. Quluzade

OTech Magazine Summer 2015 Issue #8 Released!

Independent Oracle Technology Magazine OTech Magazine Summer 2015 Issue Released. Second part of my Oracle Database In-Memory article series published in this issue.



You can read my article here 

I want thank to all author for all efforts. My special thanks to Douwe!


Regards
Mahir M. Quluzade


Oracle Database 12c – Active Duplication with RMAN (in Spanish Language)

Oracle Technology Network - OTN Latina published our "Pull-Based Active Duplication with RMAN" article series this month in Spanish Language. This article series covers new option of duplication with RMAN on Oracle Database 12c Release 1 (12.1.0.1) in 11 parts.



First part of article series described "how to duplicate database" and other parts showed different cases of CDB and PDBs duplication.You can read articles here


 Oracle Database 12c: Active Duplication con RMAN (more...)

Oracle Database 12c – Active Duplication with RMAN

Oracle Technology Network - OTN Latina published our new article series this month in Portuguese Language.

This article series covers new option of duplication: Pull-Based Active Duplication with RMAN on Oracle Database 12c Release 1 (12.1.0.1) in 11 parts.





First part of article series described "how to duplicate database" and other parts showed different cases of CDB and PDBs duplication.You can read articles here



 Oracle Database 12c: Duplicate em modo (more...)

OTech Magazine Winter 2014 Issue Released!

OTech Magazine Winter 2014 Issue is a more than one hundred page independent Oracle technology magazine especially designed for the holidays.  First part of my Oracle Database In-Memory article series also published in this issue.



You can download the Winter 2014 issue of OTech Magazine here

My special thanks to Oracle ACED Douwe Pieter van den Bos for all efforts. 

Best Regards
Mahir M. Quluzade

OTN Article Series: Oracle Data Guard 12c – Redo Gap Resolutions

OTN - Oracle Technology Network Latina America published our next technical articles series. This article series cover Redo Gap Resolutions in Oracle Data Guard 12c entitled in Portuguese language as Oracle Database 12c – Resolução de Redo Gap (Part I, II)  written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE).


This article series consists of two parts. You can read articles from following links in Portuguese Language.




 Oracle Database 12c – Resolução (more...)

OTN Articles: Oracle Database 12c: “Nuevas Características para Desarrolladores”

OTN - Oracle Technology Network Latina America published our next technical articles series. This article series cover new features of Oracle Database 12c for developers, entitled in Spanish language as Oracle Database 12c: “Nuevas Características para Desarrolladores” written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE).

This article series consists of three parts.



You can see very useful examples for every new feature in this article series. So, Part I of this article (more...)

OTN Article: Oracle Database 12c: Que sucede en un CDB cuando uno de los PDB obtiene un problema?

OTN - Oracle Technology Network Latina America continue publish our articles. Our 8th technical article published on OTN in Spanish Language at 28th August. This article entitled : Oracle Database 12c: ¿Que sucede en un CDB cuando uno de los PDB obtiene un problema? written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Bruno Nuñez (OCE).

It is a link of article: http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-cdb-problem-pdb-2279196-esa.html







Thanks to my friends, Joel and Bruno, for their all efforts and thanks to OTN. 

Regards
Mahir M. Quluzade

OTN Article : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado


OTN - Oracle Technology Network Latina America continue publish our articles. Our 7th technical article published on OTN in Portuguese Language at 20th August. This article entitled : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Rodrigo Mufalini (Oracle ACE) .


It is a link of article: http://www.oracle.com/technetwork/pt/articles/database-performance/cdb-quando-pdb-tem-ser-recuperado-2270042-ptb.html




Thanks to my friends, Joel and Rodrigo, for their (more...)

OTech Magazine Issue #4: Summer 2014 Published


OTech Magazine - The independent magazine for Oracle professionals. Yesterday fourth issue of the OTech Magazine, the independent magazine for Oracle professionals published.



 In this issue also included my article: Oracle Database 12c: Cross Platform Transport non-CDB to PDB using RMAN Backup Sets





You can download online OTech Magazine #4 Isssue - Summer 2014

Summary of article

We can create a PDB using upgraded database (non-CDB) and can be adopt the 12.1 non-CDB into (more...)

Oracle Multitenant – PDB State Management Across CDB Restart (12.1.0.2.0)

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).
This article covers PDB State Management in Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2) .

As you know, any pluggable database (PDB) not open in READ WRITE mode by (more...)

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:
  1. PDB Containers Clause
  2. PDB Standbys Clause
  3. PDB Logging Clause  (as soon)
Part II: PDB Standbys Clause

PDB (more...)

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:

  1. PDB Containers Clause
  2. PDB Standbys Clause
  3. PDB Logging Clause  (as soon)

Part I: PDB Containers Clause

The (more...)

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:
  1. Excluding Data When Cloning a PDB
  2. Non-CDB Adopt to CDB as a (more...)

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. In 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 three part: 
  1. Excluding Data When Cloning a PDB
  2. Non-CDB Adopt to CDB (more...)

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. In 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 three part: 
  1. Excluding Data When Cloning a PDB
  2. Non-CDB Adopt to CDB (more...)

Oracle Database 12c Release 1 (12.1.0.2) New Features


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 (more...)

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

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