Tuesday, 15 December 2015

Oracle Data Pump in RAC

Oracle Data Pump was introduced in Oracle Database 10g to enable very high-speed transfer of data and metadata between databases. A salient feature of Data Pump is that it can parallelize the export and import jobs for maximum performance.

However, prior to Oracle Database 11g release 2 (11.2), if a Data Pump job is executed in parallel on an instance of an Real Application Cluster (RAC) database, the parallelism is employed only on that instance without utilizing the potentially valuable idle resources of other instances.

From Oracle Database 11.2 onwards, parallelism is no longer confined to a single instance. Rather worker processes can be distributed across multiple Oracle RAC instances to better utilize Oracle RAC resources. The newly-introduced client parameter CLUSTER can be employed to specify whether you want to use the cluster resources. When CLUSTER=Y (default) is specified, Data Pump attempts to use all active Oracle RAC instances.

Thursday, 19 November 2015

Strong Oracle Database 12c Wiping Away the Competition

49% of Oracle’s total software revenues in FY14 came from database software. As Forbes mentioned in their article Strong Database And Application Software Sales Could Lift Oracle Higher, the company commands a market share of nearly 48% in the well established and mature Relational Database Management System market.

Strong Oracle Database 12c Wiping Away the Competition

Monday, 12 October 2015

Pseudo cursors and invisible SQL

Do you ever wonder why Oracle Enterprise Manager and AWR reports show the SQL text for some SQL IDs as not available?

Pseudo cursors and invisible SQL

Friday, 17 July 2015

New Features of Oracle NoSQL

“In open source, we feel strongly that to really do something well, you have to get a lot of people involved.”

Currently, there are about 150 NoSQL databases (= Not Only SQL).

There are 5 major NoSQL data models: Collection, Columnar, Document-oriented, Graph and Key-value.

Oracle NoSQL, based on BerekelyDB (first release in 1994), was recently named by Forrester Research as a leader in the NoSQL key-value database market and Oracle NoSQL Database was called out as having strong adoption and maturity. A very good study and comparison of several NoSQL databases entitled 21 NoSQL Innovators to Look for in 2020 was written by Gary MacFadden.

Wednesday, 20 May 2015

Oracle REST Enables Oracle Database and Oracle NoSQL

Oracle REST Data Services version 3.0 is now generally available. Oracle REST Data Services (ORDS) enables a consistent RESTful interface to Oracle Database's relational tables, JSON document store, and also enables access to Oracle NoSQL Database tables.

“Oracle REST Data Services (ORDS) 3.0 dramatically reduces the complexity of building service based access to an Oracle Database,” said Michael J. Hichwa, Vice President of Oracle Database Tools.  “ORDS has been gaining momentum since first released in 2010, and release 3.0 is by far our most significant. Prior to release 3.0, ORDS required you use Oracle Application Express (APEX) to define your RESTful web services, now with ORDS 3.0 you can alternatively or additionally define RESTful web services from SQL Developer.  I urge everyone to see how elegant it is to define RESTful web services based on SQL that return JSON results.”

Wednesday, 8 April 2015

Table Temperature, Big Tables In-Memory and Automatic Big Table Caching

If you have never heard of Oracle object temperature and how this relates to caching, in-memory and big tables, here is a short note perhaps worth reading.

And all this is purely Oracle database related, nothing to do with Oracle Lighting Products.

Table Temperature, Big Tables In-Memory and Automatic Big Table Caching

Friday, 16 January 2015

Big Data SQL for Oracle NoSQL Database


We recently announced Oracle Big Data SQL support for Oracle NoSQL Database. This feature will allow Oracle Database users to connect to external data repositories like Oracle NoSQL Database, and/or Hadoop, and will enable them to fetch data from any or all of the repositories (at once) through single SQL query. We believe this a significant step forward as it streamlines the adoption of big data technologies with traditional technology stack.

If you are following big data space then you would agree that everyone likes the scalability, availability, performance at cost aspect of it but almost everyone struggles to modify their enterprise application to work with big data technologies because they don't talk the same language as traditional database systems do.

Wednesday, 14 January 2015

The 7 Initialization Parameters Related to the IM Column Store

I often see and hear claims how many times faster Oracle 12c IM is compared to whatever. Although, the numbers are rather realistic than wishful thinking, I must say that all that strongly depends on how the IM option has been set up.

Besides the way you set up the tables, the MVs and the tablespaces, there are 7 init.ora parameters that directly affect the behavior, performance and speed of the inmemory option.

The 7 Initialization Parameters Related to the IM Column Store