Sunday, April 13, 2014

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 of weeks. That reminds me of my flight from one corner of the globe to the other, but well I need to learn as how to sleep like a baby during flights. Any ideas?

Ottawa reminds me of Australian capital Canberra. It's quite a change after neon-city Vegas. Where Vegas was bathing in lights, simmering with shows, bubbling with bars, swarming with party-goers, and rattling with Casinos; Ottawa is laid-back, quiet, peaceful, and small. Restaurants and cafes look cool. Ottawa River is mostly still frozen and mounds of snow are evident along the road sides with leafless trees.

But spring is here, and things look all set to rock.

Monday, March 17, 2014

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.

Tuesday, February 11, 2014

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. This presentation lucidly explains as how a business can leverage the benefits of 12C multi-tenancy, DBRM, and IORM in an Exadata realm to have an ideal cloud based resource management.

 

Following is the welcome page for the Collaborate14.

Thursday, February 6, 2014

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 in the CELLsrv I/O queues in the order they are received. Then these I/O requests are passed to the IORM, which prioritize these requests on the basis of IORM plan and then places them accordingly into the Cell disk queues.

Monday, January 27, 2014

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 in my origin and destination (90% of time same)
  3. Type in dates
  4. Sort the results by lowest price
  5. Search for flights with lowest price and least hops (Direct are ideal)
  6. I prefer red eye flights, so I also look for them.
  7. After searching for long time, I come close to what I want and then book it.
Despite of my log-in, despite of my usual pattern of purchase, website doesn't know what I am looking for. After my log-in, all they present to me is my personal details, limited travel history, reward points, and offers based on those reward points.

In other words, they present me with Small Data.

How nice would it be, if after sign-up they ask me in simple words:

Hey Fahd, are you still your old miser-self and want to get the cheapest direct flight(s) from Darwin to Sydney at that godforsaken time at night?

I would then just laugh, click yes, give me travel dates, and they would present me with options tailored to me habits. I know they would have to go through lots of data, anlayze it, slice it, dice it, and then come up with that above statement. I know I am not their only customer, and so they have to do the same for hundreds of thousands of their customers with more complex patterns, along with sifting through data of their partner airlines, may be hotels, car rentals, etc.

In other words, they have to go through Big Data.

Saturday, January 25, 2014

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

Monday, December 9, 2013

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 rocked the events.


Everyone was spoiled for the choice of the sessions. I remained focused on the engineered systems and performance tuning. Both conferences soaked me up in plenty of sessions from these tracks and much more. Jonathan Lewis talked about compression, and CBO. Tom Kyte also bestowed with his keen outlook on the various features. Pythian’s folks Luke Davies, Maris, Alex Gorbachev, and Michael Mckee shared their great insight too.


Tuesday, November 19, 2013

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

Wednesday, October 30, 2013

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

Friday, October 4, 2013

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 Exadata Rack like this:

/opt/oracle.SupportTools/CheckHWnFWProfile -S

Note: Run those commands with root user