Adaptive Query Performance Fixes for #DB12c Release 1

We all know adaptive query feature introduced in Oracle Database Release 1 is a problem. Recently I had the opportunity to review few 12cR1 databases and found that to alleviate the performance problems, the DBA set parameter OPTIMIZER_FEATURES_ENABLE=11.2.0.4 in Oracle Database 12c Release 1 (12.1.0.2). This observation is the catalyst for the blog “Adaptive Query […]

ODC Appreciation Day: Two Cool 12c Security Features #ThanksODC #ThanksOTN

There are quite a lot of new features in the 12c database that I like and have discussed and talked about them at various events. On this #ThanksODC day, I would like to take the opportunity to thank Oracle Technology Network (or Oracle Developer Community) and Oracle ACE Program for all the support they provide […]

I’m speaking at OTN EMEA Tour 2017 Baku



Local Oracle User Groups from the EMEA region are cooperating for the fourth year in a row to organize a tour of the region. The OTN EMEA Tour brings a star-studded cast, consisting of some of the world’s best Oracle ACEs, ACE Directors and Rock Star Speakers to the region. Azerbaijan Oracle User Group (AZEROUG) also joined EMEA Tour since last year (2016). This year also will be organize OTN EMEA Tour 2017 Baku (20th, (more...)

Oracle Database 12.2 New Features (Part I) – Application Express

As you know, Oracle Open World 2016 conferences continue at San Francisco (September 18-22, 2016).

At keynote Session, Larry Ellison (CTO of Oracle Corporation) annoucemented the Oracle Database Exadata Express Cloud Service on new database version 12.2. Here is released cloud documentation

There have very interesting little guide for new features of Oracle Database 12c Release 2.
Why littel , because it is not all features of Oracle Database 12c Release 2, have more interesting (more...)

TROUG Days 2016 Istanbul

I attended TROUG Days 2016 Istanbul which is organized Turkish Oracle Users Group as a speaker. It is very amazing conference. I meet my friends during conference.

I talked about In-Memory & Multitenant features of Oracle Database 12c. 
I want thank to organizers of  TROUG Days and attenders. I want share some my photos from conference: 














See you my friends at next events and conferences.

Best Regards
Mahir M. Quluzade

OTN Article: Oracle Database 12c: "Colección automática de estadísticas para cargas masivas"

Oracle Technology Network continue publish our article. My next article published OTN Latina in Spanish language.



You can read this article at : OTN Latina
Oracle Database 12c: "Colección automática de estadísticas para cargas masivas"


You can read this article also in English : http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.html


My special thanks my friends Joel and Sebastian ! 

Best Regards
Mahir M. Quluzade

TROUG Days Istanbul 2016 Agenda is online!

TROUG Days Istanbul 2016 Agenda now online, published at http://www.troug.org/wp-content/uploads/2016/02/Agenda.pdf

I'll speaking at TROUG Days Istanbul 2016, Apr 28th, 14:30 Hall A, ITU Teknokent.
My topic is Oracle In-Memory with Multitenant.





See you at TROUG Days Istanbul 2016!

Best Regards
Mahir

First meeting of AZEROUG in 2016 year!


I'm speaking at AZEROUG (Azerbaijan Oracle Users Group) Meeting February 27th, 2016 at Qafqaz University/ Baku, Azerbaijan. I'll speak about amazing Oracle Database option In-Memory.

See you !

Best Regards
Mahir 

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

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

This page has been permanently moved. Please CLICK HERE to be redirected.

Thanks, Craig.

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!

(more...)

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

This page has been permanently moved. Please CLICK HERE to be redirected.

Thanks, Craig.

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