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 of automatically collect statistics of objects when bulk load operations.

You can read my article from: http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.html

My special thanks to my friend Douwe Pieter van den Bos (owner of OTech Magazine) for all efforts.

Best Regards
Mahir M. Quluzade


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


OTN Article: Oracle Database 12c In-Memory (Part I, II - 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 and Second parts of Oracle Database In-Memory article series published in 2 language (Spanish/Portuguese) same time.

In Spanish Language

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

In Portuguese Language

Part I; http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-12c-in-memory-2595527-ptb.html
Part II: http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-in-memory-part2-2595874-ptb.html

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

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. I don't want review this article, but there have about interesting new feature of Oracle Database 12c.   

Tom wrote:

The fact that the NOW column of the query against USER_TABLES is the same as the LAST_ANALYZED column shows that statistics were created as the data was loaded—this is a new feature of Oracle Database 12c. Since Oracle Database 10g, the database has been computing statistics automatically for indexes when you create or rebuild them. With Oracle Database 12c, the database does the same for tables. Further, as you can see in the example in Listing 1, there are basic statistics on the columns in the table as well.

I want share my test environments outputs with you:

[oracle@oel62-ora12c2 Desktop]$ export ORACLE_SID=prmcdb
[oracle@oel62-ora12c2 Desktop]$ sqlplus "/ as sysdba"

SQL*Plus: Release Production on Tue Aug 4 17:32:00 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options

SQL> select banner from v$version; 

Oracle Database 12c Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version - Production


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 think in the future can provide on 12c version  
  • Choice of 5, 20, and 50 GB database storage (1GB for trial account) 
I subscribed to Oracle Database Cloud Service. 

After completed my order, my Oracle Database Cloud Service - S20 activated

  • Includes Oracle Application Express (APEX), version 4.2.6, a highly productive browser based application development framework for creating responsive applications with SQL and PL/SQL 
  • Data access using RESTful Web Services 

I'm using Oracle APEX  since 2003 year (HTMLDB2 - first name of  APEX), it is my favorite rapid Database Development tool included into Oracle Database. You can use RESTFul Web Services after 4.2 version of Oracle APEX.