Search results
System Triage IV - Access Path Identification Part I
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 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.
Monday, November 20, 2006
|
Permalink |
Comments (1)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-11-18.7319544765/sbtrackback
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 information we need to identify the top resource consumers, what resources they are consuming and the SQL they are executing.
Monday, November 13, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-11-10.6780804300/sbtrackback
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 and Host Monitoring Tools we can use to further drill down into the database ecosystem (database, O/S, hardware server) to provide us with additional diagnostic information. In future blogs, we’ll continue our investigation using Grid Control’s database performance monitoring and analysis tools.
Monday, November 06, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-11-04.1538832230/sbtrackback
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 at a global level and then narrows in scope until the problem is pinpointed. Part 1 of this series provides hints and tips that can be used to determine what architectural component is causing the problem. In subsequent blogs, we’ll learn how to use the toolsets provided in Oracle9I and Oracle10G to continue the investigation.
Monday, October 30, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-10-28.8698342650/sbtrackback
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 effectively. I'll provide you with a few helpful hints and tips to improve your verbal and written communication skills.
Monday, October 23, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-10-20.6229555671/sbtrackback
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 the Oracle Certification Exams.
Monday, October 16, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-10-14.0635922648/sbtrackback
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 tools and database administration and monitoring products. Over the years, I have developed a Product Evaluation Methodology that you may find helpful.
Monday, October 09, 2006
|
Permalink |
Comments (1)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-10-07.2939694079/sbtrackback
I’ll provide you with a quick preview of the last few remaining blogs on this topic. I’ll be taking a one-week vacation and I’ll see you back here in two weeks!
Monday, September 25, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-09-23.7237763466/sbtrackback
Ever look at a screen’s output and get that puckered feeling in the pit of your stomach? If you have been working in this profession for any amount of time, you know the feeling I’m talking about. The feeling that makes you think you would rather be living in Montana making woodcarvings at a roadside stand than being a DBA. I’ll be taking a somewhat lighthearted look at the perils of our profession and discuss ways to reduce problem occurrences.
Monday, September 18, 2006
|
Permalink |
Comments (2)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-09-17.9516775168/sbtrackback
The next few blogs in this series provide readers with miscellaneous hints and tips to enhance their skill sets and improve their ability to provide quality support to their customers. In my next blog, we’ll look at “Paranoid DBA” best practices.
Monday, September 11, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-09-10.8657066083/sbtrackback
