20 Nov
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.