Neeraj Bhatia's Blog

February 5, 2013

Step away from the spreadsheets

Filed under: Other Discussion — neerajbhatia @ 21:50

Yesterday there was a news published on WSJ titled “Four CIA Secrets That Can Boost Your Career”

Point 3 tells an interesting story about a situation where human intelligence people made a mockery of the spreadsheets and based on which america spread the propaganda for quite long time that Iraq is sitting on a stockpiles of weapons of mass destruction (WMD).  The truth turned out to be completely opposite.

Corporate world is full of such stories where so-called “smart people”  over-rely on numbers but actually the metrics, forecasts are far away from the ground reality. Being from a capacity management field I face such scenario on a daily basis where people can’t help themselves and their complete thought process revolves around numbers. The term I would use for such people is data-aholic.

The important point to make out is one should understand the underlying meaning of the data they’re dealing with. But during my interactions with people over the recent years who claim they do technical work (for example;), but when someone peeps through the curtain, it come to know that they’ve been doing their technical work in spreadsheets.

In the times where everyone is trying to automate everything, logic being put into kernels, little room for technicians/administrators, wisdom of people are deteriorating, its not a surprise that people taking decisions purely based on numbers.

God bless us!


July 26, 2011

Data Loss, Disaster and Pain

Filed under: Other Discussion — neerajbhatia @ 19:04

Today, after 2 days of incident, Dell Support confirmed that my hard drive is failed. I was keeping hope that it would be due to mother-board, memory stick etc, but happening in a Murphy’s law way, the problem zeroed down to hard disk. The part of a computer system where actual data resides.

And in my case, it was not only data but the data which meant to me a lot.  To name some things – I was actively working on a book, so lost one-month worth of my chapters,  in parallel working on 3 technical papers and research work, which all lost, 2 month’s efforts and research lost. All my web-accounts and financial data/ acc-info is lost.

I am socked, angry, frustrated and hopeless all at the same time. Don’t know how much time it will take to recover from this painful situation.

Lessons learnt.  That’s the only positive thing I can say now.

October 10, 2010

How to become Oracle Guru (10,000 hour rule)

Filed under: Oracle - General,Other Discussion — neerajbhatia @ 18:10

Recently there was an interesting thread on OTN forums where an Oracle DBA asked for career advice. During the discussion, it went into an interesting direction when Oracle experts Jonathan Lewis and Tom Kyte jumped into the discussion and shared the secret of their success. As per Jonathan, one needs 5 years of focused effort to become a guru like him, Tom Kyte, Cary Millsap and Tanel Poder.

This 5 years (or around 5 years) is a point to note here. There are around 1,800 days in 5 years and 6 hours per day means around 10,000 hours in total to practice and learn Oracle. While reading the thread Immediately I did these calculations in my mind and resulting 10,000 hours thing ring a bell in my mind that I’ve read this somewhere.

In Nov’2008 a book named ‘Outliers’ was released by my favorite author, and I think most influential of our time, Malcolm Gladwell. In the chapter II, Malcolm discusses how 10,000 hours rule play an important role in someone’s journey towards perfection. He took examples of Bill Joy, Bill Gates, the Beatles and also shared some study results. For the sake of giving an example, let me summarize Bill Joy.

Bill Joy is a legendary computer scientist who had written UNIX language and after graduating co-founded Sun Microsystems, which recently acquired by Oracle. Bill did his B.S. from University of Michigan. He joined Michigan in the fall of 1971, the very first year when the university’s computer center opened. Michigan was one of the first universities in the world to have time-sharing system, where hundred people could do programming simultaneously.
Bill Joy did programming eight to ten hours a day during Michigan. In 1975, he enrolled for M.S. at Berkeley. There he buried himself even deeper and did programming day and night. He used to stay up until two or three in the morning. As per Bill, he became proficient programmer by his second year of Berkeley. Bill confirmed that it was the time when he had completed his 10,000 hours of practice.

Now, let’s come back to our original discussion of how to become Oracle guru.

As per the thread, Tom took around 6 years to become an Oracle expert (Oct’94 – 2000) and Jonathan suggested one should practice for 5 years to become proficient. In Back to Basics presentation, Tanel Poder shares his knowledge curve and as per him, it took him around 6 years (1999 to 2005) to become expert and during 7th year of this learning journey, he had release his high-profile snapper. I am not sure about the practice time for other Oracle gurus like Cary Millsap and for that matter Julian Dyke, but one thing I can say that they must have completed 10,000 hours of practice.

Now the question should be, can anyone become a proficient in his/her field by practicing. Malcolm touched this thing and suggested that there is a thing called innate talent and achievement is talent plus preparation. For example, not every person reading Oracle documentation will have same set of questions in this mind, test those scenarios and eventually learn from them. Talented people have divergent thinking, inquisitiveness, skepticism which enable them to learn different and new things, which otherwise people tend to ignore.

Now other than talent and practice there is a third (and perhaps most important factor in some examples) called opportunity. Malcolm explained how opportunities helped above successes in a big way. There were stream of opportunities that came Bill Joy’s way, for example. Because of University of Michigan, he was able to practice on time-sharing systems instead of with punch cards, because the university was willing to spend money, he could stay up all night; and because he was able to put in so many hours, he was able to get the opportunity to rewrite UNIX.

I am not that much fortunate to meet others, but I had met Jonathan Lewis in Hyderabad during AIOUG meet last month and where I had asked this question and he kindly replied that he had been asked to learn Oracle by reading the manuals and he did a lot of practice and study to learn the “new” software (perhaps Oracle version 5.1). At the time when Oracle was evolving, Jonathan had something under his belt which made him ahead from others in the game. Isn’t that a great opportunity that your organization ask you to become familiar and learn new software application, which after some years become No1 in it’s domain and there are not many people around which know it better than you.

So in short, talent does matter but what mattes a lot is practice and it’s 10,000 hours of practice which makes your brain to assimilate all that it needs to know to achieve true mastery. Practice isn’t the thing you do once you’re good, it’s the thing you do that makes you good. As Frank A. Clark quoted “Continuous effort — not strength or intelligence — is the key to unlocking our potential”.

May 5, 2008

RAC Administrator Certified Expert certification.

Filed under: Other Discussion — neerajbhatia @ 07:04

RAC expert logoThis saturday I have written certification exam 1Z0-048 and scored 100% marks


April 16, 2008

Surprised impact of Improved Performance

Filed under: Other Discussion — neerajbhatia @ 07:13

It’s always desirable to have database running in optimal performance state. I, as a DBA, even have same desires. But sometimes improved performance may negatively impact on the system users and left you in a situation where you don’t know how to react.

I personally have such an experience. Two years back, I worked for a customer from telecom domain. One of their call center’s application had performance problem. They log a Service request for optimization. Basically, call center guys generate a report on daily basis for number of complaint received. This is for management for MIS purpose. They observed that now it take more than 1 hour to generate the report.

I as a performance DBA, trace the session for report generation and observed that only one query out of several is bottleneck. Query is based on a table whose size is more than 15 GB. Since they were retriving only 1-day of data, I range-partitioned the table on complaint_date column. After partitioning, report completed in 7-10 minutes.

User’s first reaction was, after implementation, report generation was having some problems. When I asked what was the problem, he said, it was not generating complete report. His logic was, it just finished in 10 minutes, so it was not running completely.

I smiled and said “what they guys were expecting from this exercise, performance improvement or something else?”

April 15, 2008

Oracle RAC Certification 1Z0-048

Filed under: Other Discussion — neerajbhatia @ 07:06

I started preparing for the exam on 1st April and planning to write it on 25 or 26th April.

While preparing for the exam, I strongly feel the need for Practical exam (as in OCM) instead of objective-questions based. Since it’s an expert-level OCP exam, there must be a 1-day practical lab-based exam which should check practical knowledge like RAC installation, solving performance problem, configuration …

There may me my drawback also. It’s fees may go sky-rocketed as the case with OCM exams.

What do you think?


Blog at