Now that we are ready to continue our education on access path scientific analysis, we need to begin identifying some representative queries that we can monitor and tune. There are numerous ways to identify the top resource consumers for a given instance. We’ll learn that 10G’s DBConsole and 11G Grid are both able to provide [...]

In an earlier post, I identified and briefly described the “Seven A’s of Accomplishment”: Ambition Attitude Aptitude Approach Action Absorption Adaptiveness In my last post, I described the Action factor.  In this post, I will expand upon the sixth Accomplishment factor: Absorption.   I will do so by answering the following questions: •What is the Absorption [...]

In an earlier post, I identified and briefly described the “Seven A’s of Accomplishment”: Ambition Attitude Aptitude Approach Action Absorption Adaptiveness In my last post, I described the Approach factor.  In this post, I will expand upon the fifth Accomplishment factor: Action.   I will do so by answering the following questions: What is the Action [...]

Now that we are ready to continue our discussion on access path scientific analysis, we need to begin identifying some representative queries that we can monitor and tune.  There are numerous ways to identify the top resource consumers for a given instance. We’ll learn that both the10G and 11G DB Consoles are both able to [...]

In an earlier post, I identified and briefly described the “Seven A’s of Accomplishment”: Ambition Attitude Aptitude Approach Action Absorption Adaptiveness In my last post, I described the Aptitude factor.  In this post, I will expand upon the fourth Accomplishment factor:  Approach.   I will do so by answering the following three questions: What is an [...]

In an earlier post, I identified and briefly described the “Seven A’s of Accomplishment”: Ambition Attitude Aptitude Approach Action Absorption Adaptiveness In my last post, I described the Attitude factor.  In this post, I will expand upon the Aptitude factor.  According to Wikipedia, Aptitude is “an innate, acquired or learned or developed component of a [...]

A few recommendations from your friendly ex-Oracle instructor on resources that will help you learn more about Oracle access paths. These resources will benefit beginners and tuning gurus alike.  We don’t need to be access path scientists just yet.  What we are attempting to do is learn the fundamentals of access paths to assist us [...]

In an earlier post, I identified and briefly described the “Seven A’s of Accomplishment”: Ambition Attitude Aptitude Approach Action Absorption Adaptiveness In my last post, I described the Ambition factor.  In this post, I will expand upon the Attitude factor. I will do so by answering the following questions: 1. What is Attitude? 2. What are the [...]

In an earlier post, I identified and briefly described the “Seven A’s of Accomplishment”: Ambition Attitude Aptitude Approach Action Absorption Adaptiveness In my next seven posts, I will expand upon each of the seven factors in more detail.   The first factor I will expand upon is Ambition.  There are four questions I will attempt to [...]

Now that we have an understanding of how we can influence access paths using hints and session parameter changes, let’s continue our discussion by reviewing the various types of indexes as well as indexing strategies that affect Oracle access path selection. We’ll complete this series next week when we use all of the information we [...]