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 

Oracle Multitenant – 12 Jul at Orient event

I will present entitled “Oracle Multitenant” at an event organized by Orient ITM
The presentation agenda as below.














Announcement photo of this event. (in Azerbaijan Language)
















Regards
Mahir M. Quluzade 

The LGWR Three Second Rule. Really?

Does the Oracle Database 12c Log Writer Really Sleep For Three Seconds?

I have learned the part of Oracle Database performance tuning is checking if what you have been taught is actually true. What I'm writing about today has been done before in Oracle Database 10g and 11g, but I wanted to document this using 12c.

When I was first learning about the Oracle Database process architecture, the instructor said there are a number of (more...)

OTech Magazine – Spring 2014 Released!

OTech Magazine is an independent magazine for Oracle professionals. OTech Magazine is a trusted source for news, information and analysis about Oracle and its products. Our readership is made up of professionals who work with Oracle and Oracle related technologies on a daily basis, in addition we cover topics relevant to niches like software architects, developers, designers and others.OTech Magazine‘s writers are considered the top of the Oracle professionals in the world. Only selected (more...)

My article on GPO (Grupo de Profissionais Oracle) Portal

GPO (Group Oracle Professionals) - The greater Oracle community in Brazil. GPO portal is a comprehensive portal implemented with various technologies and various topics on Oracle Technologies.
GPO (Grupo de Profissionais Oracle) Portal : http://www.profissionaloracle.com.br/gpo


My article published on GPO (Group Oracle Professionals) portal. 
And it is my GPO profile :  (more...)

Where Does v$osstat Get It’s Data? Trustworthy?

OS Data Without An OS Prompt


Have you ever wanted to get OS data from within Oracle Database 12c/11g/10g and without being at the OS prompt? Have you ever wondered where v$osstat gets it's data?

I have! It's the kind of stuff I think about all the time. In fact, I was so fascinated by what I found, I included the details in my online seminar, Utilization On Steroids. It's that cool.

What Is So (more...)

Oracle Database 12c: What happens during CDB startup if one the PDB has a media problem? – Continue

During Oracle Day 2014  (February 05, 2014, which was held in Baku/Azerbaijan), I met with my friends and had a conversation about several topics.

I asked to my friend Teymur Hajiyev, what happens during CDB startup if one the PDB has a media problem? He said, CDB must open without a problem. But you need to open PDBs manually. In other words, by default PDBs in mount mode, you need call alter pluggable databases all (more...)

Installation and configuration Patch 17552800 – 12.1.0.1.2 Patch Set Update

Hi,

Patch 17552800 - 12.1.0.1.2 Database Patch Set Update released: January 14, 2014. You can download this PSU  from Oracle My Support. I will show short steps installation and configuration this PSU.

1. Download this patch set zip file from support web site and copy to database server.

My Oracle Support

[oracle@oel62-ora12c PSU1]$ pwd
/tmp/oracle/PSU1
[oracle@oel62-ora12c PSU1]$ ls -l
total 67952
-rw-r--r-- 1 oracle oinstall 69580299 Feb 12 09:17 p17552800_121010_Linux-x86-64.zip
(more...)

OTN Article : Oracle Database 12c – Transporte de “Tablespaces” de “11.2.0.3” a “12.1” ( Parte III )

OTN (Oracle Technology Network) Spanish published our next article. Oracle Database 12c – Transporte de “Tablespaces” de “11.2.0.3” a “12.1” ( Parte III ) by Joel Perez (Oracle ACED) and Mahir M. Quluzade (OCE)

 (Published : January 2014)








You can read article from : http://www.oracle.com/technetwork/es/articles/database-performance/transporte-tablespace-11-a-12-part3-2111105-esa.html


Regards
Mahir M. Quluzade