Oracle Performance Tuning

In these post I’ll try to explain the performance troubleshooting approach by describing the case studies that I came across, how I approached them and then how gradually how the approach became a strategy, a generic strategy, that now I follow for almost all of the Performance issues that I deal with.

As the intention of this blog is to keep it as simple as possible, I’ll try to describe the case studies in as simple way as I can, BUT throughout the post I’ll believe that you have basic understanding of Oracle architecture which is described in my post Oracle Database Internals.

All you need to know to be a performance troubleshooting expert is ORACLE ARCHITECTURE, rest comes with the approach you take, and experience. Hence from the subsequent posts please get a good hold of Oracle Database Internals and leave the approach and experience to me, I’ll take you through the journey of my experience and develop the approach as I have been developing mines.

5 thoughts on “Oracle Performance Tuning

  1. Pingback: Oracle Wait Events | Oracle Database Internal Mechanism

  2. I have noticed you don’t monetize your page, don’t waste your
    traffic, you can earn additional cash every month because you’ve got hi quality content.

    If you want to know how to make extra money, search for: Boorfe’s tips best adsense alternative


  3. Pingback: Oracle Locking Mechanism – Latches & Enqueues | Oracle Database Internal Mechanism

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.