OTech Magazine Winter 2015 Released

OTech Magazine issue Winter 2015 is the tenth – and last – issue of OTech Magazine – the independent Oracle technology magazine. In this last issue of OTech Magazine we offer you 10 highly technical articles on Oracle technology.




My "Automatic Gather Statistics for Bulk Loads" article also published in this issue. Automatically gathering statistics enhanced within Oracle Database 12c Release 1. My article covers this feature of Oracle Database 12c Release 1 with examples (more...)

Apply DB OVJM PSU + Queryable Patch Inventory Demo

Oracle started releasing OVJM component of  DB PSU in October 2014, and recommend applying OVJM PSU along with (or after) DB PSU. I will demo applying DB PSU, and OVJM PSU on 12.1.0.2 database. Use this opportunity to introduce you to Queryable Patch Inventory (DBMS_QOPATCH), where you can query OPatch information directly from the database. […]

NoCOUG Journal – November 2015

Another edition of NoCOUG journal came out. In this issue, for the Many Things Oracle column, I introduce the new background processes in DB 12c and few SQL Developer tidbits… Read here… This is fifth installment of Many Things Oracle column in NoCOUG journal. The past articles are: NoCOUG Journal 2015 AUG: Trace File Analyzer [Magazine] NoCOUG Journal 2015 MAY: […]

Invisible Columns in Oracle Database 12c

In May 2014, the following #oratidbit relating to invisible columns were tweeted. In #DB12c, you can make a column in table as INVISIBLE. When you make it invisible, the COL# column in COL$ dictionary is updated to 0, thus is not included in the “SELECT *” or “INSERT INTO VALUES”, unless specifically selected. When you […]

Critical Background Processes in Oracle Database 12c

There are several background processes running when you start Oracle Database 12c instance. Here is an example from one of the 12.1.0.2 instances.    ora_acms_bt9prod1  ora_lreg_bt9prod1 ora_p00w_bt9prod1  ora_aqpc_bt9prod1  ora_m000_bt9prod1  ora_p00x_bt9prod1  ora_asmb_bt9prod1  ora_mark_bt9prod1  ora_p00y_bt9prod1  ora_cjq0_bt9prod1  ora_mman_bt9prod1  ora_p00z_bt9prod1  ora_ckpt_bt9prod1  ora_mmnl_bt9prod1  ora_ping_bt9prod1  ora_dbrm_bt9prod1  ora_mmon_bt9prod1  ora_pmon_bt9prod1  ora_dbw0_bt9prod1  ora_o000_bt9prod1  ora_ppa6_bt9prod1  ora_dbw1_bt9prod1  ora_p000_bt9prod1  ora_ppa7_bt9prod1  ora_dbw2_bt9prod1  ora_p001_bt9prod1  ora_psp0_bt9prod1  ora_dbw3_bt9prod1  ora_p002_bt9prod1  ora_pxmn_bt9prod1  ora_dbw4_bt9prod1 […]

OTN Article: Oracle Database 11g: “Client Failover” en “Standby Databases” (in Spanish Language)

Oracle Technology Network Latina started publish our new article series about Oracle Database 11g: Client Failover with  Standby Database

Part I: http://www.oracle.com/technetwork/es/articles/database-performance/client-failover-standby-database-2660858-esa.html














It is my first article published on OTN Latina after awarded Oracle ACE. 
My special thanks to my friend Oracle ACED Joel Perez (Venezuela) for all supports. 


Also you can watch video tutorial in this topic:



Best Regards
Mahir M. Quluzade

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

Changing The Number Of Oracle Database 12c Log Writers

Changing The Number Of Oracle Database 12c Log Writers


In an Oracle Database 12c instance you will likely see multiple log writer (LGWR) background processes. When you first start the Oracle instance you will likely see a parent and two redo workers. This is a very big deal and something many of us have been waiting for - for many years!

While I'm excited about the change, if I can't control the number of LGWRs (more...)

Off May Not Be Totally Off: Is Oracle In-Memory Database 12c (12.1.0.2.0) Faster?

Off May Not Be Totally Off: Is Oracle In-Memory Database 12c (12.1.0.2.0) Faster?


Most Oracle 12c installations will NOT be using the awesome Oracle Database in-memory features available starting in version 12.1.0.2.0. This experiment is about the performance impact of upgrading to 12c but disabling the in-memory features.

Every experiment I have performed comparing buffer processing rates, clearly shows any version of 12c performs better than 11g. (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...)