From Las Vegas to Ottawa

After a very engaging session at Collaborate14 in sunny Las Vegas amidst the desert of Nevada, I just arrived in not-so-bitterly cold Ottawa, the capital of Canada. Looking forward meeting with various Pythian colleagues and hanging out with the friends I cherish most.

My Exadata IORM session went well. Lots of follow back discussion plus questions are still pouring in. I promise I will answer them as soon as I return to Australia after couple (more...)

DBRM for 12c Container Database in Multi-tenant Environment

In multi-tenant environment, Database Resource Manager (DBRM), at the Container Database (CDB) level enables us to manage the resources like CPU usage and number of parallel execution servers among the plugabble databases (PDBs). Then within each PDB, DBRM enables us to manage resources like CPU, parallelism and managing the runaway queries which exceed the certain thresholds of CPU, physical IO, logical IO or elapsed time.

In 12c version of Oracle database, at the CDB level, (more...)

Speaking at Collaborate14 in Las Vegas

12c Multi-Tenancy and Exadata IORM: An Ideal Cloud Based Resource Management



Cloud database enables administrators to scale up and down the resource usage according to the business requirements. Oracle 12c renders multi-tenancy to manage multiple pluggable databases within a multi-tenant container database. In an Exadata, at the compute nodes, the resource manager controls the resources among pluggable databases, and all this resource management is trickled down to the storage servers, where IORM controls the resources. (more...)

IORM Architecture in Exadata




From the database notes, the I/O requests are sent to the cell nodes. These requests go through the intelligent iDB protocol containing information pieces like database name, category name, consumer group etc. These I/O requests are placed (more...)

Most Simplest Example of Big Data Ever

When I have to travel by air to somewhere, I go to a specific website to search and book my flight. Every time I visit that website, I encounter the same experience. I have to go through the same steps according to my same preferences, every time I need to book the flight.

Here is what I always do to book my flight at that website on each visit:

  1. Sign in with my userid
  2. Type (more...)

My Article on SearchOracle about Exadata Administration

The massive explosion in data, combined with an ever-increasing hunger to boost processing speeds while keeping costs low, has led to engineered systems in data centers.

Read More

Attended UKOUG Tech13 and Oaktable World UK

In cold, yet dry Manchester’s winter, it was quite thermal to simultaneously relish the meritorious UKOUG Tech13 and elite Oaktable World UK 2013 conferences. Pythian’s presence was overwhelming at both congresses. Paul Vallee, Alex Gorbachev, Elliot Zissman, Luke Davies, Paul Logan, Maris Elsins, Marc Fielding, Christo Kutrovsky and Michael McKee (more...)

Off to UKOUG Manchester UK

I am reserved speaker at the UKOUG this year in Manchester and will be traveling almost full length of globe to reach Manchester next week from Australia. Looking forward for technology-packed, fun-infested event. Pythian will be there again in full force too.

Will keep you posted from there :)

SQL_ID in Auto Trace Explain Plan Only

It would be a great enhancement to the nifty and very helpful set autotrace explain plan only statement if it showed the SQL_ID of the query in its output. Currently it shows the SQL Text and the PLAN_HASH_VALUE, but not SQL_ID.

May be an enhancement in Oracle 12cR2 :)

To Get Serial Number of Exadata Rack or Individual Server in Exadata

For the whole Exadata rack serial number:

ipmitool sunoem cli 'show /SP system_identifier'

For the server serial number you are connected to:

ipmitool sunoem cli "show /SYS product_serial_number"

For each component serial number on a single server:

You can also get the individual serial numbers for each component in an (more...)

Simple Way to Get SQL ID of Large and Similar Queries in Oracle

I frequently get clients' request to tune number of queries related to some application or reports. One of the first things to start the tuning process is to get the SQL_ID of the queries. On a busy system, it can be quite a hassle to find out SQL_ID of a (more...)

My First Book Co-authored with Michael Abbey et al is Out from Oracle Press

Writing is a joyful and stressful experience simultaneously. Writing a book is something very different from writing a blog or even a paper.

Thanks to my friend and my colleague at Pythian, Michael S. Abbey for providing me the chance to co-author the book Oracle Database 12c: Install, Configure & (more...)

Compatiblity Quirks of PDB with CDB of pluggable database feature of Oracle 12c

I was playing with converting an existing Oracle database to pluggable database and to plug it in the container database. Earlier I had created that non-CDB or in other words the good old database in 12c without any options like APEX etc.

Before plugging this non-CDB database into the CDB, (more...)

To Check if database is Container Database in Oracle 12c

[oracle@sourcetest ~]$ sqlplus '/ as sysdba'

SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 25 19:57:38 2013

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced (more...)

Install Goldengate on Oracle 12c Exercise

Though still Oracle Golden Gate for 12c version of database hasn't been released, nonetheless I tried playing with it and surprisingly went quite far, though at the end it failed with some OCI errors and after a while the status of extract process became abended.

The interesting thing is that (more...)

Silent Install Oracle 12c software and database Console mode

Following are the steps to install Oracle database 12c in Oracle Linux 6.4.

It assumes that OS has been installed, Oracle 12c software has been downloaded, per-requistes have been configured (best way is to use Oracle pre-install rpm).

Step 1:

Create /etc/oraInst.loc file and make following entries in (more...)

Oracle 12c Pre-install Installation

Oracle pre-install rpm is used to automate the setting and checking of per-requistes at the OS for the installation of Oracle RDBMS. All you have to is to install it and after that you can go ahead and install Oracle 12c. pre-install rpm can be downloaded from the YUM among (more...)

How to update JDK on Oracle Enterprise Linux from version 1.6 to 1.7

JDK is the environment to develop Java programs and updating java on Linux boxes is a requirement which often comes up. The following lists the steps required to update the JDK from version 1.6.0_22 to 1.7.0_21.


Step 1: Download the JDK rpm from the following link:

(more...)

gv$cell_thread_history ; A Nice View

There are certain dictionary views available to monitor the Exadata cells from the database.One of the view is gv$cell_thread_history. This view is very interesting as it delves down to the session level with its serial number, SQL, specific cell, instance and also which Exadata object was waited and every (more...)

Log Buffer #318, A Carnival of the Vanities for DBAs

News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.

Oracle:

(more...)