How to Figure Out Why Your Query Is Taking Foreeeevvvvveeeerrrrr...IN LESS THAN 30 SECONDS!
-
Posted by Quest Customer Learning Team
- Last updated 7/07/20
- Share
Quest Forum Digital Event 2020
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!
Watch the full-length video
Premium Content: access is limited to Quest Corporate and Professional members.
Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.
