Anyone who’s familiar with tuning SQL knows that you need to get the execution plan for a query. But once you’ve got an execution plan, what do you do with it? Everyone understands that an execution plan is important for diagnosing, but almost no one knows how to answer questions like “which step in the execution plan is taking the longest?” “Which hardware component (CPU, Memory, Disk) is causing my query’s bottleneck?” “Is my parallel query making good use of its resources, or are they being wasted?” If you have the Oracle Tuning and Diagnostic Pack license for your database and 30 seconds, you can find the answer to these questions–and more!
Presented by Kaley Crum, ABC Financial Services
Part of Quest Experience Week. Click here for more information.