We continue our discussion on the various tools that DBAs can use to identify high resource consuming SQL statements.  We started by learning that there are several data dictionary tables that we can access using SQL statements to retrieve information we need.     The next blog focused on the 10G DB Console.   We found that the 10G DB Console [...]

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

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

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

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

We continue to analyze the effects that initialization parameters, statistics and hints have on SQL statement access paths. In this blog, we’ll take a look at the hints we can use to influence the optimizer to select an access path that is different from the one it would normally choose. We’ll also review a few [...]

If you want to become an access path guru, you’ll need to spend some time learning how optimization parameters, statistics and hints affect SQL access paths and statement performance. This blog will provide you with a few hints and tips to help you begin your scientific analysis of the Oracle optimization process. In upcoming blogs, [...]