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

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

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