Kaley Crum, Riceland Foods
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 30 seconds and the Oracle Tuning and Diagnostic Pack license for your database, you can find the answer to these questions—and more!
Become a member of ODTUG to gain access to more than 12,500 files in our technical database.
- Not a member? Click through to the topic of interest to browse a list of available presentations.
- Already a member? Log-in here to access the full database
Click here to see the Full Techincal Resource Database