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.

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s