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 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 - 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:


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.



Log Buffer #294 Appears

Log writer process of Oracle is one of the most revered background process, a real work horse, a real charming darling who keeps the whole Oracle database system consistent and humming beautifully and many technologies in Oracle sprout from this good old process. Consistency is the key in database systems, and so in the Log Buffer Editions, and this Log Buffer #294 continues it. And yes, the coolest 2012 PASS Summit is also there.

Read More.