30 Oct
Let’s Get Technical! – Using Deductive Reasoning and Communication Skills to Identify and Solve Performance Problems
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.