We continue our discussion on Oracle access paths. In this blog, we?ll learn about the SQL*PLUS Autotrace utility and everyone?s favorite tracing tool SQL Trace. Since there is an abundance of...
Now that we have a firm understanding of Oracle's plan table and V$SQL_PLAN, let's continue our education by learning how to format the raw data contained in these two objects. In addition, we'll...
We continue our series on system triage by learning how to find the access paths our poorly performing queries are taking during execution. In this blog, we?ll review the two data objects that...
Now that we have used 10G DBConsole's toolsets to identify the top resource consumers, our next step is to determine the access paths our poorly performing queries are taking. This series of blogs...
In part three of this series, we'll use 10G Grid Standalone to identify the top resource consumers for a given instance. We'll learn that 10G's DBConsole is able to provide us with all of the...
In my previous blog, we discussed the investigative process used to determine exactly what application component is causing the performance problem. This blog will cover the various Grid Control...
Those that excel at tuning understand that the tuning process starts with an understanding of the problem and continues with the DBA collecting statistical information. Information collection begins...
I thought I would spend one of the last few blogs in this series by discussing the importance of soft skills. If you want to remain competitive in this profession, you must be able to communicate...
This blog will provide you with some hints and tips that will help you obtain the most benefit when you attend ?Old OU? (Oracle University). I?ll also provide some recommendations to help you pass...
Database administrators are much more than just ?table jockeys.? Because of our well-rounded expertise, we are often asked to help evaluate third-party business applications, application development...
