Almost one year to date since my last blog. A year has gone but it seems like yesterday. Don't ask where I was and what I was doing, it...

If your application happens to be one where surrogate keys are used in abundance and if some of those tables are inserted/updated very...

Today most Java programmers use some type of JPA like Hibernate or TopLink to traverse the world of Objects and Relations Databases like...

One of the simplest and often overlooked act when designing a data model in Oracle is omitting indexes on foreign keys. While I am not a...

One of the often overlooked aspect of Oracle RAC is the impact of large changes on heavily accessed tables on overall RAC responsiveness....

Oracle has another nifty report that helps you dive into more granularity on the happenings within a DB that AWR reports cannot. ASH...

In this article I am going to narrate a rather strange performance issue that I was pulled into. One of our client's called me to inform...

In my previous blog about interpreting AWR reports in Oracle, I had only skimmed the surface, enough to give any one a quick idea of what...

Ok, as another year rolls over and you wonder what happened, why everything in 2013 seemed like a blur just like the years before then...

This post is primarily for the Oracle DBAs out there who would like a quick look at the load on a database, be it single instance or RAC....

In the previous articles I have explained simple methods on how to interpret an AWR report, how to find an expensive SQL and how to tune...

The last two blogs that I had about a “Layman’s guide to AWR” and “How to find expensive SQL”? should help one identify or smell out...

If you have worked in IT long enough then it is hard to miss the acronym "AWR". AWR is short for Automatic Workload Repository report and...

Most often than naught you may find yourself wondering what is causing all the latency in the application. You quickly decide without any...

In last month's column I had given a brief overview of this whole business called Cloud Computing. In this column I will tell you why...

I wanted to take a few minutes to pen some of my thoughts about the so called "Cloud" revolution that has been underway for a few years...

I think today in most organizations, the answer to the above question lies at the two extremes. Either you have organizations that are...

Another grey area in an age where everything and anything is obsessively analyzed and measured, is the question regarding how one can...

Most people who have worked on other Unix flavors like Solaris, HP-UX, IBM AIX, etc not used to Linux may have never heard of an OS...

I am sure you have heard the familiar adage espoused by most database and storage vendors - Stripe And Mirror Everything (SAME). This...