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.
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.
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.
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.
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.
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.
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.
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: