Access Path Scientific Analysis Part VI- Identifying Top Resource Consumers Using 10G DBConsole

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.

Continue reading Access Path Scientific Analysis Part VI- Identifying Top Resource Consumers Using 10G DBConsole

Access Path Scientific Analysis Part V – Identifying Top Resource Consumers Using SQL Statements

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.

Continue reading Access Path Scientific Analysis Part V – Identifying Top Resource Consumers Using SQL Statements

Access Path Scientific Analysis Part IV – Optimizer and Access Path Educational Resources

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 our upcoming access path analysis efforts. We’ll have plenty of opportunities to learn as we go.

Continue reading Access Path Scientific Analysis Part IV – Optimizer and Access Path Educational Resources

Access Path Scientific Analysis Part III

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 have learned to perform our own scientific analysis on Oracle optimization.

Continue reading Access Path Scientific Analysis Part III

Access Path Scientific Analysis Part II

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 of the tools that we will be using to monitor and compare SQL statement access paths and performance for our upcoming tests.

Continue reading Access Path Scientific Analysis Part II

Access Path Scientific Analysis – Access Path Identification Part II

We are continuing our series on how to become access path scientists. In previous blogs, we This series of blogs begins with a high-level overview of Oracle query optimization. We’ll also learn the difference between estimated and runtime access paths. Subsequent blogs will provide details on the various tools we can use to retrieve access path information.

Continue reading Access Path Scientific Analysis – Access Path Identification Part II

Access Path Scientific Analysis Part I

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, I’ll provide you with some sample test cases.

Continue reading Access Path Scientific Analysis Part I

The Art of Being a Successful DBA – Keeping Customers Happy, Part 2

Introduction
In today’s business environment, being a successful DBA is more than just being technical. If you want to excel in this profession, you must be seen as someone who understands both the business and technical aspects of the applications you support.

Continue reading The Art of Being a Successful DBA – Keeping Customers Happy, Part 2

The Art of Being a Successful DBA – Excelling at Verbal and Written Communications

I thought I would spend a little time discussing the importance of soft skills. If you want to remain competitive in this profession, you must be able to communicate effectively. I’ll provide you with a few helpful hints and tips to improve your verbal and written communication skills. The importance of improving your communication skills cannot be understated. I don’t care how strong of a technician you are, if you can’t communicate effectively with your peers, you won’t be able to succeed in this profession. In the old days, you might have been able to get by with just your technical skills. That is definitely not the case in today’s business environment.

Continue reading The Art of Being a Successful DBA – Excelling at Verbal and Written Communications

The Art of Being a Successful DBA – Finding Information Quickly

I have taught hundreds of people how to administer Oracle during my career as an Oracle instructor. For those of you just entering this profession, here is my most sage piece of advice:

Continue reading The Art of Being a Successful DBA – Finding Information Quickly