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