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 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 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 factor?
•What are the key aspects of the Absorption factor?
What [...]

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 factor?
What are the key aspects of the Action factor?

What [...]

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 quickly [...]

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 Approach?
What are the key aspects of an Approach?
How does [...]

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 competency to do a certain kind of work at [...]

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 key Attitudes?
3. How do Attitudes Impact Accomplishment?
4. How can you [...]

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 answer in order to give a better understanding of [...]

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